Thanks for the amazing video! For some reason using your code gave an error: Your formula is missing a column contentBytes with a type of 'Blob'. Based on a suggestion on Matthew Devaney's site I tried to remove the 'file:' part and one set of curly brackets, and it worked! For most of the internet your syntax including 'file:' works, but sometimes only without 'file:' works. I have no clue why :')
Hi Shane. I want to congratulate you for an EXCELLENT way to describe how to upload files using Power Apps. I was struggling with my project and I finally found something worthwhile to subscribe in TH-cam, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
Hey Shane! Was just referencing this video to do an upload and it looks like MS has changed the syntax. FlowName.Run({contentBytes:[Content],name:[Name]}). If you include {file: before the content bytes and name it throws an error stating that you're missing a column called contentBytes of type Blob. Removing the {file: and it works as expected. Nice of them to make these changes without telling anyone!
Interesting. I just did a test and this still works for me. NewUpload.Run({file:{contentBytes:First(Self.Attachments).Value,name:First(Self.Attachments).Name}}) 🤷
@@ShanesCows It works in another app where I have the formula like you do in the video. But I built a completely new flow and connected it to my test app and it wouldn't work unless I removed the {file: portion. I thought I was going crazy because I wrote exactly what you have and got an error and then checked my other app, copied it from there and pasted it and still got the error. Utter silliness.
I found out the hard way! It refused to work for multiple attachment controls on the screen. It was through a video of Matthew Devany that we found you can omit the 'file:'. Structure should remain the same so: { { contentBytes: [Value], name: [Name] } }
Thanks ! I watched the video 3 weeks ago and everything worked, but then I faced the error after some changes and came back here. Your comment helped a lot!
Thank you so much Shane! I've been looking for the apps(v1) trigger since I could not configure V2 but then this video showed up to save life... a nice gift for the season...
It’s amazing that they create a file upload V2, but still haven’t added an attachment control. I’d love to sit in their meetings and drill them on some of the ridiculousness.
It is interesting. If I remember next time I am in a meeting with the right people I will ask. It is so curious uploading files is such an after thought. EVERYONE does it!
Also the limitations of the attachment control, it's not fun trying to upload anything above 40mb. While it's possible, the limitations differ depending on the users hardware and connection(Big problem now that so many work from home.)
Hi Shane, I keep getting the error of my contentBytes variable not being of data type "Blob". I followed your video exactly for both Power Automate and Power Apps. Do you have any ideas on what might cause this error?
This still works exactly the same. So I am not sure why it isn't working for you. 😖 Maybe try with a new app and flow? There has to be some little piece you are missing. Sorry.
Hey, Shane! I loved the video. Do I want to see additional things when it comes to uploading? YES! 1) A confirmation screen so that users can verify they have selected the right files and are ready to upload. 2) Handling uploads in the event that the app is temporary offline or experiencing connectivity issues (or perhaps for offline-first apps). Thank you, I need to ask my company if they will pay for my subscription to your training, it seems worth it!
You can solve both by adding a slider that defaults to CountRows(AttachmentControl.Attachments) while the OnChange property clearcollects the attachment with an additional status column. You display the collection in a gallery with an icon representing upload status. As you press the upload button you forall through the Attachments(Not the collection.) and update the status of the corresponding item in the collection, once the flow completes the upload of the file, or fails, it responds to powerapps with the corresponding status that you then write back to the collection(All in the same loop.). Now you can see in real time which items are waiting for upload, are being uploaded, has been uploaded or has failed an upload. That being said, offline/connectivity issues are virtually impossible to deal with in powerapps.
Great video Shane! Love the new change. What I would like to see is how to manage a documents library gallery that may exceed the visual limit and uploading documents to that. My scenario would have a variable library (for instance a personnel file changing based upon person selected). I get use a variable to folder location and ask for power automate, my concern primarily is how to view the files (maybe over 2000).
Do you have over 2000 files per user, or over 2000 total? If you have only a few files per user, and many users, just create a gallery with the source as your folder location, and filter it by user.
I ran into this issue recently as well. The reason is because power apps is limited to a max of 2000 items that you can search. The default is 500. You can change this in the settings, but you will run into issues with performance. Only certain columns in a sharepoint document library can be used to search library’s bigger then 2000. If you are trying to search by name it won’t work. You need to pick a column that is a single line of text. If you still want to search by name like I did. Create a power automate flow that when a file is uploaded it takes the name of the file and puts it in the single line column. Then in your gallery under items the code is: Filter(Gallery3, startswith(New-Column, Searchbox.text)) That fixed it for me. Hope this helps.
I developed a document management app with ~6,000 documents in one SharePoint library. I categorized the documents so that there were no more than 2,000 in each category, and then require the users to select a category. The app then displays the documents only in that category. It works well as long as all filtering is delegable. I also made all documents in the SharePoint library read only. If a user has rights to edit a document they are granted access with a flow, the document is downloaded and checked out. When the check it back in the access rights are reset to default.
Hi Shane, thanks for the great video that is really useful. Just a quick question, I've added at the Power App (V2) two "Text" fields for creating sub-folder under the Share Document; and revised the "Flow.Run" as below for incorporating the 2 "Text" fields but the flow didn't works at creating file while it was fine on creating the sub-folder ... both the "name" and "body" were "null" as shown at the raw input of creating file at the flow: - ForAll(AttachControl_1.Attachments As FILE, PhotoUpload.Run(DataCardValue24.Selected.Value, Text(DateValue(TextInput_DateTime.Text),"yyyymmdd"),{file:{contentBytes:FILE.Value,name:FILE.Name}})) Not sure if you can help pointing out where the error is please. Besides, how can I add "link to item" in this case of multiple uploading. Many Thanks
I am not sure why your File is null. I would get rid of the ForAll and test on one file until you find the bug. I don't see an obvious error. As for getting the links th-cam.com/video/AHWvG2C9vQo/w-d-xo.html and then you will want to Collect each link instead of Set if you are inside the ForAll. Good luck
@@ShanesCows , thanks for the advice. Indeed, the "PhotoUpload.Run" suddenly work after a few trials. Btw, do you mean it's not possible to use Power App V2 for returning the File link of multiple files uploading? Instead, have to use the Base 64 method? I've also attempted to return the link to the newly created folder (that contains all the files just uploaded) but still unsuccessful!!! Thanks
Great Video, thanks Shane. One question - if i upload multiple files, my flow triggers this many times. The issue is that i manipulate the uploaded files and want to send out the output via email and it sends out as many emails as files I uploaded (due to the mutiple upload file trigger). Is there a way to add all files in one go in power automate?
Huge thanks for this. I used your old method and it was working but then it stopped working. I switched to this method (all files) and all good to go again! :)
Hi Shane! Great video as always. Question: do you think we can rename the attachments during the upload? Use case: you recive an email with attachment and you want to process that with drag and drop. Now the attachement name is something what you want to change, how would you do that? do you have any solution for that? thank you again!!
I would just add a label for the user to give the file a new name or rename it as you want and send it to the Flow as a parameter (Add an input from Power Apps (V2) of type Text, File Name) and use it in your step Create file as File Name.
Great video! I've got a scenario where a user may use a Gallery & Form to view an item in a SharePoint list with attachments there, and want to add additional attachments or remove attachments to/from the SharePoint list item using Power Automate. What differences in the Power Automate flow would I need to do? Thanks
Hi Shane, great video as always. Could you please add the gallery to the right of the attachment control that display all the uploaded files in real time?
Hi Shane! So thankful for your videos, I have learned so much! Would this essentially be the same process if I am trying to create a new folder within that document library?
I made this video on working with Attachments. I don't think it needs updated for v2 but if you find differently leave me a new comment on the video and I will put it on the list :) th-cam.com/video/K74UFYgrKB4/w-d-xo.html
Thanks for the video @ShanesCows It is really helpful. I have one query. This video will trigger my flow thrice if I have uploaded three files. Can I just trigger my flow once and upload three files in one go? is it possible
Hi Shane. Thank you for this video! I am able to upload pics and documents from Iphone/iPad but no video. It works from desktop browser. Do you know of another way to add a video to SP Library though PowerApps iOS?
Great start on the video, I also want to pass text metadata to PA and I have created additional Text inputs to the flows. Trying to figure out the syntax in the app in addition to the file name and contents, can you please point me to a video for that?
Is there a similar, easy approach for photos taken through the camera control? I'm storing all the images taken throughout the application in a collection and then was hoping to move them to a SharePoint folder at the end. I followed the same steps you have above, but it doesn't seem to like the data type the image is stored as in the collection.
Thank you for this lesson, Shane. Very helpful indeed. One question, if you needed to email the link to the uploaded file now sitting in the SharePoint Document Library from within the Power App, or perhaps patch a SharePoint list record with that link, would there be a way to return that link via the Power Automate?
Yes, you would use Respond to Power Apps flow action where you can pass data back. I don't have a recent video with it though. Hmm. I just added to my video list an idea thanks to you :) This video is really old but the mechanics are exactly the same, everything just looks different and you uploaded differently but the response will be the same for you th-cam.com/video/ovLIwnj6QjU/w-d-xo.html
Hi Shane, great work as always. But just curious if you were able to crack a reverse approach on this? Like we want to pull the attachments from SP List back to that the same attachment control still using power automate?
I did once but it is really ugly and I never made content on it or even have the app I did it with. The Items property of the attachment control wants a table, you have to sculpt things into the exact form it once, I feel like there was even a hidden field but it has been years since I tried. Good luck.
Thank you so much for your video. I've looked at a few and it's very easy to follow. So thanks so much. But now I'm trying to follow your steps here but I'm in the Modern Display mode. And I think things works differently in that mode. I keep getting the error saying that "Your formula is missing a column 'contentBytes' with a type of 'Blob'. Do you know how to fix this or any recommendation will be highly appreciated. Thanks!
Paste your formula. Odds are you have a type of, maybe capitialization of the word contentBytes for example. Everything here should work the same as far as I know.
Hello thanks for the video! When I upload the file, how do I get that file to be associated with a unique ID generated by the powerapp i.e., how do I now know from what user the file came from? The addition of a text input in the PowerApps V2 trigger and an Update file properties action results in an error (Found record expecting text). Thanks
This was really helpful Shane! One thing I would like to know how to do, and maybe you have covered this in pervious videos, but I have some properties in the sharepoint doc library that I added manually, so for instance 'System'. How can I update those properties, in this case 'System' in the flow that uploads the file? Cheers!
Combine what you learned in this video with the metadata updating from this viddeo. th-cam.com/video/e0kMjb686tc/w-d-xo.html I think that should get you there.
Excellent and very useful!! Now, would there be a clever way to limit file extension? maybe checking the file name with a condition in the submit button?
Awesome video! Is there a way to send the link to the newly created file back to Power Apps and drop it into the attachments column in a SharePoint list? I'm trying to incorporate having users create a list entry from a Power App and upload attachments from the same app screen. There must be a way to include this in the Patch function that takes all the info and populates the columns in the list, but I'm stuck with how to go about getting the URL back from Power Automate. I know Forms can do this, but there are some drop downs with thousands of options and Forms has not been great at handling the amount of data so I was asked to re-work their form into a Power App.
Check out this video where I talk about using this instead of Attachments. I think the logic you are looking for, or at least a good push in the right direction, is there. th-cam.com/video/5Jv9u2kTy04/w-d-xo.html
This is a great way to upload files but it differs from a way i've been doing it that 'seems' easier. Can you let me know if you see an issue with this way: Add the edit form but keep only the attachments control in it. Shrink the form down to fit around the control and place in my app. Continue building app. Upon clicking the Submit button, i just have submitform execute before all my patches. This eliminates the need for power automate altogether. What say you?
The downside there is it will create the item as an attachment, not as a file in a doc library. I don't like attachments, too hard to work with. BUT if it is doing what you need then rock on! 🤩
Great video ! This Drag & drop is very usefull. Many thank ! 15:01 : We have the same animated icon generator :D. Hoping MS will add this as native functionality in PowerApps ( with no flow ).
This video explains the different triggers th-cam.com/video/vpjf5mD-COs/w-d-xo.html This video talks about multi-upload th-cam.com/video/7UeRzfPo8RE/w-d-xo.html though with DV it will be different but should get you started.
Great video as always and hi to Chewy. One observation I made is that by default if a file with the same name already exists ... it will overwrite it ! Is there a way to upload the file and get it automatically rename it like "Copy of myFile.docx" similar to what happens when you paste a file in a Folder ?
Hi Shane, firstable I really appreciate this video, it was so helpful. Additionally I would like to know if there is a possibility to loop into a gallery, it means, using: Forall to extract all attachments from allitems of a Gallery? I hope this can be possible...Thank you!
Great video, I'm relatively new to Power Apps, is there a way to have this attachment card in a gallery view so each entry within my gallery can have an attachment section associated with it? I tried copy & pasting this card into my gallery but it didn't seem to create multiple entries.
Great video as usual. I have two questions. (1) is there any way to return or capture the ID of the document within the document library? (2) Once the file is uploaded, I don't want the user to accidentally upload it again - I want to remove it from the attachment control. Is there a way to do that?
1 - Respond to Power Apps in your flow with the ID. In Power Apps you would have something like Set(varID, Flow.Run(file).ID); 2 - Reset(AttachmentControl) in your OnFileAdd at the bottom
Add a Text Input and pass the folder name. Put that dynamic content in the folder location. This video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html shows it for v1 but the concept is the exact same. :) Where the videos shows "ask in Power Apps" use a Text input. Everything else the same. I will put this on the list of video ideas.
Collect(colStuff, {blob: Last(attachmentcontrol.attachments).Value, filename: Last(attachmentcontrol.attachments).Name}) Something like that, now you have them in a collection like you want. No magic needed.
The video is useful. Thank you. However what we shall do if we have a list of files displayed in PowerApps. How to get its actual state if Refresh kills performance?
Hi Shane, this is great but how about getting the respond to powerapp or flow. I would love to get the Id from the new uploaded document, just like old one does. Thanks
Hi Shane! Great video. Question: I have a use case where a certain project is selected from a gallery, I want that PM to upload all documents for that particualr selected item. Do you have any videos that shows those relationships?
Hi Shane. Is it possible to make the folder directory to which the document is to be saved as dynamic i .e give the user the option to select the path?
Hi Shane, I need to basically do this but for uploading Excel files to the Dataverse. Is this possible? I only see a dataverse connector for a single row in Power Automate, and the the upload files option doesn’t recognize the table/data inside the excel file. Thanks so much
In Dataverse there isn't just upload a file. You would need a table that had a file column then you could upload the file to that column specifically. But DV doesn't have a "document Library" like SharePoint does.
Great and clear video :D But I need your help! I can't seem to get the formula work, it keeps giving te error because of the comma after Value (so it appears). It says 'Unexpected characters.
In your Region do you use a , or a . as your decimal separtor? 12,50 or 12.50 ? If it is the comma, then you are creating power apps formulas you need to adjust. Anywhere that I use a , you use a ; anywhere I use a ; you use a ;; This video talks about the difference in , regions among other things. th-cam.com/video/GAdnURx5g8g/w-d-xo.html
I'm stuck on the first step, I have been clicking a SharePoint, and uploading the data, but the attachment button doesn't come with. It's brining in the other columns and names, but no attachment button. I'm using some random Sharepoints in my company, but do I need to create my own? I've never done that, so I might be way off from getting to this point.
Hi Shane - really struggling to get this to work in the final stages of writing the formua - it keeps saying video upload is not recognised and other errors. I have signed up to your site - and imported the flow - but not sure how to import the power app template into my environment! Im new to all this - and Chat GPT just doesnt cut it lol
Would be great to add meta data tagging to this app - but use a custom properties button - such as document type - but rather than drop down - just a coloured button that says 'Invoices - and the user just clicks and the colour of the button goes green - then use the upload button?
This was great! Do you have a video where you show how to upload an attachment based on a gallery for each ThisRecord item? I couldn't find any. I have a SP List where I need to have the ability to upload attachments to the specific list based on a specific ID number within the gallery.
Do you have any videos that discuss sending updated documents to SharePoint with Power Automate? (There is already a document there prior to approval and the second flow is attempting to overwrite the original document with a new version). I keep getting two files with the same name.
Hey there Shane. Thank you for this video, I found it helpful. I do have a question and if this is the wrong solution please let me know. I want to replace the standard document Library upload functionality. Can the document library "Upload" button trigger this Power App? If so, can you provide some guidance?
Hi Shane - great video , and great app! Is there a quick an easy way to add document tagging to this. I have drop down choices - and would also like to use a button to tag docs - i got it wairking , by then it failed.
@@paulmcnally4994 training.powerapps911.com/courses/take/video-library/lessons/51131834-12-11-2023-power-apps-file-upload is that the one you are looking for?
@ShanesCows you are directly writing the file context to share point. I do the same, however I break it into 2 flows. The PowerApp Flow to get the file, which ends with an HTTP action to a second flow which writes to the sharepoint list. I use JSON in the body to send data from first flow to the send flow. I do this because it allows the account writing to sharepoint to be different than the person in the app who clicked the button and thus for security the sharepoint lists can be locked down from the users. How do you send this new filecontent variable in V2, it doesn't seem to work like the older text variable did. I'm guessing the V2 FileContent is getting messed up when sent on the HTTP body as json?
Thank you very much, Need to know how to get the file name that is uploaded in Power Apps and assign it a variable so that I can generate a link and show it
Thank you so much for this, Shane! You've solved my biggest stumbling block with Power Apps. Taking this further... Is it possible to prompt users to create, say, a "new client" subfolder in the SharePoint directory into which the uploaded files must be stored. Or to select the relevant subfolder from a dropdown menu in the files upload control? OR - could users upload to Document Sets in SharePoint instead of folders? 🙂
Bro Is it possible to rename files in a folder in a SP Document Library using HTTP request in automate? I tried but it kept giving me SP.FILE does not support PATCH/POST method
@@ShanesCowsYeah Xd its is possible.I was making small mistakes in the Send HTTP request action URI and Headers finally got the solution! And Always your Vids
Great ! It would be a game changer if I can have a label to change the name of the file, so when a button is pressed, the name in the label is applied to the document . maybe even upon upload to the attachment control@@ShanesCows
Hey! Great Video, thanky ou so much. You are a lifesaver! Now I have a question: Is it possible to upload all files I've stored in my attachment card? I am currently working on an app that should be able to do that and I'm a fairly new beginner in Power Apps. Do you by any chance have a video to that? I want to upload several pictures into a custom generated document library. My pictures all have custom names already, so I don't really have to name them anymore
I didnt get an attachment control in the form when connecting the form to my SharePoint document library data source, only some text fields with labels for the columns. Why?
Thank you Shane, nice Video. Could you please show us the other way too? How to "download" or "import" multiple files from specific SharepointItem to this Attachment Control? That would be fantastic for my current project.
This video shows doing it with the v1 trigger. th-cam.com/video/e0kMjb686tc/w-d-xo.html You will have to adapt to v2 but should get you 90% of the way there. Making a new Metadata video is on my list. You are the second person to ask today. :)
This video tackles metadata. th-cam.com/video/AHWvG2C9vQo/w-d-xo.html The real challenge is you need a way to store the different metadata in the app first. Maybe a big collection of images and their unique data. It is possible, just more moving parts.
I can't seem to avoid being stuck on error: Missing column. Your formula is missing a column 'contentBytes' with a typo of 'Blob'. Same code and steps as you and tried several other but still no luck. Help please!
@@ShanesCows Yes! In my particular case (doing same steps as you did) the code that works is: MyFlow.Run( { contentBytes: Last(Self.Attachments).Value, name: Last(Self.Attachments).Name } ) Thank you so much. Yo are my favourite source of Power Platform content!
Does the user uploading the file need permission to the folder? If so, how would you keep the people from seeing the documents on the backend because people can search sharepoint ? Awesome video. Thank you!🎉
Yes. You could use thie video to change permissions. PowerApps SharePoint Item Level Permissions via Power Automate th-cam.com/video/vGSNrj82JcI/w-d-xo.html
Thanks for the video Shane! But the attachment control has a limitation on the file size (max50MB, some claim it to be 94MB), however I want to upload a 400MB file from PowerApps to SharePoint library. Can you please let me know what's the best way to do that?
First, thank you for providing these training videos. They are often the difference between complete and total failure and success! Second, normally I can modify the content to suit my needs; however, today I've not been so fortunate. I have created the V2 app with the file input then added a second Text input. In this case, the My File input comes before the Text input. I comma delimit the two inputs; however, this results in a "missing column" error. For example: "UploadBoardMeetingMinutesFile.Run({file:{contentBytes:Last(Self.Attachments).Value, name:Last(Self.Attachments).Name}}, Text(DatePicker1.SelectedDate));" Any suggestions?
I believe that I was bitten by the MS bug you mentioned. I have corrected that by starting over with the V2 flow; however, I still have an issue formatting a "run" statement in a canvas app when I'm attempting to pass a File and a Text Parameter type to the V2 flow. I have formatted lots of (V2) flows with a mix of other than a File parameter. Do you have any videos that mix and match V2 flows with File and other parameter types? Bill
Bill check that Power Apps doesn't want them in the opposite order. Run(text,file) sometimes we assume the wrong order. Doing a video on uploading and setting the metadata is on my list. I get a lot of these questions. :)
This was very useful, would be interesting to know if you could automate a file upload based on a file being dropped into a folder. A watched folder type scenario.
Yoo git another question for ya 😅. I want to delete a file/Document in a SP Library.. is it possible using Graph Api? In powerapps (without using power Automate)
Hi Shane, ive got a question, How could i attach those multiple files as one in an OutLook Mail or Approvals? Right now its sending two separate mails with each one a different picture but How could i send it all in one Mail?
Any tips for doing this from a Mobile App and not Web (desktop)? I've got a use case to load a 10-20 second video from a Mobile Device (iphone), but when I select the control on an iPhone I only see options for photos - no videos. Anyone ever seen a workaround?
Why when I save a excel file on my SP it has a white "file icon" and I have to download it for seeing whats in it? Because of it I can't access to a file table that I need. Thank you for helping me in my project!
Thank you very much, Shane! You're a blessing to the Power Platform community!
I appreciate that! Have a great day!
I have NEVER seen that As FILE snippet before in PowerFX, I learned something new today, thank you Shane!
One of my favorite make my life easier tricks.
Excellent video Shane, as usual. You deserve an honorary PhD for all of the great work you have done to further the Power Platform.
Thank you Jim. I will be sure to thank in my acceptance speech when it happens. ⭐
Love that you show both interfaces. they are so different when you are new.
Agree, super confusing 😎
Thanks for the amazing video! For some reason using your code gave an error: Your formula is missing a column contentBytes with a type of 'Blob'. Based on a suggestion on Matthew Devaney's site I tried to remove the 'file:' part and one set of curly brackets, and it worked! For most of the internet your syntax including 'file:' works, but sometimes only without 'file:' works. I have no clue why :')
Exactly, saw a post on a forum recommending exactly that - excluding file:{} - and worked as a breeze.
I tried many tutorials to achieve this but got the working solution only through your video. Thank you very much!!
Awesome, glad to help. 😎
Hi Shane. I want to congratulate you for an EXCELLENT way to describe how to upload files using Power Apps. I was struggling with my project and I finally found something worthwhile to subscribe in TH-cam, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
Appreciate the kind words 😎
Hey Shane! Was just referencing this video to do an upload and it looks like MS has changed the syntax. FlowName.Run({contentBytes:[Content],name:[Name]}). If you include {file: before the content bytes and name it throws an error stating that you're missing a column called contentBytes of type Blob. Removing the {file: and it works as expected. Nice of them to make these changes without telling anyone!
Interesting. I just did a test and this still works for me.
NewUpload.Run({file:{contentBytes:First(Self.Attachments).Value,name:First(Self.Attachments).Name}})
🤷
@@ShanesCows It works in another app where I have the formula like you do in the video. But I built a completely new flow and connected it to my test app and it wouldn't work unless I removed the {file: portion. I thought I was going crazy because I wrote exactly what you have and got an error and then checked my other app, copied it from there and pasted it and still got the error. Utter silliness.
I found out the hard way! It refused to work for multiple attachment controls on the screen. It was through a video of Matthew Devany that we found you can omit the 'file:'.
Structure should remain the same so:
{
{
contentBytes: [Value],
name: [Name]
}
}
Thanks ! I watched the video 3 weeks ago and everything worked, but then I faced the error after some changes and came back here. Your comment helped a lot!
Thank you so much Shane! I've been looking for the apps(v1) trigger since I could not configure V2 but then this video showed up to save life... a nice gift for the season...
Glad to help! Happy Holidays!
Great Video Shane. This is very helpful. Thanks for sharing your knowledge
Happy to help. Have a great day. 🐶
Excellent! simple, fast and easy as Shane always does!
Thanks! I did just today release Advanced Uploads which is great follow up :) th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
It’s amazing that they create a file upload V2, but still haven’t added an attachment control. I’d love to sit in their meetings and drill them on some of the ridiculousness.
It is interesting. If I remember next time I am in a meeting with the right people I will ask. It is so curious uploading files is such an after thought. EVERYONE does it!
Also the limitations of the attachment control, it's not fun trying to upload anything above 40mb.
While it's possible, the limitations differ depending on the users hardware and connection(Big problem now that so many work from home.)
Brilliant, like always! Thank you very much for this excellent tutorial!
Love this! Thank you for posting! Will you be posting an updated video showing how to set metadata using the v2 trigger?
Someone else indirectly asked for that. I think that would be a good idea.
@@ShanesCows Yes, please because i tried and I am getting an error message.
Okay, after playing around I was able to figure it out.
@@mickeyatty would love to hear how you did this!
Hi Shane, I keep getting the error of my contentBytes variable not being of data type "Blob". I followed your video exactly for both Power Automate and Power Apps. Do you have any ideas on what might cause this error?
This still works exactly the same. So I am not sure why it isn't working for you. 😖 Maybe try with a new app and flow? There has to be some little piece you are missing. Sorry.
same here =(
i fixed the problem. you have to go to your flow and make the file as optional in the trigger.
Hey, Shane! I loved the video. Do I want to see additional things when it comes to uploading? YES!
1) A confirmation screen so that users can verify they have selected the right files and are ready to upload. 2) Handling uploads in the event that the app is temporary offline or experiencing connectivity issues (or perhaps for offline-first apps).
Thank you, I need to ask my company if they will pay for my subscription to your training, it seems worth it!
You can solve both by adding a slider that defaults to CountRows(AttachmentControl.Attachments) while the OnChange property clearcollects the attachment with an additional status column.
You display the collection in a gallery with an icon representing upload status.
As you press the upload button you forall through the Attachments(Not the collection.) and update the status of the corresponding item in the collection, once the flow completes the upload of the file, or fails, it responds to powerapps with the corresponding status that you then write back to the collection(All in the same loop.).
Now you can see in real time which items are waiting for upload, are being uploaded, has been uploaded or has failed an upload.
That being said, offline/connectivity issues are virtually impossible to deal with in powerapps.
This is a great update as always Shane :)
But a twist on this would be how to attach and load to a custom folder in Sharepoint
I explained the concept in this older video. 😎 th-cam.com/video/2gE0e_AsdMw/w-d-xo.html
@@ShanesCows ironically found this about 40mins after posting lol. Keep up the great work Shane 'every day a school day' when you post :) Thank you
Once again Shane thank you for all the effort you give on sharing all you knowledge 🙏🙃
My pleasure!
OMG, you just made my week. Thanks for this 😊
Great video Shane! Love the new change. What I would like to see is how to manage a documents library gallery that may exceed the visual limit and uploading documents to that. My scenario would have a variable library (for instance a personnel file changing based upon person selected). I get use a variable to folder location and ask for power automate, my concern primarily is how to view the files (maybe over 2000).
Do you have over 2000 files per user, or over 2000 total? If you have only a few files per user, and many users, just create a gallery with the source as your folder location, and filter it by user.
I ran into this issue recently as well. The reason is because power apps is limited to a max of 2000 items that you can search. The default is 500. You can change this in the settings, but you will run into issues with performance.
Only certain columns in a sharepoint document library can be used to search library’s bigger then 2000.
If you are trying to search by name it won’t work. You need to pick a column that is a single line of text. If you still want to search by name like I did. Create a power automate flow that when a file is uploaded it takes the name of the file and puts it in the single line column. Then in your gallery under items the code is:
Filter(Gallery3, startswith(New-Column, Searchbox.text))
That fixed it for me. Hope this helps.
I developed a document management app with ~6,000 documents in one SharePoint library. I categorized the documents so that there were no more than 2,000 in each category, and then require the users to select a category. The app then displays the documents only in that category. It works well as long as all filtering is delegable. I also made all documents in the SharePoint library read only. If a user has rights to edit a document they are granted access with a flow, the document is downloaded and checked out. When the check it back in the access rights are reset to default.
Brilliant stuff. Thanks for taking the time to make it look so easy!
Hi Shane, thanks for the great video that is really useful.
Just a quick question, I've added at the Power App (V2) two "Text" fields for creating sub-folder under the Share Document; and revised the "Flow.Run" as below for incorporating the 2 "Text" fields but the flow didn't works at creating file while it was fine on creating the sub-folder ... both the "name" and "body" were "null" as shown at the raw input of creating file at the flow: -
ForAll(AttachControl_1.Attachments As FILE, PhotoUpload.Run(DataCardValue24.Selected.Value, Text(DateValue(TextInput_DateTime.Text),"yyyymmdd"),{file:{contentBytes:FILE.Value,name:FILE.Name}}))
Not sure if you can help pointing out where the error is please.
Besides, how can I add "link to item" in this case of multiple uploading.
Many Thanks
I am not sure why your File is null. I would get rid of the ForAll and test on one file until you find the bug. I don't see an obvious error.
As for getting the links th-cam.com/video/AHWvG2C9vQo/w-d-xo.html and then you will want to Collect each link instead of Set if you are inside the ForAll. Good luck
@@ShanesCows , thanks for the advice.
Indeed, the "PhotoUpload.Run" suddenly work after a few trials.
Btw, do you mean it's not possible to use Power App V2 for returning the File link of multiple files uploading? Instead, have to use the Base 64 method?
I've also attempted to return the link to the newly created folder (that contains all the files just uploaded) but still unsuccessful!!!
Thanks
Great Video, thanks Shane. One question - if i upload multiple files, my flow triggers this many times. The issue is that i manipulate the uploaded files and want to send out the output via email and it sends out as many emails as files I uploaded (due to the mutiple upload file trigger). Is there a way to add all files in one go in power automate?
Hey I am having a very similar issue, have you found a solution to this?
@@julienvdc yep, used this video from Reza Dorrani - th-cam.com/video/r3UC3TMXhlI/w-d-xo.html, around 8:10 is where the logic is explained in detail.
That is so amazing, Shane!
Happy to help. Have a great day and happy holidays. 🎄
Great video Shane. Thanks!
A real shame this many years later MS still haven't added that attachment control to the available controls list.
I need to ask them why, it is quite curious for sure. :)
Huge thanks for this. I used your old method and it was working but then it stopped working. I switched to this method (all files) and all good to go again! :)
You're welcome! Thanks for the update, I love hearing when stuff works. 😎
Hi Shane! Great video as always. Question: do you think we can rename the attachments during the upload? Use case: you recive an email with attachment and you want to process that with drag and drop. Now the attachement name is something what you want to change, how would you do that? do you have any solution for that? thank you again!!
I would just add a label for the user to give the file a new name or rename it as you want and send it to the Flow as a parameter (Add an input from Power Apps (V2) of type Text, File Name) and use it in your step Create file as File Name.
2024 and still no control to upload files without doing magic... Thanks for your video Shane, helpful as always!
Glad to help, one day we will get a control, one day.
Great video! I've got a scenario where a user may use a Gallery & Form to view an item in a SharePoint list with attachments there, and want to add additional attachments or remove attachments to/from the SharePoint list item using Power Automate. What differences in the Power Automate flow would I need to do? Thanks
th-cam.com/video/K74UFYgrKB4/w-d-xo.html talks about Attachments, they are a different beast.
Great video Shane! I'm using Ms graph to upload document library instead of flow.
Cool. If that works for you then rock on. 🤩
Is there any performance difference between sending file as JSON vs file?
I don't think so, I think at the end of the day it is really sending the same amount of data but not 100% sure.
This is great, thanks. Any way to get the path to the uploaded images back to the power app, I need to send it to another sharepoint list?
Try this video th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
Hi Shane, great video as always. Could you please add the gallery to the right of the attachment control that display all the uploaded files in real time?
This video will help with that. Power Apps SharePoint Document Library Browser
th-cam.com/video/u-b8w9ea1kk/w-d-xo.html
Helpful, now I've got to figure out how to link it to the specific record (using a model driven app) and not just to the top-level SharePoint folder.
Hi Shane great video!! quick question .how do you transparent the attachment control?
You have to go to the different properties, like color, fill, border color, etc and change them to Color. Transparent.
@@ShanesCows i use phone app to attach the video but only attach photo. No option for video. Any Idea? Thanks.
Hi Shane! So thankful for your videos, I have learned so much! Would this essentially be the same process if I am trying to create a new folder within that document library?
Yes. If you add a folder to the path and it doesn’t exist it will automatically be created. 😎
Great video. Is there a V2 use case for uploading attachments to a given record in MS List? I normally use patch or submit form with MS List
I made this video on working with Attachments. I don't think it needs updated for v2 but if you find differently leave me a new comment on the video and I will put it on the list :) th-cam.com/video/K74UFYgrKB4/w-d-xo.html
Thanks for the video @ShanesCows It is really helpful. I have one query. This video will trigger my flow thrice if I have uploaded three files. Can I just trigger my flow once and upload three files in one go? is it possible
Having the same issue, have you found a solution?
Hello Shane!! Love your videos!!! One quick question!! is this working for video files also? What size is the maximum?? thank youuu
Yes, should work for videos. Biggest file I have gotten to work is about 50 MB but I have heard some people get it closer to 100.
Hi Shane. Thank you for this video! I am able to upload pics and documents from Iphone/iPad but no video. It works from desktop browser. Do you know of another way to add a video to SP Library though PowerApps iOS?
Hi Chris, I don’t. 😬 I have never had it as a requirement but I have seen a lot of people post it wasn’t possible. Sorry
Great start on the video, I also want to pass text metadata to PA and I have created additional Text inputs to the flows. Trying to figure out the syntax in the app in addition to the file name and contents, can you please point me to a video for that?
This video covers the metadata portion. :) th-cam.com/video/e0kMjb686tc/w-d-xo.html Guess I need to make a new version of it. :)
Is there a similar, easy approach for photos taken through the camera control? I'm storing all the images taken throughout the application in a collection and then was hoping to move them to a SharePoint folder at the end. I followed the same steps you have above, but it doesn't seem to like the data type the image is stored as in the collection.
Yes. This video will explain the mechanics.
Power Apps Upload Multiple Files AND Drag and Drop Files
th-cam.com/video/7UeRzfPo8RE/w-d-xo.html
Thank you for this lesson, Shane. Very helpful indeed. One question, if you needed to email the link to the uploaded file now sitting in the SharePoint Document Library from within the Power App, or perhaps patch a SharePoint list record with that link, would there be a way to return that link via the Power Automate?
Yes, you would use Respond to Power Apps flow action where you can pass data back. I don't have a recent video with it though. Hmm. I just added to my video list an idea thanks to you :)
This video is really old but the mechanics are exactly the same, everything just looks different and you uploaded differently but the response will be the same for you th-cam.com/video/ovLIwnj6QjU/w-d-xo.html
Hi Shane, great work as always. But just curious if you were able to crack a reverse approach on this? Like we want to pull the attachments from SP List back to that the same attachment control still using power automate?
I did once but it is really ugly and I never made content on it or even have the app I did it with. The Items property of the attachment control wants a table, you have to sculpt things into the exact form it once, I feel like there was even a hidden field but it has been years since I tried. Good luck.
@@ShanesCows Gotcha, but still hoping I can find some ways to do it :D looking forward on that content of yours
Thank you so much for your video. I've looked at a few and it's very easy to follow. So thanks so much. But now I'm trying to follow your steps here but I'm in the Modern Display mode. And I think things works differently in that mode. I keep getting the error saying that "Your formula is missing a column 'contentBytes' with a type of 'Blob'. Do you know how to fix this or any recommendation will be highly appreciated. Thanks!
Paste your formula. Odds are you have a type of, maybe capitialization of the word contentBytes for example. Everything here should work the same as far as I know.
Hello thanks for the video! When I upload the file, how do I get that file to be associated with a unique ID generated by the powerapp i.e., how do I now know from what user the file came from? The addition of a text input in the PowerApps V2 trigger and an Update file properties action results in an error (Found record expecting text). Thanks
This video incorporates adding metadata and such. th-cam.com/video/AHWvG2C9vQo/w-d-xo.html 😎
@@ShanesCows Thank you so much!
This was really helpful Shane! One thing I would like to know how to do, and maybe you have covered this in pervious videos, but I have some properties in the sharepoint doc library that I added manually, so for instance 'System'. How can I update those properties, in this case 'System' in the flow that uploads the file? Cheers!
Combine what you learned in this video with the metadata updating from this viddeo. th-cam.com/video/e0kMjb686tc/w-d-xo.html I think that should get you there.
@@ShanesCows Awesome! Thanks for getting back to me! I'll check it out and let you know the results 😀
Excellent and very useful!!
Now, would there be a clever way to limit file extension? maybe checking the file name with a condition in the submit button?
That is exactly it. When they add an attachment add logic to check the filename. SOrry there isn't an easier way.
Awesome video! Is there a way to send the link to the newly created file back to Power Apps and drop it into the attachments column in a SharePoint list?
I'm trying to incorporate having users create a list entry from a Power App and upload attachments from the same app screen. There must be a way to include this in the Patch function that takes all the info and populates the columns in the list, but I'm stuck with how to go about getting the URL back from Power Automate.
I know Forms can do this, but there are some drop downs with thousands of options and Forms has not been great at handling the amount of data so I was asked to re-work their form into a Power App.
Check out this video where I talk about using this instead of Attachments. I think the logic you are looking for, or at least a good push in the right direction, is there. th-cam.com/video/5Jv9u2kTy04/w-d-xo.html
This is a great way to upload files but it differs from a way i've been doing it that 'seems' easier. Can you let me know if you see an issue with this way: Add the edit form but keep only the attachments control in it. Shrink the form down to fit around the control and place in my app. Continue building app. Upon clicking the Submit button, i just have submitform execute before all my patches. This eliminates the need for power automate altogether. What say you?
The downside there is it will create the item as an attachment, not as a file in a doc library. I don't like attachments, too hard to work with. BUT if it is doing what you need then rock on! 🤩
Great video ! This Drag & drop is very usefull. Many thank ! 15:01 : We have the same animated icon generator :D.
Hoping MS will add this as native functionality in PowerApps ( with no flow ).
That would be a nice addition for sure. :)
Hi Shane,
What is the difference between v1 and v2 (flow) in power-apps?
Could you please tell how can we upload Multiple attachment in dataverse.
This video explains the different triggers th-cam.com/video/vpjf5mD-COs/w-d-xo.html
This video talks about multi-upload th-cam.com/video/7UeRzfPo8RE/w-d-xo.html though with DV it will be different but should get you started.
Great video as always and hi to Chewy.
One observation I made is that by default if a file with the same name already exists ... it will overwrite it ! Is there a way to upload the file and get it automatically rename it like "Copy of myFile.docx" similar to what happens when you paste a file in a Folder ?
Not that I know of. You would have to build your own logic for that. :(
Hi Shane, firstable I really appreciate this video, it was so helpful. Additionally I would like to know if there is a possibility to loop into a gallery, it means, using: Forall to extract all attachments from allitems of a Gallery? I hope this can be possible...Thank you!
i need exactly the same. No soultion found yet...
Great video, I'm relatively new to Power Apps, is there a way to have this attachment card in a gallery view so each entry within my gallery can have an attachment section associated with it?
I tried copy & pasting this card into my gallery but it didn't seem to create multiple entries.
Try again, I just tested and the attachment control pastes into the gallery for me. Make sure you ahve the template row editing . Good luck
@@ShanesCows Tried it again and it worked.
Thanks again for the video.
Great video as usual. I have two questions. (1) is there any way to return or capture the ID of the document within the document library? (2) Once the file is uploaded, I don't want the user to accidentally upload it again - I want to remove it from the attachment control. Is there a way to do that?
1 - Respond to Power Apps in your flow with the ID. In Power Apps you would have something like Set(varID, Flow.Run(file).ID);
2 - Reset(AttachmentControl) in your OnFileAdd at the bottom
Hi Shane, how to use Dynamic folders for uploading the images or attachments using power apps v2 trigger
Add a Text Input and pass the folder name. Put that dynamic content in the folder location. This video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html shows it for v1 but the concept is the exact same. :) Where the videos shows "ask in Power Apps" use a Text input. Everything else the same. I will put this on the list of video ideas.
Love the content Shane! How can I put this attachment control in repeating table, get attachments in a collection and upload them?
Collect(colStuff, {blob: Last(attachmentcontrol.attachments).Value, filename: Last(attachmentcontrol.attachments).Name}) Something like that, now you have them in a collection like you want. No magic needed.
@@ShanesCows It worked! Thank you so much!! You are my lifesaver, I have been working on this for days!
The video is useful. Thank you. However what we shall do if we have a list of files displayed in PowerApps. How to get its actual state if Refresh kills performance?
Sorry, I don't often display document libraries in galleries so I haven't ran into performance issues with that.
Hi Shane, this is great but how about getting the respond to powerapp or flow. I would love to get the Id from the new uploaded document, just like old one does. Thanks
The Respond to a Power App or flow action is still there. is it not working for you?
@@ShanesCows - I'm not getting the respond back to powerapps with the v2 action - Added to my flow but no results.
Never Mind Shane, sorry I didn't refresh my flow trigger. Thank you very much for all you help. You are the best.
Hi Shane! Great video. Question: I have a use case where a certain project is selected from a gallery, I want that PM to upload all documents for that particualr selected item. Do you have any videos that shows those relationships?
Hi Shane. Is it possible to make the folder directory to which the document is to be saved as dynamic i .e give the user the option to select the path?
Yes. I showed it in this video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html you will have to combine the two concepts. :)
Hi Shane,
I need to basically do this but for uploading Excel files to the Dataverse. Is this possible? I only see a dataverse connector for a single row in Power Automate, and the the upload files option doesn’t recognize the table/data inside the excel file.
Thanks so much
In Dataverse there isn't just upload a file. You would need a table that had a file column then you could upload the file to that column specifically. But DV doesn't have a "document Library" like SharePoint does.
Great and clear video :D But I need your help! I can't seem to get the formula work, it keeps giving te error because of the comma after Value (so it appears). It says 'Unexpected characters.
UploadenbestandnaarSharePoint.Run({contentBytes:Last(Self.Attachments).Value}, name:Last(Self.Attachments).Name})
In your Region do you use a , or a . as your decimal separtor? 12,50 or 12.50 ? If it is the comma, then you are creating power apps formulas you need to adjust. Anywhere that I use a , you use a ; anywhere I use a ; you use a ;;
This video talks about the difference in , regions among other things. th-cam.com/video/GAdnURx5g8g/w-d-xo.html
I'm stuck on the first step, I have been clicking a SharePoint, and uploading the data, but the attachment button doesn't come with. It's brining in the other columns and names, but no attachment button. I'm using some random Sharepoints in my company, but do I need to create my own? I've never done that, so I might be way off from getting to this point.
Hi Shane - really struggling to get this to work in the final stages of writing the formua - it keeps saying video upload is not recognised and other errors. I have signed up to your site - and imported the flow - but not sure how to import the power app template into my environment! Im new to all this - and Chat GPT just doesnt cut it lol
Paul you can email training at powerapps911 dot com and we cans help you with getting the template. 😎
Would be great to add meta data tagging to this app - but use a custom properties button - such as document type - but rather than drop down - just a coloured button that says 'Invoices - and the user just clicks and the colour of the button goes green - then use the upload button?
@@ShanesCows Hi Shane i have emailed in again - with more detail of my issue HELPPPPPP please - im going to go insane lol
This was great! Do you have a video where you show how to upload an attachment based on a gallery for each ThisRecord item? I couldn't find any. I have a SP List where I need to have the ability to upload attachments to the specific list based on a specific ID number within the gallery.
Do you have any videos that discuss sending updated documents to SharePoint with Power Automate? (There is already a document there prior to approval and the second flow is attempting to overwrite the original document with a new version). I keep getting two files with the same name.
Hey there Shane. Thank you for this video, I found it helpful. I do have a question and if this is the wrong solution please let me know. I want to replace the standard document Library upload functionality. Can the document library "Upload" button trigger this Power App? If so, can you provide some guidance?
Hi Shane, I followed all the steps but when I go to OnAddFile the VideoUpload function don't appear on my list, do you know why? Thank you
Did you create the power automate cloud flow?
@@ShanesCowsYes, I did it in power automate then came back to power apps
Great video. Thank you Shane
Glad you enjoyed it, happy Monday
I use this control in dataverse ofte, its great, there is also an id param that you can set if you want to load them back in, in the same order.
Nice. Thanks for sharing. 😀
Hi Shane - great video , and great app! Is there a quick an easy way to add document tagging to this. I have drop down choices - and would also like to use a button to tag docs - i got it wairking , by then it failed.
THis video covers metadata th-cam.com/video/AHWvG2C9vQo/w-d-xo.html 🤩
@@ShanesCows I watched that - is there a download available yet - I couldn't see it ?
@@ShanesCows I'm a subscriber to 911 , and would be great to get hold of the download file
@@paulmcnally4994 training.powerapps911.com/courses/take/video-library/lessons/51131834-12-11-2023-power-apps-file-upload is that the one you are looking for?
@@paulmcnally4994 you can email training@ if you need more help. I don't want to miss anything :)
@ShanesCows you are directly writing the file context to share point. I do the same, however I break it into 2 flows. The PowerApp Flow to get the file, which ends with an HTTP action to a second flow which writes to the sharepoint list. I use JSON in the body to send data from first flow to the send flow. I do this because it allows the account writing to sharepoint to be different than the person in the app who clicked the button and thus for security the sharepoint lists can be locked down from the users. How do you send this new filecontent variable in V2, it doesn't seem to work like the older text variable did. I'm guessing the V2 FileContent is getting messed up when sent on the HTTP body as json?
Thank you very much, Need to know how to get the file name that is uploaded in Power Apps and assign it a variable so that I can generate a link and show it
Check out part 2 the advanced version 🤩 th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
Thank you so much for this, Shane! You've solved my biggest stumbling block with Power Apps.
Taking this further... Is it possible to prompt users to create, say, a "new client" subfolder in the SharePoint directory into which the uploaded files must be stored. Or to select the relevant subfolder from a dropdown menu in the files upload control?
OR - could users upload to Document Sets in SharePoint instead of folders?
🙂
Check out the Advanced video on how to create folders easily 🤩 th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
@@ShanesCows I'm flippin crying with joy over here!!! 😭😭😭😭😭 THANK YOU!!!
Bro Is it possible to rename files in a folder in a SP Document Library using HTTP request in automate? I tried but it kept giving me SP.FILE does not support PATCH/POST method
I haven't tried but in my head it should be possible. :| I will try to look into it but it should be possible.
@@ShanesCowsYeah Xd its is possible.I was making small mistakes in the Send HTTP request action URI and Headers finally got the solution! And Always your Vids
Great ! It would be a game changer if I can have a label to change the name of the file, so when a button is pressed, the name in the label is applied to the document . maybe even upon upload to the attachment control@@ShanesCows
Hey! Great Video, thanky ou so much. You are a lifesaver! Now I have a question: Is it possible to upload all files I've stored in my attachment card? I am currently working on an app that should be able to do that and I'm a fairly new beginner in Power Apps. Do you by any chance have a video to that? I want to upload several pictures into a custom generated document library. My pictures all have custom names already, so I don't really have to name them anymore
See if this video gives you some ideas th-cam.com/video/7UeRzfPo8RE/w-d-xo.html
@@ShanesCows thank you!
@@ShanesCows Hey, me again! I redid everything and I am getting the error it is expecting a blob type. I am losing my mind with this :D
nevermind, I got it!
I didnt get an attachment control in the form when connecting the form to my SharePoint document library data source, only some text fields with labels for the columns. Why?
Connect it to a SharePoint list not doc library. Them copy the control and use it. 😎
@@ShanesCows Thanks, this worked.
Hi Shane, is it possible to upload an image/pdf to a power app that then is stored as part of a sharepoint list row entry as an attachment?
Thank you Shane, nice Video. Could you please show us the other way too? How to "download" or "import" multiple files from specific SharepointItem to this Attachment Control? That would be fantastic for my current project.
This is much easier. However! How do we add the metadata?
This video shows doing it with the v1 trigger. th-cam.com/video/e0kMjb686tc/w-d-xo.html You will have to adapt to v2 but should get you 90% of the way there.
Making a new Metadata video is on my list. You are the second person to ask today. :)
HI Shane, how to delete an attached excel file after uploading it?
In flow there is a Delete file action that you could use.
How Do I dynamically pass the sharepoint site address, folder details, filenames ?
I think video is what you are looking? th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
@ShanesCows Thanks !! Your videos are super helpful.
your formula is missing a column content Bytes with a type of Blob, how to resolve
Check your formula structure again. You have a typo or small piece missing. THe formula I use works. 😎
How to upload multiple files with different metadata to document library?
This video tackles metadata. th-cam.com/video/AHWvG2C9vQo/w-d-xo.html The real challenge is you need a way to store the different metadata in the app first. Maybe a big collection of images and their unique data. It is possible, just more moving parts.
I can't seem to avoid being stuck on error: Missing column. Your formula is missing a column 'contentBytes' with a typo of 'Blob'. Same code and steps as you and tried several other but still no luck. Help please!
This worked:
MyFlow.Run(
{
contentBytes: Last(Self.Attachments).Value,
name: Last(Self.Attachments).Name
}
)
Did you figure it out? Maybe paste your code here and I can try to give you any guesses I might have. What is here should work
@@ShanesCows Yes! In my particular case (doing same steps as you did) the code that works is:
MyFlow.Run(
{
contentBytes: Last(Self.Attachments).Value,
name: Last(Self.Attachments).Name
}
)
Thank you so much. Yo are my favourite source of Power Platform content!
@@FranBellDev Had the same error and it worked for me to thank you !!
Nice video, thanks, do you have any solution to mitigate limitation on bytes? While I am trying to attach more than 75MB gettin json runtime error
I don’t. 50 MB is the most I have ever gotten to consistently work.
@@ShanesCows ok it is 50MB, I have tried azure blob storage for attachment works upto 100MB
What about if they x out the file? Will it not upload to the SharePoint library?
If you put the upload logic OneAddFile then it goes as soon as they attach it.
@@ShanesCows how can you remove it from the list of they remove it from the upload? Like they attach the wrong file and don't want it in the list?
Does the user uploading the file need permission to the folder?
If so, how would you keep the people from seeing the documents on the backend because people can search sharepoint ?
Awesome video. Thank you!🎉
Yes. You could use thie video to change permissions. PowerApps SharePoint Item Level Permissions via Power Automate
th-cam.com/video/vGSNrj82JcI/w-d-xo.html
Thanks for the video Shane! But the attachment control has a limitation on the file size (max50MB, some claim it to be 94MB), however I want to upload a 400MB file from PowerApps to SharePoint library. Can you please let me know what's the best way to do that?
Do we have solution for this ??
can you post about selection a charcter then if pressed it will glow? thank you
Sorry, I don't understand the question.
@@ShanesCows oh sorry, i mean if image is pressed there a glowing green(any color) on border thanks
First, thank you for providing these training videos. They are often the difference between complete and total failure and success! Second, normally I can modify the content to suit my needs; however, today I've not been so fortunate. I have created the V2 app with the file input then added a second Text input. In this case, the My File input comes before the Text input. I comma delimit the two inputs; however, this results in a "missing column" error. For example: "UploadBoardMeetingMinutesFile.Run({file:{contentBytes:Last(Self.Attachments).Value, name:Last(Self.Attachments).Name}}, Text(DatePicker1.SelectedDate));" Any suggestions?
I believe that I was bitten by the MS bug you mentioned. I have corrected that by starting over with the V2 flow; however, I still have an issue formatting a "run" statement in a canvas app when I'm attempting to pass a File and a Text Parameter type to the V2 flow. I have formatted lots of (V2) flows with a mix of other than a File parameter. Do you have any videos that mix and match V2 flows with File and other parameter types? Bill
Bill check that Power Apps doesn't want them in the opposite order. Run(text,file) sometimes we assume the wrong order.
Doing a video on uploading and setting the metadata is on my list. I get a lot of these questions. :)
Can I use a Camera control to add attachments this way?
Yes, the only difference is camera doesn’t have a file name so you will need to create one.
@@ShanesCows lol this is so much easier than before! Thank you, Sir.
This was very useful, would be interesting to know if you could automate a file upload based on a file being dropped into a folder. A watched folder type scenario.
Yes, you would do that using Power Automate to watch the folder, grab the file, and put it where you want. Power Apps wouldn't be part.
Yoo git another question for ya 😅. I want to delete a file/Document in a SP Library.. is it possible using Graph Api? In powerapps (without using power Automate)
Unfortunately it still is converted to JSON when passing the file to Power Automate, so there is a cap at around 70MB per file.
If you have gotten to 70 MB you are doing great. 50 is usually the size cap I tell people.
Hi Shane, ive got a question, How could i attach those multiple files as one in an OutLook Mail or Approvals? Right now its sending two separate mails with each one a different picture but How could i send it all in one Mail?
Any tips for doing this from a Mobile App and not Web (desktop)? I've got a use case to load a 10-20 second video from a Mobile Device (iphone), but when I select the control on an iPhone I only see options for photos - no videos. Anyone ever seen a workaround?
I have heard other's report this but I have never looked into it, sorry. Not sure why uploading videos is different on phone :(
Why when I save a excel file on my SP it has a white "file icon" and I have to download it for seeing whats in it? Because of it I can't access to a file table that I need. Thank you for helping me in my project!