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 :')
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.)
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!
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 RUclips, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
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...
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.
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, 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?
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 ).
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! 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?
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.
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! 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 :) ruclips.net/video/K74UFYgrKB4/видео.html
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 ruclips.net/video/ovLIwnj6QjU/видео.html
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?
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.
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. ruclips.net/video/e0kMjb686tc/видео.html I think that should get you there.
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 ruclips.net/video/AHWvG2C9vQo/видео.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
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.
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?
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?
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
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.
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.
@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?
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?
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.
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.
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)
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 ?
Would love to see how you would do this where you need to add metadata for each file. Example: a value to tie all the attachments to an identifier field on a SPO intake list.
@@ShanesCows The method for adding the metadata that you use in the other video would add the same metadata to all the files, if you're using the ForAll loop to run the flow for each file, right? Would there be a way to have unique metadata for each file? I'm currently accomplishing this using the now 'Old school' JSON method but I would love to start using the new File trigger action.
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. 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?
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!
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.
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
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!
This video explains the different triggers ruclips.net/video/vpjf5mD-COs/видео.html This video talks about multi-upload ruclips.net/video/7UeRzfPo8RE/видео.html though with DV it will be different but should get you started.
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, 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?
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! 🤩
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
Great video, but a small warning regarding PowerApps triggers, certain users may face certain issues depending on their permissions set within each Power Platform environment. This can lead to unexpected issues on the production environment by certain users that weren't caught during testing and can be a real pain to deal with.
Am I fighting a lost cause with all these on premise type solutions I am trying to build! It would seem every feature exists for cloud but not for on premise :(
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? 🙂
Add a Text Input and pass the folder name. Put that dynamic content in the folder location. This video ruclips.net/video/2gE0e_AsdMw/видео.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.
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
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 ruclips.net/video/vGSNrj82JcI/видео.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?
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
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?
Thanks so much for the video! I can see that it’s working it uploads to the right folder however I can’t get any of the pop ups to do anything to show the user that it’s working. It doesn’t appear the UpdateContext({varShowUploading:true}) is doing anything for me even though I’m not getting any errors.
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?
Shane Mate-Great Video! We are looking to add image file meta/column data to a SharePoint library. We have thousands of photographs we want to upload to SharePoint. If our teachers could go to a Powerapp and upload the files taken on their phones from an event, fill in a few fields, and hit upload, that would be sensational. What do you think - about the next video "Upload a file to SharePoint with Metadata"
It is like you are spying on me. Not going to promise I will release this video on Monday but... I built that exact app on Monday and have the demo ready to record. 🤩
Great video! I am not dealing anymore with base64😂. Question: when the file is attached, how do you pass a column value while you upload a document to the library?
Create a second variable to store the data for the column. Then add a new step to the flow - Update file property -> for ID field use itemID ; Use the variable for the column value.
Possible: Pass file contents to child flow for creation? I can create the file with no issue in the parent, but if I try to pass the file contents to a child flow I get a null error at the run child flow step.
If I use document library to upload the attachment in my form , then how I edit /view the attachments ? I got trouble on this actually i did not find any solution
You bet. The advanced follow up is here if it helps. Advanced Power Apps File Uploads - Create folders and set metadata ruclips.net/video/AHWvG2C9vQo/видео.html
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 video shows doing it with the v1 trigger. ruclips.net/video/e0kMjb686tc/видео.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. :)
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
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?
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. ⭐
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.
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. 😎
Love that you show both interfaces. they are so different when you are new.
Agree, super confusing 😎
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.)
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!
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.
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 RUclips, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
Appreciate the kind words 😎
Once again Shane thank you for all the effort you give on sharing all you knowledge 🙏🙃
My pleasure!
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!
Excellent! simple, fast and easy as Shane always does!
Thanks! I did just today release Advanced Uploads which is great follow up :) ruclips.net/video/AHWvG2C9vQo/видео.html
Great Video Shane. This is very helpful. Thanks for sharing your knowledge
Happy to help. Have a great day. 🐶
OMG, you just made my week. Thanks for this 😊
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.
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!
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. 😎 ruclips.net/video/2gE0e_AsdMw/видео.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
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. :)
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.
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!
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. 😎
That is so amazing, Shane!
Happy to help. Have a great day and happy holidays. 🎄
Great video Shane! I'm using Ms graph to upload document library instead of flow.
Cool. If that works for you then rock on. 🤩
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 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, 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 - ruclips.net/video/r3UC3TMXhlI/видео.html, around 8:10 is where the logic is explained in detail.
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, 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
ruclips.net/video/u-b8w9ea1kk/видео.html
Great video. Thank you Shane
Glad you enjoyed it, happy Monday
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?
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.
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
ruclips.net/video/K74UFYgrKB4/видео.html talks about Attachments, they are a different beast.
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. 😎
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 ruclips.net/video/AHWvG2C9vQo/видео.html
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 :) ruclips.net/video/K74UFYgrKB4/видео.html
Great video! Love it
Thanks so much!
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
ruclips.net/video/7UeRzfPo8RE/видео.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 ruclips.net/video/ovLIwnj6QjU/видео.html
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.
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.
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. ruclips.net/video/e0kMjb686tc/видео.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 😀
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 ruclips.net/video/AHWvG2C9vQo/видео.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
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.
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
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?
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?
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!
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.
Awesome video! Thank you
@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?
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. :) ruclips.net/video/e0kMjb686tc/видео.html Guess I need to make a new version of it. :)
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.
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
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)
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. :(
Would love to see how you would do this where you need to add metadata for each file. Example: a value to tie all the attachments to an identifier field on a SPO intake list.
Apply the metadata concept from this video ruclips.net/video/e0kMjb686tc/видео.html
@@ShanesCows this is exactly what I was looking for. Of course you would have already cover it. Thank you.
@@ShanesCows The method for adding the metadata that you use in the other video would add the same metadata to all the files, if you're using the ForAll loop to run the flow for each file, right? Would there be a way to have unique metadata for each file? I'm currently accomplishing this using the now 'Old school' JSON method but I would love to start using the new File trigger action.
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.
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.
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.
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 ruclips.net/video/2gE0e_AsdMw/видео.html you will have to combine the two concepts. :)
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!
As always , realy good
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.
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. ruclips.net/video/AHWvG2C9vQo/видео.html 😎
@@ShanesCows Thank you so much!
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...
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?
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 ruclips.net/video/vpjf5mD-COs/видео.html
This video talks about multi-upload ruclips.net/video/7UeRzfPo8RE/видео.html though with DV it will be different but should get you started.
Hi Shane, what if the file needs indexing as well? Can this be done in Power Apps? (I'm using SharePoint term store for files indexing)
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, 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?
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! 🤩
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.
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 🤩 ruclips.net/video/AHWvG2C9vQo/видео.html
Great video, but a small warning regarding PowerApps triggers, certain users may face certain issues depending on their permissions set within each Power Platform environment. This can lead to unexpected issues on the production environment by certain users that weren't caught during testing and can be a real pain to deal with.
Am I fighting a lost cause with all these on premise type solutions I am trying to build! It would seem every feature exists for cloud but not for on premise :(
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 🤩 ruclips.net/video/AHWvG2C9vQo/видео.html
@@ShanesCows I'm flippin crying with joy over here!!! 😭😭😭😭😭 THANK YOU!!!
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 ruclips.net/video/2gE0e_AsdMw/видео.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.
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, 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
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
ruclips.net/video/vGSNrj82JcI/видео.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 ??
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
Thanks a lot!
Happy to help. Have a great day. 🐶
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
Thanks so much for the video! I can see that it’s working it uploads to the right folder however I can’t get any of the pop ups to do anything to show the user that it’s working. It doesn’t appear the UpdateContext({varShowUploading:true}) is doing anything for me even though I’m not getting any errors.
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.
Shane Mate-Great Video! We are looking to add image file meta/column data to a SharePoint library. We have thousands of photographs we want to upload to SharePoint. If our teachers could go to a Powerapp and upload the files taken on their phones from an event, fill in a few fields, and hit upload, that would be sensational. What do you think - about the next video "Upload a file to SharePoint with Metadata"
It is like you are spying on me. Not going to promise I will release this video on Monday but... I built that exact app on Monday and have the demo ready to record. 🤩
Great video! I am not dealing anymore with base64😂. Question: when the file is attached, how do you pass a column value while you upload a document to the library?
Create a second variable to store the data for the column. Then add a new step to the flow - Update file property -> for ID field use itemID ; Use the variable for the column value.
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.
Thanks!
Happy to help! This video on Advanced uploads is nice follow ;) ruclips.net/video/AHWvG2C9vQo/видео.html
Possible: Pass file contents to child flow for creation? I can create the file with no issue in the parent, but if I try to pass the file contents to a child flow I get a null error at the run child flow step.
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
If I use document library to upload the attachment in my form , then how I edit /view the attachments ? I got trouble on this actually i did not find any solution
Thanks for the video
You bet. The advanced follow up is here if it helps. Advanced Power Apps File Uploads - Create folders and set metadata
ruclips.net/video/AHWvG2C9vQo/видео.html
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 is much easier. However! How do we add the metadata?
This video shows doing it with the v1 trigger. ruclips.net/video/e0kMjb686tc/видео.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. :)
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 ruclips.net/video/7UeRzfPo8RE/видео.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!
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 ruclips.net/video/AHWvG2C9vQo/видео.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 :)