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!
@ShanesCows
29 күн бұрын
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}}) 🤷
@natebig
29 күн бұрын
@@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.
@guyweltjens3661
23 күн бұрын
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] } }
@bl4747
16 күн бұрын
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!
@paridhigupta2747
20 күн бұрын
I tried many tutorials to achieve this but got the working solution only through your video. Thank you very much!!
@ShanesCows
19 күн бұрын
Awesome, glad to help. 😎
@sairamudayshankar3825
6 ай бұрын
Thank you very much, Shane! You're a blessing to the Power Platform community!
@ShanesCows
6 ай бұрын
I appreciate that! Have a great day!
@therisingsun4828
9 ай бұрын
I have NEVER seen that As FILE snippet before in PowerFX, I learned something new today, thank you Shane!
@ShanesCows
9 ай бұрын
One of my favorite make my life easier tricks.
@UvAnnieljevla
9 ай бұрын
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 :')
@OpusMagnoCards
8 ай бұрын
Exactly, saw a post on a forum recommending exactly that - excluding file:{} - and worked as a breeze.
@Tech2188
7 ай бұрын
Love that you show both interfaces. they are so different when you are new.
@ShanesCows
7 ай бұрын
Agree, super confusing 😎
@antoniobranderas
9 ай бұрын
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.
@ShanesCows
9 ай бұрын
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!
@notuern
9 ай бұрын
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.)
@club-crm1080
4 ай бұрын
Excellent! simple, fast and easy as Shane always does!
@ShanesCows
4 ай бұрын
Thanks! I did just today release Advanced Uploads which is great follow up :) kzitem.info/news/bejne/on6N3HtofGunhKQ
@nikolaoszacharakis9533
8 ай бұрын
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 KZitem, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
@ShanesCows
8 ай бұрын
Appreciate the kind words 😎
@xXanlocar74Xx
7 ай бұрын
2024 and still no control to upload files without doing magic... Thanks for your video Shane, helpful as always!
@ShanesCows
7 ай бұрын
Glad to help, one day we will get a control, one day.
@greatkingrat
Ай бұрын
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! :)
@ShanesCows
Ай бұрын
You're welcome! Thanks for the update, I love hearing when stuff works. 😎
@brownjohn5928
9 ай бұрын
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...
@ShanesCows
9 ай бұрын
Glad to help! Happy Holidays!
@pennyp5822
9 ай бұрын
Great Video Shane. This is very helpful. Thanks for sharing your knowledge
@ShanesCows
9 ай бұрын
Happy to help. Have a great day. 🐶
@nikkijoy226
8 ай бұрын
OMG, you just made my week. Thanks for this 😊
@joseph_372
8 ай бұрын
Brilliant stuff. Thanks for taking the time to make it look so easy!
@msaccessdatabasetraining3809
8 ай бұрын
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.
@gazzoyep7900
7 ай бұрын
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
@ShanesCows
7 ай бұрын
I explained the concept in this older video. 😎 kzitem.info/news/bejne/k517lpmVeqWVgKw
@gazzoyep7900
7 ай бұрын
@@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
@kev.m.powerplatform
9 ай бұрын
Great video Shane. Thanks! A real shame this many years later MS still haven't added that attachment control to the available controls list.
@ShanesCows
9 ай бұрын
I need to ask them why, it is quite curious for sure. :)
@joshuamalcolm4890
9 ай бұрын
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).
@brendanerofeev
9 ай бұрын
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.
@ARandomPlayer967
8 ай бұрын
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.
@therisingsun4828
9 ай бұрын
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!
@notuern
9 ай бұрын
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.
@DrewTattam
8 ай бұрын
Love this! Thank you for posting! Will you be posting an updated video showing how to set metadata using the v2 trigger?
@ShanesCows
8 ай бұрын
Someone else indirectly asked for that. I think that would be a good idea.
@mickeyatty
8 ай бұрын
@@ShanesCows Yes, please because i tried and I am getting an error message.
@mickeyatty
8 ай бұрын
Okay, after playing around I was able to figure it out.
@DrewTattam
8 ай бұрын
@@mickeyatty would love to hear how you did this!
@CINsyg
9 ай бұрын
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.
@ShanesCows
9 ай бұрын
Nice. Thanks for sharing. 😀
@mdhidayat5706
9 ай бұрын
Great video Shane! I'm using Ms graph to upload document library instead of flow.
@ShanesCows
9 ай бұрын
Cool. If that works for you then rock on. 🤩
@jeanpierreragequit1726
9 ай бұрын
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 ).
@ShanesCows
9 ай бұрын
That would be a nice addition for sure. :)
@SiMataR01
9 ай бұрын
That is so amazing, Shane!
@ShanesCows
9 ай бұрын
Happy to help. Have a great day and happy holidays. 🎄
@oluwatobipaul6171
9 ай бұрын
Great video. Thank you Shane
@ShanesCows
9 ай бұрын
Glad you enjoyed it, happy Monday
@NataliiaKryvoruchko
18 күн бұрын
Thanks a lot!
@ShanesCows
18 күн бұрын
Happy to help. Have a great day. 🐶
@Stephenm84
8 ай бұрын
Awesome video! Thank you
@Pmoscola
2 күн бұрын
Thanks for the video
@ShanesCows
2 күн бұрын
You bet. The advanced follow up is here if it helps. Advanced Power Apps File Uploads - Create folders and set metadata kzitem.info/news/bejne/on6N3HtofGunhKQ
@szaitis
Ай бұрын
Thanks!
@ShanesCows
Ай бұрын
Happy to help! This video on Advanced uploads is nice follow ;) kzitem.info/news/bejne/on6N3HtofGunhKQ
@dwang085
9 ай бұрын
Great video! Love it
@ShanesCows
9 ай бұрын
Thanks so much!
@sllleeepy
7 ай бұрын
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?
@julienvdc
Ай бұрын
Hey I am having a very similar issue, have you found a solution to this?
@sllleeepy
Ай бұрын
@@julienvdc yep, used this video from Reza Dorrani - kzitem.info/news/bejne/02mLqWeKhoqZn34, around 8:10 is where the logic is explained in detail.
@VuNguyen-pv2lp
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
This video will help with that. Power Apps SharePoint Document Library Browser kzitem.info/news/bejne/1mOYnqtvnpNinqA
@Chello83
6 ай бұрын
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.
@thecosmo132
6 ай бұрын
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
6 ай бұрын
Apply the metadata concept from this video kzitem.info/news/bejne/xmahs56Yb2pnp5g
@thecosmo132
6 ай бұрын
@@ShanesCows this is exactly what I was looking for. Of course you would have already cover it. Thank you.
@steegbj
5 ай бұрын
@@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.
@willmeow00
8 ай бұрын
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.
@petereriksson6859
9 ай бұрын
As always , realy good
@Kjrack-u9v
2 ай бұрын
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 ?
@ShanesCows
2 ай бұрын
Not that I know of. You would have to build your own logic for that. :(
@nehajhade496
8 ай бұрын
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
@julienvdc
Ай бұрын
Having the same issue, have you found a solution?
@pierrickdefossez3157
7 ай бұрын
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?
@ShanesCows
7 ай бұрын
That is exactly it. When they add an attachment add logic to check the filename. SOrry there isn't an easier way.
@sonakification
9 ай бұрын
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!!
@danulienka4030
7 ай бұрын
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.
@THEDTSMAN
9 ай бұрын
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.
@ShanesCows
9 ай бұрын
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.
@MerlinVac
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
This video covers the metadata portion. :) kzitem.info/news/bejne/xmahs56Yb2pnp5g Guess I need to make a new version of it. :)
@ErinCH93
8 ай бұрын
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?
@ShanesCows
8 ай бұрын
Yes. If you add a folder to the path and it doesn’t exist it will automatically be created. 😎
@bryankendig3989
4 ай бұрын
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
@ShanesCows
4 ай бұрын
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 :) kzitem.info/news/bejne/rG1qu3qPoKR8dWk
@wendymeyer1250
3 ай бұрын
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? 🙂
@ShanesCows
3 ай бұрын
Check out the Advanced video on how to create folders easily 🤩 kzitem.info/news/bejne/on6N3HtofGunhKQ
@wendymeyer1250
3 ай бұрын
@@ShanesCows I'm flippin crying with joy over here!!! 😭😭😭😭😭 THANK YOU!!!
@ethanyandow5945
9 ай бұрын
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!
@ShanesCows
9 ай бұрын
Combine what you learned in this video with the metadata updating from this viddeo. kzitem.info/news/bejne/xmahs56Yb2pnp5g I think that should get you there.
@ethanyandow5945
9 ай бұрын
@@ShanesCows Awesome! Thanks for getting back to me! I'll check it out and let you know the results 😀
@VDOTKimberly
4 ай бұрын
This is much easier. However! How do we add the metadata?
@ShanesCows
4 ай бұрын
This video shows doing it with the v1 trigger. kzitem.info/news/bejne/xmahs56Yb2pnp5g 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. :)
@ozducks
6 ай бұрын
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?
@ShanesCows
6 ай бұрын
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 kzitem.info/news/bejne/0KyCr6uko2iCnYo
@steveandrews7312
4 ай бұрын
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"
@ShanesCows
4 ай бұрын
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. 🤩
@Мак-ю1л
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
Sorry, I don't often display document libraries in galleries so I haven't ran into performance issues with that.
@callfusion2012
9 ай бұрын
API or Flow? I'll get this working! 👌
@ShanesCows
9 ай бұрын
👍 You got this. 😎
@fernandofilloy3990
6 ай бұрын
Hello Shane!! Love your videos!!! One quick question!! is this working for video files also? What size is the maximum?? thank youuu
@ShanesCows
6 ай бұрын
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.
@tluu8501
9 ай бұрын
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!🎉
@ShanesCows
9 ай бұрын
Yes. You could use thie video to change permissions. PowerApps SharePoint Item Level Permissions via Power Automate kzitem.info/news/bejne/132JtKagcWR7ln4
@EllieCarter5225
8 ай бұрын
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?
@billwinkel3270
4 ай бұрын
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?
@billwinkel3270
4 ай бұрын
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
@ShanesCows
4 ай бұрын
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. :)
@alantoms9298
8 ай бұрын
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?
@steviedewar2248
9 ай бұрын
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
@ShanesCows
9 ай бұрын
kzitem.info/news/bejne/rG1qu3qPoKR8dWk talks about Attachments, they are a different beast.
@-rb_1
9 ай бұрын
Is there any performance difference between sending file as JSON vs file?
@ShanesCows
9 ай бұрын
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.
@chaimrabinowitz
8 ай бұрын
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?
@ShanesCows
8 ай бұрын
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
@TechForze
9 ай бұрын
Unfortunately it still is converted to JSON when passing the file to Power Automate, so there is a cap at around 70MB per file.
@ShanesCows
9 ай бұрын
If you have gotten to 70 MB you are doing great. 50 is usually the size cap I tell people.
@stephaniacastillo4487
8 ай бұрын
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!
@Chello83
6 ай бұрын
i need exactly the same. No soultion found yet...
@liraspberry6966
9 ай бұрын
Love the content Shane! How can I put this attachment control in repeating table, get attachments in a collection and upload them?
@ShanesCows
9 ай бұрын
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.
@liraspberry6966
9 ай бұрын
@@ShanesCows It worked! Thank you so much!! You are my lifesaver, I have been working on this for days!
@AssefaKebede-vm8hz
8 ай бұрын
Hi Shane great video!! quick question .how do you transparent the attachment control?
@ShanesCows
8 ай бұрын
You have to go to the different properties, like color, fill, border color, etc and change them to Color. Transparent.
@AssefaKebede-vm8hz
8 ай бұрын
@@ShanesCows i use phone app to attach the video but only attach photo. No option for video. Any Idea? Thanks.
@elmasinvisible007
2 ай бұрын
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
@ShanesCows
2 ай бұрын
The Respond to a Power App or flow action is still there. is it not working for you?
@elmasinvisible007
2 ай бұрын
@@ShanesCows - I'm not getting the respond back to powerapps with the v2 action - Added to my flow but no results.
@elmasinvisible007
2 ай бұрын
Never Mind Shane, sorry I didn't refresh my flow trigger. Thank you very much for all you help. You are the best.
@evanhagos7901
9 ай бұрын
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?
@virajfernando2694
6 ай бұрын
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.
@bryancampbell8942
6 ай бұрын
@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?
@livethislove
3 ай бұрын
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.
@natcongreso2763
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
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.
@natcongreso2763
9 ай бұрын
@@ShanesCows Gotcha, but still hoping I can find some ways to do it :D looking forward on that content of yours
@sharepointdeveloper4386
5 ай бұрын
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.
@ShanesCows
5 ай бұрын
This video explains the different triggers kzitem.info/news/bejne/16agzGmjfV90gqg This video talks about multi-upload kzitem.info/news/bejne/mIubuK6ciaFphXo though with DV it will be different but should get you started.
@AKo-vi6pe
3 ай бұрын
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
@ShanesCows
3 ай бұрын
See if this video gives you some ideas kzitem.info/news/bejne/mIubuK6ciaFphXo
@AKo-vi6pe
3 ай бұрын
@@ShanesCows thank you!
@AKo-vi6pe
3 ай бұрын
@@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
@AKo-vi6pe
3 ай бұрын
nevermind, I got it!
@edoardoraccanello9938
7 ай бұрын
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!
@RajeshMandal-js9zc
4 ай бұрын
your formula is missing a column content Bytes with a type of Blob, how to resolve
@ShanesCows
4 ай бұрын
Check your formula structure again. You have a typo or small piece missing. THe formula I use works. 😎
@chintaginjalasrinadh
7 ай бұрын
Hi Shane this video is suberb could you please tell how to add the the text Column along with the Attachment
@ShanesCows
7 ай бұрын
THis older video explains the concept. 😎 kzitem.info/news/bejne/xmahs56Yb2pnp5g
@chrisserra7487
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
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
@chintaginjalasrinadh
9 ай бұрын
Hi Shane, how to use Dynamic folders for uploading the images or attachments using power apps v2 trigger
@ShanesCows
9 ай бұрын
Add a Text Input and pass the folder name. Put that dynamic content in the folder location. This video kzitem.info/news/bejne/k517lpmVeqWVgKw 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.
@UBOTSYT
6 ай бұрын
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)
@uncleslapslap
7 ай бұрын
While experimenting with this I've tried to add an "Update File Properties" step to the flow so that additional columns of metadate can be stored along with the file, but simply adding the triggerBody()?['file']?[''] doesn't work as powerapps doesn't manage to pass the info to flow (or so it would seem). The flow runs with all green ticks, uploads the file OK, but doesn't update the file properties. My function is: 'ExpenseApp-UploadReceipttoSP'.Run({ file:{ contentBytes: Last(Attachment.Attachments).Value, name: HIDDEN_AttachmentNameComposer.Text, DocVendor: DataCardValue23.Text, Description: DataCardValue12.Text, ExpenseIDDoc: varNewExpenseID // This is why attachment must be uploaded after form submitted to ensure matching IDs }}); Reset(Attachment); I wonder if this is due to not having the forsight to add the extra flow step when I first created the flow?
@joywindsouza817
14 күн бұрын
How to upload multiple files with different metadata to document library?
@ShanesCows
11 күн бұрын
This video tackles metadata. kzitem.info/news/bejne/on6N3HtofGunhKQ 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.
@jennadaley1
2 ай бұрын
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?
@samishaw7483
6 ай бұрын
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.
@ShanesCows
6 ай бұрын
Yes. This video will explain the mechanics. Power Apps Upload Multiple Files AND Drag and Drop Files kzitem.info/news/bejne/mIubuK6ciaFphXo
@craiglee3625
4 ай бұрын
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?
@ShanesCows
4 ай бұрын
I have heard other's report this but I have never looked into it, sorry. Not sure why uploading videos is different on phone :(
@stylishskater92
4 ай бұрын
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?
@ShanesCows
4 ай бұрын
Connect it to a SharePoint list not doc library. Them copy the control and use it. 😎
@stylishskater92
4 ай бұрын
@@ShanesCows Thanks, this worked.
@chalmercanizares42
7 ай бұрын
HI Shane, how to delete an attached excel file after uploading it?
@ShanesCows
7 ай бұрын
In flow there is a Delete file action that you could use.
@cbtjoe
9 ай бұрын
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?
@ShanesCows
9 ай бұрын
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! 🤩
@PaulMcNally-u6g
2 ай бұрын
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
@ShanesCows
Ай бұрын
Paul you can email training at powerapps911 dot com and we cans help you with getting the template. 😎
@PaulMcNally-u6g
Ай бұрын
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?
@PaulMcNally-u6g
Ай бұрын
@@ShanesCows Hi Shane i have emailed in again - with more detail of my issue HELPPPPPP please - im going to go insane lol
@Cliquid3
9 ай бұрын
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.
@ShanesCows
9 ай бұрын
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
@Cliquid3
9 ай бұрын
@@ShanesCows Tried it again and it worked. Thanks again for the video.
@seshadrir85
7 ай бұрын
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?
@ShanesCows
7 ай бұрын
Yes. I showed it in this video kzitem.info/news/bejne/k517lpmVeqWVgKw you will have to combine the two concepts. :)
@FranBellDev
4 ай бұрын
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!
@FranBellDev
4 ай бұрын
This worked: MyFlow.Run( { contentBytes: Last(Self.Attachments).Value, name: Last(Self.Attachments).Name } )
@ShanesCows
4 ай бұрын
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
@FranBellic
4 ай бұрын
@@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!
@Garoseau
Ай бұрын
@@FranBellDev Had the same error and it worked for me to thank you !!
@paulinedahne
5 ай бұрын
I have used the Upload Multiple files method many time successfully (Thanks to you!) using ForAll(AttachControl.Attachments As FILE FileUpload.Run({file:{contentBytes:FILE.Value, name:FILE.Name}})) but today I have used tried to use it in an old PowerApp to replace the V1 way of uploading files and I am getting Missing Column, Your formula is missing a column 'contentBytes' with a type of 'Blob'. The function 'Run' has some invalid arguments. I am using exactly the same syntax so cannot understand why this is happening - is it a bug?
@paulinedahne
5 ай бұрын
Sorry now sorted - you need to remove the {file: part and extra }
@ShanesCows
5 ай бұрын
Glad you got it workign!
@CatNappingZzzz
5 ай бұрын
I too have seen this issue, and have worked out that it depends on whether you use the old or the new designer for flow. Using the new designer, you don’t need file: {} to be wrapped around the contentBytes and name in powerApps whereas the old one does. TBH I thought I was going mad…
@THEDTSMAN
7 ай бұрын
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 :(
@mattyy17
Ай бұрын
Only downside to this is it triggers the flow per file uploaded. Is there a way to do this with V2 that uploads multiple files as a single flow?
@ShanesCows
Ай бұрын
Maybe but probably not. The problem you have is a bunch of files put into a collection (possible) gets to be a very large payload and you run into timeout challenges or size. Technically possible though. You would put all of the base64 and files names in a collection (use this kzitem.info/news/bejne/yqOe3q1pi3eYi5g video to get the concept) and then loop through them in the flow
@paulmcnally4994
Ай бұрын
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.
@ShanesCows
Ай бұрын
THis video covers metadata kzitem.info/news/bejne/on6N3HtofGunhKQ 🤩
@paulmcnally4994
Ай бұрын
@@ShanesCows I watched that - is there a download available yet - I couldn't see it ?
@paulmcnally4994
Ай бұрын
@@ShanesCows I'm a subscriber to 911 , and would be great to get hold of the download file
@ShanesCows
Ай бұрын
@@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
Ай бұрын
@@paulmcnally4994 you can email training@ if you need more help. I don't want to miss anything :)
@monimonika4647
5 ай бұрын
I am using the same way but getting access denied error when uploading file to sharepoint, can you please let me know if you have any idea?
@ShanesCows
5 ай бұрын
Have you tried going to SharePoint in the browser and uploading a file directly there. I think it is a SharePoint permissions issue.
@monimonika4647
5 ай бұрын
Thank you for your reply sir. Yes, I was able to upload from SharePoint. And it got fixed from flow now. We used "File" while passing parameter and it got fixed after changing to "file".
@kaidenkaiser-barton820
9 ай бұрын
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
@ShanesCows
9 ай бұрын
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.
@usmcrtr
8 ай бұрын
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.
@electrichope4049
6 ай бұрын
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?
@faharalzadjali5606
6 ай бұрын
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
@juanrtato
7 ай бұрын
It doesn’t work. The function.run() has syntax errors, helppp
@nikki3788
6 ай бұрын
What about if they x out the file? Will it not upload to the SharePoint library?
@ShanesCows
6 ай бұрын
If you put the upload logic OneAddFile then it goes as soon as they attach it.
@nikki3788
6 ай бұрын
@@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?
Пікірлер: 287