PowerApps Flow Intro Upload an image to SharePoint using Flow

[@ColPrice45]

Morning, Mr. Shane! I just want to give you a big thank you because your videos help me so much to create my very first Power app :D Btw, I also want to share that the code you use in 18:18 should be justified from dataUriToBinary(triggerBody()['CreatefileFileContent']) --> dataUriToBinary(triggerBody()['Createfile_FileContent']) - (underscore added), in order to work properly. It took me 2 hours to realise that. Hope it will help to whom might need :D Cheers!

[@ShanesCows]

Thanks Chan. 😎

[@chris8534]

Love how you do the walk through and after that doing the practical. Much easier to learn.

[@ShanesCows]

Thanks. 😎

[@Amr-Ibrahim-AI]

Indeed. It's great to first see what we will build then watch the steps to build it. Very helpful!

[@micksmith1640]

Just wanted to shout out to you Shane & express my gratitude for your hard work creating these videos - some of your content is absolutely invaluable! I have just started along the Flow/PowerApps journey and it's awesome, but frustrating too! The content you put out is brilliant and VERY helpful. Keep up the good work man.

[@ShanesCows]

Thanks Mick. I will keep making if you keep watching

[@vicbrookes9466]

Just want to say thank you Shane, not tried this yet but can’t wait to. You make things feel so much more manageable

[@ShanesCows]

Glad to help Vic. I have a lot of different videos that cover upload. THis one might also be of interest depending on how you are getting the files. kzbin.info/www/bejne/aYLEmoBuiMqKnK8

[@anon-24601]

Hi Shane. Seems like there was a change in Power Platform that has broken this demo. Any chance you could please drop an update in the description or pinned comment?

[@nforehand]

Thanks a million ... I followed the video to make my own app for the company with some tuning and adjusting and VOILA .. it worked perfectly :) ... can't thank you enough :)

[@ShanesCows]

Great to hear!

[@oshritcohen-shemesh2721]

Wowwwww Thank you soooooo much!!! you actually spent 2 days to make this cool, teaching, good video for us..... really appreciate this!!!

[@ShanesCows]

Glad to help. 😀

[@genolark]

Shane, First off let me say, your videos have helped me tremendously in figuring out to implement several functions into an app I am building for my work, which in turn is essentially a CRM replacement that is build perfectly for our needs. Now to my main comment, you mentioned in this video that you could not figure out how to upload any other files except images while using a flow. This is similar to a feature that we needed except that we do actually need to be able to upload any type of file since there can be a multitude of file types from images, to PDF files, to doc files etc., and so I was looking into the SharePoint list and Attachment Control within PowerApps and have figured out how to get it to work any file type and work for our needs. Here are the details in a brief summary of our setup. We are using a MySQL DB as the primary data source. I setup a table that would have all of the attachment details. I then created a SharePoint List with 2 fields, Title and sp_attachment_id. I then added the "Attachment" element to a new form which I linked to another form that has the MySQL Data Source. I then used Lookup formula to basically link the MySQL DB Attachment ID to the SharePoint List sp_attachment_id. I then setup the sp_attachment_id fields default property value to check if it is a new attachment, if so, then use the MySQL Attachment ID fields value and this now creates the link between the SharePoint List and the MySQL records. Now we can create a new attachment, upload our files from the desktop, save the record and it creates the new List entry with the attachments and it is linked to our unique record inside PowerApps. Now I know I could have setup a flow to pull over meta info but I just needed a way to upload files to our SharePoint list library as a means of storage while keeping all the meta within the MySQL record. If you would like I can give you more details on how I got this working.

[@jorgemolinasalas3210]

Hi Shane, i have been struggling with this Camera app until i found your video. Still struggling on saving peninput into sharepoint, but thanks to you i can now save photos from my app to Sharepoint. Thanks a lot for the content.

[@ShanesCows]

Glad I could help!

[@davecawthorn2234]

Fantastic video Shane, fills in a lot of gaps in my knowledge and your presentation style is just the best. I'm been tinkering at the edges with Powerapps doing simple things like visitor logs and such like but these videos are egging me on to try new things.

[@ShanesCows]

That is great. Be sure to share when you come me up with your awesome app.

[@iwayini]

Shane many thanks for making this video. I have learned a lot from you. Hope you have a great day! Greetings from Bedford, UK.

[@ShanesCows]

Thanks 😊

[@WychfinderYT]

Hi Shane. What a fantastic video giving a clear and easy to follow explanation of a complex project. I had a great sense of satisfaction successfully reproducing what you shared. I am looking forward to finding and seeing what other topics you cover. Thanks for all your hard work. Adrian

[@ShanesCows]

Glad to help. 😀

[@cainegoh]

well done shane ... your tutorial is informative, easy to understand and fun.. nice work ! thank you very much

[@ShanesCows]

Thanks Glad to help. 😀

[@juanignacioparedes7546]

This video is excellent, thanks Shane! Please keep uploading videos about power apps!

[@ShanesCows]

You got it! 👍 I am around 100. Probably should count 😀

[@danielpipe3378]

Got it! Got it to upload from Camera to SharePoint and Onedrive AND got it to upload from the "Add Picture" control to SharePoint (upload existing pictures from phone/desktop). The only challenge left is to get it to upload from Add Picture Control to OneDrive as that doesn't seem to accept the same Content as SharePoint does. My idea to workaround is to copy the whole file from SharePoint to Onedrive in Flow.... I'll let you know when I get it. Thanks for the video. You video URLs often end up on my hidden settings pages haha

[@ShanesCows]

kzbin.info/www/bejne/aYLEmoBuiMqKnK8 covers it.

[@lioneljohn7379]

At 32:50 Sec... Its mentioned about making the file name automatic. Anyone please help me know how it can be done to a text input field.

[@ShanesCows]

Automatic you would use a counter variable and make your own name. Or you could use the guid function to be real unique.

[@ifromurgut]

Hi, Shane! Really appreciate the video courses you are making. Good job! Please, keep on.

[@ShanesCows]

Thanks, will do!

[@colby4390]

For my "save to sharepoint" button It says "Issue Invalid number of argruments received 3, expected 2. Here is the expression: PhotoFlow.Run(TextInput1.Text & ".jpg", TakenPic, Dropdown2.Selected.Value)

[@TIMEPIECE66]

I've had same issue and can't figure it out, but the flow error details are: Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '2178': 'The template language expression 'dataUriToBinary(triggerBody()['CreatefileFileContent'])' cannot be evaluated because property 'CreatefileFileContent' doesn't exist, available properties are 'Createfile_FileName, Updatefileproperties_TypeOfAnimal'.

[@jamesoliver7962]

@15:15 you choose the upload a file to sharepoint template, "i could not find that" do you alternative method?

[@ShanesCows]

There should be an action for that. Look through all of the SharePoint actions.

[@Johhnietrigger]

Is there a possibility to upload an uploaded image by the user to Sharepoint? At 14:55 you mentioned it wasn't yet available, but maybe now (almost a year later) it has been added? Looking forward to your response

[@ShanesCows]

There is an attachment control you can use now.

[@gatitosvk]

@@ShanesCows Haven´t you made a video of that?

[@marcusselvik4699]

@@ShanesCows Also having trouble with this. Could you point to an explanation for this?

[@ThoughtDiffusion]

Hi, Adding documents can get created with content for txt files, not for other extensions of files, like docs, XLS kind of files uploading/Creating in the document library but not opening from sharepoint online library

[@ShanesCows]

Try this kzbin.info/www/bejne/aYLEmoBuiMqKnK8

[@markdelbiondi]

I definitely got excited haha. Love the way you present these topics. Keep it up 👍🏻

[@ShanesCows]

Thanks Mark 🐶

[@madhiazhagia9393]

Hi Shane, On submit form store the values in SharePoint library excel sheet...

[@ShanesCows]

Not possible

[@Raju19911000]

Absolutely Fanstactic Video at start i was getting some errors while with images And Flow but on step by step as i go ahead i got all the troubleshooting and App is currently working smooth as you shown. Thanks a lot Shane.

[@ShanesCows]

Cool 😊

[@pabeader1941]

Have you created an updated version of this? There are so many differences that I'm totally lost trying to learn from this one.

[@ShanesCows]

Not this exact one, man that was one of the first, but this video kzbin.info/www/bejne/mZvGdXttlNtpmac teaches uploads. I think it is the foundation you want. After you finish that video you could replace the attachment control from the video with the camera control.

[@pabeader1941]

@@ShanesCows I sure do appreciate that you are willing to respond to comments on these older vids.

[@udaysingha]

I had used the formula in Power flow which you shared "dataUriToBinary(triggerBody()['CreatefileFileContent'])". When I add this formula in flow, that flow got failed.

[@ShanesCows]

Sorry look for typos and check you errors. It should work

[@PhilipRivard]

Hello Shane. The resolution of the image creates on Sharepoint is really low. How can I adjust that. Also using your snippets "dataUriToBinary(triggerBody()['CreatefileFileContent'])" does not work inside flow. I use "Outputs" instead. Is this the problem ? Thanks !

[@ShanesCows]

The resolution is because the camera takes really small pictures. There is no way to change it. If you are using a mobile device then you can use the native camera app and size can be bigger

[@RowDogSA]

When you are doing 'Update file properties' and you select Library Name Documents, the 'TypeofAnimal' field just appears below Title. This does not happen for me. How did you add it?

[@ShanesCows]

The column was already a column in my library. Flow should show you all of the columns from the library automatically

[@DavesTechTips]

Golf clubs are hugely handy for when you have to write expressions in Flow.

[@ShanesCows]

Agreed.

[@TheEbbemonster]

But it is "No Code"!

[@fabioribeirodesouza7248]

Thanks Shane! Fantastic tutorial. Your videos help me a lot.

[@ShanesCows]

Awesome 😎

[@rainerrenn3813]

It was a very useful video, but sadly my "save" button doesn't still work. I added -> Pildistamiseks.Run(TextInput1.Text & ".jpg", TakenPic, Dropdown1.Selected.Value) But sadly I get error that "Invalid number of arguments, received 3, expected 2". Looks like the problem is on my DropDwon field. If I remove it, then everyone looks "OK". But still, what may be that problem? I was double-checked that "DropDown = Items" and Properties "Value = Value"

[@ShanesCows]

The problem is with your flow. 😑 You only asked in Power Apps twice in the flow of 3 times.

[@victoriaharris4077]

Hi Shane, what would you put to reset the photo taken when you hit submit. I can get the form and file name to reset but can’t quite find the fight combination to reset the picture so it’s blank for the next upload! Thanks

[@ShanesCows]

Set(varPic, Blank()) should do it.

[@eric9973]

Hi. Thank you for your video. The picture is not coming out in the TakenPic image when I click the Take Photo button. Hope you can help me. May I know how to capture picture and save to Onedrive?

[@ShanesCows]

Is the picture getting there but just opening blank or not getting there at all? Any error messages?

[@JohnsonVettuvelil]

Update the Streamrate from 0 to 100

[@chengcheng7682]

Hi, may I know is possible upload the photo to different folder based on the account or selection of metadata ?

[@ShanesCows]

Yes, you need to pass the path for the folder by asking in Power Apps

[@valentinavacarez1245]

Have you been able to upload a photo from Power Apps to a SharePoint Online List? I'm trying to upload a photo from power Apps to a SPO list and view the image in the list view. The issue is the photo column requires a url/hyperlink but PowerApps creates a Database64?

[@ShanesCows]

Have you seen this? PowerApps upload file to SharePoint document library kzbin.info/www/bejne/aYLEmoBuiMqKnK8

[@whitearmourfilm]

At 25Min when I enter VideoFlow.Run(TextInput3.Text & ".jpg", TakenPic, Dropdown1.Selected.Value) I am getting an error for my button (Invalid Number of Arguments, recieved 3 expected 15). Any help appreciated!!

[@ShanesCows]

Your flow has more Ask in PowerApps dynamic contents

[@zchase6631]

if i miss it somewhere but do you have anything to pull back from sharepoint, a galley list of the photos.

[@ShanesCows]

How about the video from this week? kzbin.info/www/bejne/q17FaapvmsZkoc0

[@jalalsemaan8129]

Hi Shane, the camera need rotation by 90 degree. Is there a way to rotate the camera (using built-in laptop camera)?

[@ShanesCows]

Not that I know of. The image control has a rotate option but nothing I can think of for the camera. 😐

[@claires9018]

Any tips on making this week with the ‘Add picture’ feature instead? I’ve set up the flow but can’t seem to trigger it to run - where are the file contents?

[@ShanesCows]

Try this. kzbin.info/www/bejne/aYLEmoBuiMqKnK8

[@sianminggoh7413]

Hi Shane, any idea how to do this for multiple photos? Taking the photos then pressing one button to upload all of them in one go

[@ShanesCows]

Use the ForAll function kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@haierplumbing424]

Hi! I think I got this app working but I am wondering if it's possible to let the user choose what folder on the Sharepoint the image saves to? Mine is saving to Documents > Customers and there is a bunch of folders there (one for each customer) and I want them to choose which one to save it to.

[@ShanesCows]

Well, maybe. You could see if for the folder name Flow lets you ask in PowerApps. I am not sure. Sorry.

[@usmanrehan4657]

the dataUriToBinary(triggerBody()['CreatefileFileContent']) does not work for me in expressions. It keeps calling it an invalid expression.

[@ShanesCows]

I think you have the wrong fieldname in the dynamic portion

[@chinmaytawade1607]

@@ShanesCows this flow used to work before perfectly, but now gives an error. 'dataUriToBinary' expects its parameter to be formatted as a valid data URI.

[@engrelysium]

what if i need to create a flow that will send an email whenever something is updated and the email needs to have all the lists like how you have Last Name , First Name, Company, Business Phone etc having a hard time determining the action to send out the email with the list of records in the sharepoint that has been created or modified

[@ShanesCows]

Need to setup your Flow to accept all of those fields as ask in powerapps

[@dannielleszuba5699]

Awesome video, and I linked that you change the colors. This video has given me so many ideas.

[@ShanesCows]

Glad to help. 😀

[@piyushchowdri4858]

Hi Shane, I am working on a change management process approval app on power apps where all the information will be stored in sharepoint. I wanted to check if there is a way I can generate a unique ID number either on sharepoint or power apps, display it on power apps and store it with the list on sharepoint?

[@ShanesCows]

SharePoint automatically generates a unique number. It is the ID column.

[@Tasperen]

How would I go about allowing the user to take multiple pictures and upload all of them at once to SharePoint?

[@ShanesCows]

Put the images in a collection the upload them with ForAll. kzbin.info/www/bejne/aYLEmoBuiMqKnK8

[@jeffreymartin5944]

Shane, another great video even though it is almost 2 years old still relevant. The Workflow has changed slightly and now for the Create File => File Content there is a Dynamic content Convert to binary image method called Outputs which works...the code no longer works or I should say it did not for me. But all-in-all GREAT JOB!!! I enjoy your videos and the enthusiasm. Going to Share this with my Team for our Virtual SharePoint Saturday next weekend, they should enjoy it as well. Stay Safe!

[@ShanesCows]

Thanks Jeffrey

[@sagarkavishwar7071]

Thanks Shane, Is there any way we can upload images from Power app to Excel which is stored in Onedrive?

[@ShanesCows]

Probably but not something I have done in 3 years. This may give you a hint or two docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips

[@rebeccasackett6472]

Thanks for this...I took what you had on this one and another and combined the two basically and mine takes the photo, converts it to a jpeg and then places it as an attachment on a sharepoint list item because I needed the ability to download the photos later if they need to be sent to a customer. Your videos are always helpful..thanks!

[@ShanesCows]

Check out Azure Blob Storage for the best way (in my opinion) to handle images. kzbin.info/www/bejne/rXeTfqCflqyCldE

[@richardfarland]

Hi Shane, many thanks for this video. Do you have a video or instructions of doing this with the Add Picture control instead of the Camera control? We would like to upload (any file type) to SharePoint. We don't mind having to change from "image files" to "all files" in the select file dialog but don't want to use the attachment control method shown in your other video. (We upload a lot of large files in different parts of the app and memory profiling that method shows the JS heap getting hammered. Probably due to the global variables storing the intermediate encoding text).

[@ShanesCows]

I don't think so. YOu have to get the base64 of the file. You could use one variable instead of two as shown in the other video to at least cut down the heap.

[@PhongNguyen-vq5yo]

Hi sir, i followed exactly step by step on video. But i got error that said "Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '15701': 'The template language expression 'dataUriToBinary(triggerBody()['CreatefileFileContent'])' cannot be evaluated because property 'CreatefileFileContent' doesn't exist". Please help.

[@ShanesCows]

Did you "Ask in Power Apps" if you did then make sure your dynamic content matches.

[@mickyd4684]

Hi Shane. Brilliant video, but can you upload photos and metadata from a 'collection' to SharePoint document library? Can you wrap your PowerApps code you had for the [Save to SharePoint] button in a 'For All' function for a collection of photos and metadata? If so how, or can you please point me to another video that explains it as well as you do? I'm trying to create a site safety checklist form where the user can take one or more photos and Comment per photo per checklist item, then upload that to a SharePoint document library. Thanks in advance... from Melbourne, Australia

[@ShanesCows]

Try this kzbin.info/www/bejne/aYLEmoBuiMqKnK8 or this inspection app kzbin.info/www/bejne/hKjFopd3bs9re80

[@Sthriven]

How do you add a counter to the file name to ensure you don't overwrite any files?

[@ShanesCows]

Use guid function or now function to get unique values.

[@BharatPatel-lz7yq]

Works great for picture taken with camera but when I tried to use "Add Picture" control from Media, Flow gives an error:InvalidTemplate. Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '1900': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value 'appres://blobmanager/9d22d3a1fa3e4ccbb534c4913f752b79/2' was not formatted correctly. Please see aka.ms/logicexpressions#dataUriToBinary for usage details.'.Any suggestion.

[@ShanesCows]

Unfortunately no. The Flow only works with the camera control. Sorry. From there you have to get very creative.

[@cfhcaio]

Thank you for this great video! It helped me a lot to include photos of invoices in my expense report application and save to a SPList at the same time.

[@ShanesCows]

Cool

[@eugeniagher7297]

Hi shane! I ´ve made this flow but it uploads to the sharepoint library a file that is not jpg. Do you know why is that?

[@ShanesCows]

Usually you are missing the Flow expression base64toBinary

[@miguelfabrellas8323]

Hello! If you upload more than one picture at the same time by spliting a string that contains all of them and using "aply to each", how can we get the Path of each file???

[@ShanesCows]

You would have to store them in an array in flow and send back the array. Not easy but possible

[@MrDerus01]

Hey Guys, I am not sure why my image control won't change to the takenPicture variable. I have followed the video and for some reason it just doesn't work. I have added UpdateContext({takenPicture: Camera1.Stream}) in the onSelect of my "take a picture" button, and have added the takenPicture variable in the image equation of the preview Image picture, but to no avail. I am not sure if someone has had the same problem. Thanks in advance

[@MrDerus01]

sorry was the stream rate XD, set the stream rate to 100

[@ShanesCows]

Tomorrow’s video talks all about this. 🐶

[@balarameshsoleti165]

Hi Shane, thanks for the great video and education. Not related to your video but may be with my sharepoint settings. The issue is that when i uploaded a file to sharepoint from power apps , there are 2 versions of the file getting created 1.0 and 2.0 at the same time in sharepoint. When i view version1 in sharepoint it has blank values and version 2 has the file content and metadata. Any reason for this ? What can i do to fix this in sharepoint or is it a bug in power apps ? When i upload the file directly from sharepoint its creating only 1 version which is as expected . Any clue on this issue is greatly appreciated . Thank You

[@ShanesCows]

Interesting I have never noticed. I am not sure.

[@edwinarmandomunozcruz5004]

Hi Shane! I have a problem in the second step of the flow.(Create a file) I am trying to send and image instead of a picture. I believed thats the problem. The message says that " 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value 'appres://blobmanager/cea58486da8b410cba0486a9c7701a4d/1' was not formatted correctly. "So, could you tell me or somebody can help me or give me an advice about how to fix that. Thank you.

[@ShanesCows]

The control is not encoding the file they way Flow wants. Maybe try my JSON video and see if helps explain the difference. Some controls don’t share their output nicely. This is one of those cases.

[@shane4419]

What a helpful video, what a helpful guy. Thanks So much Shane!!

[@ShanesCows]

Glad it was helpful Shane!😎

[@JonH232]

Thank you! I followed your other video to upload to Blob, but due to the costly licensing (for Premium Connectors) I had to revamp the app to save to SharePoint. Nice and easy!

[@ShanesCows]

Excellent!

[@filipuppsall-sjogren114]

Great video which was just what I was looking, thanks Shane. Can inform that I couldn't get the integer in my runs to store... until I switched from integer to string.

[@ShanesCows]

Thanks for sharing! Glad you got it.

[@isobelsoo8723]

HI Shane, I follow the steps to paste the datauri to binary and etc. however my image doesnt seem to be converted to image form. can you kindly assist? thanks

[@chpengineerssurveyors2944]

The dataUriToBinary(triggerBody()['CreatefileFileContent']) says invalid for me in Flow. Has this been updated?

[@ShanesCows]

Insert the dynamic content. The ask in PowerApps must be slightly different than mine was.

[@matthewpaymer5590]

@@ShanesCows inserting the dynamic content "ask in powerapps" and then removing the default and adding your formula but using an underscore 'Createfile_FileContent' is what worked for me.

[@reneweber8399]

Thank you for all your Videos. I´m new in PowerApp and so your Video is really helpfull. But now i have this problem in the Flow: InvalidTemplate. Unable to process template language expressions in action 'Datei_erstellen' inputs at line '1' and column '2255': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value 'xxx.jpg' was not formatted correctly. We have an German Version off Office 365. Can you yelp me please?

[@reneweber8399]

Hey Shane, i have found the problem. Thank you for all your videos. I think you are the best in Powerapp

[@TheDom168]

@@reneweber8399 what is problem? I have same problem. Please help

[@juliogazeta3920]

Shane, please, what is the procedure for the Add Picture component?

[@ShanesCows]

Check on my video on Azure Blob Storage for add picture control

[@marilijew]

I stucked on the "Cooking on gas" Create file. Power Automate wasn't expecting to receive body for the file. An 502 error was returned... The test showed that the only expected inputs were File name and Animal... Then sudenly after putting "triggerBody()['Createfile_FileContent']" in *File content, the third input apeared on third position! Then I had to change the places of the body and the animal property in the X.Run(fileName&".jpg", Animal, Body). Another error was returned - 302. But after some 20 minutes and a delete/ select Flow it actually started working :) Pic resolution is low 480x640.

[@ShanesCows]

Glad you got it. 😎

[@emilydorscher6805]

In case anyone else runs into this issue since my option didn't allow for the template to be used in Power Automate (Flow): In Step 2 of your flow (SharePoint 'Create File') when you put in the dataUriToBinary expression, start by going to the Dynamic Content and search "Ask in PowerApps". This will link the triggerBody to PowerApps. Then, replace that expression with the one Shane provided. It took me forever to figure out why when I went back into PowerApps it was only asking for the Createfile_FileName on my Run. Once I did that additional step in setting up my flow, no problems. I hope that all makes sense...

[@ShanesCows]

Thanks for sharing Emily 🐶

[@mplinnet9]

THANK YOU!

[@bunditrillovargas5396]

Thanks! I was having the same error!

[@onlinemarketer5346]

Hi Shane, I tried to upload images and documents to sharepoint library, but got error in formula. "Invalid Number Of Arguments, Received 2, Expected 1. I have created 4 5 time and refresh the app many times, removed and added couple of times, but that error still persists. If i provide 1 argument, then it just create the filename in document folder without any contents. I have followed your video 100% the same steps but still same error Could you please suggest Set(varForAttachmentControl, JSON(Image4.Image,JSONFormat.IncludeBinaryData)); Set(varBase64Only, Mid(varForAttachmentControl, Find(",",varForAttachmentControl)+1,Len(varForAttachmentControl)-Find(",",varForAttachmentControl)-1)); Set(varFileName,Last(AttachmentControl.Attachments).Name); EasyWay.Run(varFileName,varBase64Only); Reset(AttachmentControl);

[@ShanesCows]

The problem is with your Flow. YOu are not "Ask in Power Apps" twice, only once.

[@marjorielangevin3857]

Thank you for the video! It was my first dabble in powerapps and it was made easy by your instructions.

[@ShanesCows]

Glad to help. Lots of fun stuff to learn here.

[@Brutes-]

Thanks for the video :) I have a power app with the 3 default pages (view/edit/details) and I made an add page (duplicated the edit one, cleared the fields and set to make new record). I can take a picture like in the video, it gets uploaded to a SharePoint doc library using flow, and I get the link back in power apps. But I am trying to submit my form and have the link uploaded to my List image field (which requires said URL) but although the other fields (Incident, Time, User) are being filled up, the image (URL) one stays empty. Any idea what I'm doing wrong? Thanks!

[@ShanesCows]

You can set the variable.link to the update property of the card. Then when the form submits you capture the link.

[@ShanesCows]

This video will also show you another way to think about it. PowerApps Attachments - Saved to Azure Blob Storage with SharePoint and SQL kzbin.info/www/bejne/kIDdZHusgKmKg80

[@tomfink3684]

Hmmm.... I followed the video all the way through and was not about to get the file extension to appear. It comes out a blank document, with no file extension .jpg. Here is my formula. UploadafiletoSharePointfromPowerApps.Run(TextInput1.Text & ".jpg", TakenPic, Dropdown1.Selected.Value) Any ideas what I could've done wrong here?

[@ShanesCows]

That looks fine. I would look at the Flow side.

[@drishtimaharaj1580]

Hi Shane, thank you for the video. I just have a query, if you do not require the dropdown and wish to leave that out - an error occurs with the OnSelect for the "Save to SharePoint" - this is what I used UploadaimagefromphonetoSharePoint.Run(TextInput1.Text & ".jpg",TakenPic). Not sure if anything missing? Thank you :)

[@ShanesCows]

If you want the dropdown to be blank sometimes then you will need to have an if condition to account for that. If your flow is setup to ask in powerapps for something then it will not work if you don't pass it what it wants.

[@graffam198]

Hey Shane, I am trying to send a survey to a list of recipients after a button click in Powerapps. Have you done any videos on something like this? I.e. Click a button, contact list is stored on a sharepoint, and a forms survey is then sent to those recipients. The out of the box template seems ok, except you have to put in all of the Email Addressess....Thoughts?

[@ShanesCows]

You could use Concat to take all of the email addresses out of a table and make a string. Pretty sure I show it in this video kzbin.info/www/bejne/d5-og5l9fqprndk

[@colleensdan]

If i understand correctly - are you saying if I have a collection within powerapps, i couldn't save that to sharepoint via flow? How would you get around this problem?

[@ShanesCows]

Let's step back a tad. What are you trying to accomplish? What do you have in the collection and why do you need Flow to save it instead of saving straight to SharePoint from PowerApps?

[@nicole-vd7uu]

Hi, thank you for the lessons. I have a problem hope you can help with. How can I build a flow which can create a folder(not file) in onedrive, and copy the folder to SharePoint ?

[@ShanesCows]

I replied to email to help here. 😀

[@nicole-vd7uu]

@@ShanesCows Got it, thanks.

[@angusmulholland1003]

Hi Shane, I’ve followed this to a T, but my “Save to SharePoint” comes up with a Red Cross and doesn’t allow the ability ?

[@givanildosilvadeamorim326]

Hi Shane. It is possible to create a flow between powerapps and ondrive, to upload images in a shared folder on ondrive, and send the url (link) of this image to a Sharepoint list. You could help me.

[@ShanesCows]

Yes. That is possible. In flow you have the link as dynamic content. You can use that to write to SharePoint

[@chairutsirirut5787]

Thanks for the video!! It made my day easier. But I really wonder if we can upload more than just one image in a time. I have tried forall but it ends up replacing one before and finally remaining just the last image. I think it should be file name or maybe ID but I cannot find the way to workaround!!

[@ShanesCows]

Yes, you can but you will need them in a collection and then loop through the collection. I think I show it in this video kzbin.info/www/bejne/hpKQoYx7oLF7Y7c

[@ts3dprints732]

Is there a way to do this where the uploader does not have access to the SharePoint library? Like only the flow has access to the library?

[@ShanesCows]

I haven't tried. That is one of the tough parts about SharePoint as the data source. So if you take away the users access to SharePoint the Flow fails?

[@anantbirdeol5669]

I am not able to save 2 pictures with the same name, it automatically deletes the older one. Please provide a solution

[@ShanesCows]

You have to give each one a unique filename. Can’t have 2 files with the same name.

[@chinmaytawade1607]

You can use Now() along with your filename, so that you will have the same filename with different time&date attached to it.

[@anantbirdeol5669]

Chinmay Tawade this is actually a good idea, thanks👍🏻

[@hahiwa8060]

Hello, I'm trying do the same thing but with a collection, it seems to be a bit difficult, but i'd like to allow users to submit a repport with as images as they want. Have you any idea about this? Thanks for help

[@ShanesCows]

You need to do a ForAll on your collection and run the flow once for each. I don't have a dedicated video for ForAll yet but in this video you will see the concept in action. kzbin.info/www/bejne/eqrPqaaOfrqsesU

[@hahiwa8060]

Thanks a lot, i'm now near the final answer. For All worked, but a last thing isn't working. I get a blob adress in the sharepoint list, i tried to resolve this with the function in flow "dataUriToBinary(triggerBody()['Createanewelement_Image'])" but i got a flow error like this "language function need its parameter to be like a valid data URL. " (Sorry for the bad English, I use my french lessons to speak ;) )

[@balarameshsoleti165]

Hi Shane. Thanks for the video. I wanted to user Response to powerapps action and added that after update file properties in my flow and i am getting an error 'this action cannot be nested under Apply to each action . I am doing this as part of my flow is an array i am capturing . How can i fix this to use the response action after upload of files to sharepoint. Thanks

[@ShanesCows]

Click Add action below the apply to each section not within it

[@raphaelbonillo2192]

Is possible to upload two images in diffrente columns in Lists or Doc Libraries?

[@ShanesCows]

Not that I have done b

[@raphaelbonillo2192]

@@ShanesCows You're an expert. I'm following your channel. Hope the the Day that It will happens! Ha, ha

[@tuffley2175]

How do you hookup the 2nd camera to powerApps please

[@ShanesCows]

Add the camera control. One of the properties is Camera and it defaults to 0. Change it to 1 to see the next camera.

[@tuffley2175]

Beauty- Very BIG heart felt thanks How to find out camera access had been disabled by Admin guys please, it work at home but not in the workplace

[@JRHarless]

Hey Shane, is there an easy way to upload from a flow when using the Add Picture control so you can use the phone's native camera app to take the picture? The image format is different and the conversion in the flow doesn't work.

[@ShanesCows]

Upload to where?

[@JRHarless]

@@ShanesCows to a SharePoint document library

[@markjosephlagan3150]

Hi shane, I have a problem though when I click the button save to Sharepoint no images are uploading in my sharepoint site.

[@markjosephlagan3150]

Kindest regards for your feedback

[@ShanesCows]

Mark do you get an error? Any ideas what part is or is not working?

[@martinhagara7176]

Hi, Please give advice: Flow I created under the video but it reports me error: InvalidTemplate. Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '2113': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value 'v' was not formatted correctly. Please see aka.ms/logicexpressions#dataUriToBinary for usage details.'.

[@ShanesCows]

Sounds like a typo in your formula. Most people just start over and get it the second time.

[@reneweber6550]

Thank you for this really great video. Can I "clear" the Inputfield after Press Button Save to sharepoint?

[@ShanesCows]

Yes, use the Reset function to set it back to its default value.

[@reneweber6550]

@@ShanesCows Thank you

[@jesussanguinetti9852]

Great video for a starter like me. I tried to follow your steps but when trying to modify OnSelect for the camera icon, it gives me an error for "Cam", it says that is not valid. What is the issue?

[@ShanesCows]

Did you create the variable?

[@fvdv1990]

Hi Shane, Thanks for the help! I ran in to one problem though. The expression "CreatefileFileContent" does no longer work. It does work with "Createfile_FileContent"

[@ShanesCows]

Glad you got it. The dynamic content has changed I guess

[@michaelmedaflor7613]

Thank you Shane for this great video. It helped me a lot.

[@ShanesCows]

Glad to help. 😀

[@georgegornall1265]

Really good video that was easy to follow for someone just getting started like me. I have one question. Is it possible to send the "takenpic" between screens? I want the user to select a separate camera screen if an image is required along with the form entry. After the user takes the picture, I want it to display on the same screen on the form before the picture gets uploaded to sharepoint and the form is updated with the link. I managed it by uploading the pic when it is taken and then calling the URL to the form page but it makes things a little slow

[@ShanesCows]

Yes. Look for my video on variables. Long story short use Set and then the variable is available throughout the app.

[@belenguede7764]

Hi Shane, thank you for the video! I'm having troubles with Flow and keep getting a failed status. I realized the parameters of the .Run are no longer CreatefileFilename, CreatefileFileContent...) but only CreatefileFilename, any thoughts on that? Thank you!

[@mveelen403]

Hi Shane, thanks for this video. I've used it exactly as you described and with a few tweaks it works. There is only one thing that I'm wondering: all pictures that are made and uploaded this way, are only 640x480 and have a poor quality although the iPhone camera is way better than that. How could this be changed to use the HD quality of the camera and upload it that way? I know there are solutions in which you can upload a picture from the camera roll, but I want to stay in the PowerApp and be able to take the picture and then upload the full HD picture to Sharepoint. Is there a way we can do this or will this be available in an update of PowerApps itself perhaps ?

[@ShanesCows]

YOu can't change it. If you use the camera control you get low resolution photos. Sorry

[@WilliamHardwick]

Shane your videos are so valuable to us all, thank you. Microsoft so lacks support for this awesome product for small business. I own a cleaning company and been developing and using SharePoint since it came with my 2003 Small Business Server. Do you ever tour and do classes? I just went to App-in-a-day that Microsoft sponsored in SF. it blew my mind and was so enlightening. All this being said, can you post a second video on this relating to showing a SharePoint Picture Library List on a mobile device? My search has turned up videos that don't have a working option? I have a picture list that I have been using for years, with all my cleaning equipment in it, vacuums, buffers, etc., that I would love to use a lookup field for their location and which employee they are checked out too. What I have had to do, is use two lists, one called "Equipment Photos" that is a Picture Library, and a Second list called Equipment List, this list has all the metadata such as related Employee and Related asset location, model, Related Vendor, etc. So, what I have to do is link the image from the picture library to the equipment list item. For some reason, this works on the PowerApp? So then what would be ideal is if I could just get rid of the equipment list and only use the Picture Library list, create an app like you show and just take a picture of a new piece of equipment, relate all the relevant info like where the equipment is and which employee checked it out rather than having to manage two list. Hope this makes sense? Again, thanks so much for your work. I believe PowerApps is a game changer for small business!

[@ShanesCows]

Email me William. Long story I am sure you can do this. Just too late for me to think this hard and I don’t want to forget.

[@giselileticiasestari6650]

I looked at your video, and I would like to know if you can save the image I generated from the apps, save the photo in the sharepoint lsita item itself.

[@mauricevold8753]

I have done one like that to a SharePoint library. Worked well.

[@SmartChosk]

Hey Shane, I need to upload a video file in PA to SharePoin, Wich is the best method to do it? I noticed that in SharePoint I could upload a video, and in powerapps when I tried it didn't work...maybe another limitation of powerapps?

[@ShanesCows]

Have to attach the video to a list. Then you can have Flow move the file to a doc library

[@mtrayne]

Hi -- your videos are super helpful! thank you for making them! I used three separate videos to do my first working app. :)

[@ShanesCows]

Nice work! That is what I hope for is not to give you solutions but to give you tools. 😀