Power Apps Upload File v2 to SharePoint Document Library
Вставка
- Опубліковано 14 лип 2024
- In this tutorial, you'll dive into the world of file uploads in Power Apps, leveraging the new Power Automate V2 trigger. Say goodbye to the complexities of base64 encoding and embrace a more straightforward approach. You'll learn how to upload both single and multiple files with ease. The video guides you through creating a user-friendly interface for file uploads, including handling various file types beyond just images. Additionally, you'll explore how to set up a Power Automate Cloud flow to save these files to SharePoint, ensuring a seamless integration between Power Apps and your data storage.
Key takeaways include:
Utilizing the attachment control for file uploads.
Setting up and configuring Power Automate Cloud flows.
Handling single and multiple file uploads.
Integrating with SharePoint for file storage.
Tips for creating a user-friendly upload interface.
Whether you're dealing with single file uploads or need to handle multiple files at once, this tutorial has got you covered. Enhance your Power Apps with efficient file upload capabilities today!
Up your Power Apps Skills Today!
www.powerapps911.com/up-your-...
0:00 Power Apps Upload a file v2
1:34 Adding the Attachment Control
4:38 Create the Power Automate Cloud flow
7:44 Create the flow in the new Power Automate studio
9:25 Trigger the flow to upload the file
12:34 Making it a nice user experience
16:21 Multiple file upload in POwer Apps
Do you need some help on something that you are working on, contact us!
www.powerapps911.com/contact
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane
#powerapps #PowerPlatform #CanvasApps #modeldriven - Наука та технологія
Love that you show both interfaces. they are so different when you are new.
Agree, super confusing 😎
Thank you very much, Shane! You're a blessing to the Power Platform community!
I appreciate that! Have a great day!
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!
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.
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 UA-cam, and that is your channel 😁 Thank you very much man, you just made my day. Keep on the great work 🤟
Appreciate the kind words 😎
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.
Brilliant stuff. Thanks for taking the time to make it look so easy!
OMG, you just made my week. Thanks for this 😊
Excellent! simple, fast and easy as Shane always does!
Thanks! I did just today release Advanced Uploads which is great follow up :) ua-cam.com/video/AHWvG2C9vQo/v-deo.html
Great Video Shane. This is very helpful. Thanks for sharing your knowledge
Happy to help. Have a great day. 🐶
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.)
That is so amazing, Shane!
Happy to help. Have a great day and happy holidays. 🎄
Great video. Thank you Shane
Glad you enjoyed it, happy Monday
Awesome video! Thank you
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.
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! Love it
Thanks so much!
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. :)
As always , realy good
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. 😎 ua-cam.com/video/2gE0e_AsdMw/v-deo.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! 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.
Great video Shane! I'm using Ms graph to upload document library instead of flow.
Cool. If that works for you then rock on. 🤩
Great video thanks.
Glad you liked it!
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. 😀
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 ! 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. :)
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!
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.
Hi Shane! Great video. Question: I have a use case where a certain project is selected from a gallery, I want that PM to upload all documents for that particualr selected item. Do you have any videos that shows those relationships?
Hi Shane! 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 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.
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.
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
ua-cam.com/video/u-b8w9ea1kk/v-deo.html
Thanks for the video @ShanesCows It is really helpful. I have one query. This video will trigger my flow thrice if I have uploaded three files. Can I just trigger my flow once and upload three files in one go? is it possible
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?
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. ua-cam.com/video/e0kMjb686tc/v-deo.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 😀
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 ua-cam.com/video/e0kMjb686tc/v-deo.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.
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, 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?
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.
@ShanesCows you are directly writing the file context to share point. I do the same, however I break it into 2 flows. The PowerApp Flow to get the file, which ends with an HTTP action to a second flow which writes to the sharepoint list. I use JSON in the body to send data from first flow to the send flow. I do this because it allows the account writing to sharepoint to be different than the person in the app who clicked the button and thus for security the sharepoint lists can be locked down from the users. How do you send this new filecontent variable in V2, it doesn't seem to work like the older text variable did. I'm guessing the V2 FileContent is getting messed up when sent on the HTTP body as json?
Thank you 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 ua-cam.com/video/ovLIwnj6QjU/v-deo.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.
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
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
ua-cam.com/video/K74UFYgrKB4/v-deo.html talks about Attachments, they are a different beast.
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!
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.
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 :) ua-cam.com/video/K74UFYgrKB4/v-deo.html
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.
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. :) ua-cam.com/video/e0kMjb686tc/v-deo.html Guess I need to make a new version of it. :)
API or Flow? I'll get this working! 👌
👍 You got this. 😎
Hi Shane great video!! quick question .how do you transparent the attachment control?
You have to go to the different properties, like color, fill, border color, etc and change them to Color. Transparent.
@@ShanesCows i use phone app to attach the video but only attach photo. No option for video. Any Idea? Thanks.
Hi Shane, 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, what if the file needs indexing as well? Can this be done in Power Apps? (I'm using SharePoint term store for files indexing)
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!
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
ua-cam.com/video/vGSNrj82JcI/v-deo.html
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
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 ua-cam.com/video/2gE0e_AsdMw/v-deo.html you will have to combine the two concepts. :)
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 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
ua-cam.com/video/7UeRzfPo8RE/v-deo.html
Hi Shane, is it possible to upload an image/pdf to a power app that then is stored as part of a sharepoint list row entry as an attachment?
Thank you 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 🤩 ua-cam.com/video/AHWvG2C9vQo/v-deo.html
@@ShanesCows I'm flippin crying with joy over here!!! 😭😭😭😭😭 THANK YOU!!!
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.
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.
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 ??
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! 🤩
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 ua-cam.com/video/vpjf5mD-COs/v-deo.html
This video talks about multi-upload ua-cam.com/video/7UeRzfPo8RE/v-deo.html though with DV it will be different but should get you started.
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, 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.
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 ua-cam.com/video/7UeRzfPo8RE/v-deo.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, 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 ua-cam.com/video/2gE0e_AsdMw/v-deo.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.
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.
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.
your formula is missing a column content Bytes with a type of Blob, how to resolve
Check your formula structure again. You have a typo or small piece missing. THe formula I use works. 😎
Any tips for doing this from a Mobile App and not Web (desktop)? I've got a use case to load a 10-20 second video from a Mobile Device (iphone), but when I select the control on an iPhone I only see options for photos - no videos. Anyone ever seen a workaround?
I have heard other's report this but I have never looked into it, sorry. Not sure why uploading videos is different on phone :(
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
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. :)
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?
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
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.
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.
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
I can't seem to avoid being stuck on error: Missing column. Your formula is missing a column 'contentBytes' with a typo of 'Blob'. Same code and steps as you and tried several other but still no luck. Help please!
This worked:
MyFlow.Run(
{
contentBytes: Last(Self.Attachments).Value,
name: Last(Self.Attachments).Name
}
)
Did you figure it out? Maybe paste your code here and I can try to give you any guesses I might have. What is here should work
@@ShanesCows Yes! In my particular case (doing same steps as you did) the code that works is:
MyFlow.Run(
{
contentBytes: Last(Self.Attachments).Value,
name: Last(Self.Attachments).Name
}
)
Thank you so much. Yo are my favourite source of Power Platform content!
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 :(
I get this error" Run is an unknown or unsupported function in namespace 'VideoUpload" When I add this function as instructed in the video: VideoUpload.Run({file:{contentBytes:Last(Self.Attachments).Value, name:Last(Self.Attachments).Name}})
Me too, any solution?
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
Hi Shane this video is suberb could you please tell how to add the the text Column along with the Attachment
THis older video explains the concept. 😎 ua-cam.com/video/e0kMjb686tc/v-deo.html
HI Shane, how to delete an attached excel file after uploading it?
In flow there is a Delete file action that you could use.
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?
Sorry now sorted - you need to remove the {file: part and extra }
Glad you got it workign!
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…
can you post about selection a charcter then if pressed it will glow? thank you
Sorry, I don't understand the question.
@@ShanesCows oh sorry, i mean if image is pressed there a glowing green(any color) on border thanks
This is much easier. However! How do we add the metadata?
This video shows doing it with the v1 trigger. ua-cam.com/video/e0kMjb686tc/v-deo.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. :)
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?
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?
Have you tried going to SharePoint in the browser and uploading a file directly there. I think it is a SharePoint permissions issue.
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".
What about if they x out the file? Will it not upload to the SharePoint library?
If you put the upload logic OneAddFile then it goes as soon as they attach it.
@@ShanesCows how can you remove it from the list of they remove it from the upload? Like they attach the wrong file and don't want it in the list?
Can I use a Camera control to add attachments this way?
Yes, the only difference is camera doesn’t have a file name so you will need to create one.
@@ShanesCows lol this is so much easier than before! Thank you, Sir.
what do you do to seperate canvas apps IE DEV UAT PROD? do you use a seperate sandbox dataverse?
Use environments. Each environment uses separate Dataverse. Each canvas app instance is located per environment.
@user-sr6vx6tz8y but when you deploy the app do you just export and import. thats what i was testing untill i realized it doubled the space and was over database capacity
@@dylsk8r If you setup a Dev environment it doesn't count towards your capacity. You can import and export and it will work fine. I personally use Azure Devops Pipelines to handle it all automatically. Power Platform also has 'Managed Environments' to handle this, but I believe they will end up costing you more once the feature goes to GA.
@@brendanerofeev Not sandbox but development? Trying now.
I am not able to see dynamic content in power automate, i am getting this error for a long time now. when i am searching the solution for the error its saying that i need to use input variable to solve this error can you please help me with this solution
Sorry, I am not sure why that is happening to you. I have never seen Dynamic content not show up.
@@ShanesCows is there any different method that i can use to avoid power automate?.. i want to do the exact same thing that you have done in the video
PROBLEM: I'm limited to 10MB file. Did i do something wrong or is that the limit? Most videos are going to be a more than 10MB i imagine.
There is a max file size property for the attachment control. The biggest I have got to work is 50 mb but I think it will go to 100. Videos probably not going to work.
wow, i didnt think i'd get a reply, and especially so quickly. Feel like im talking to a celebrity. thank you for all your videos@@ShanesCows . Ill try to play with max file size.
@@ShanesCows im sorry to be a pest. Please just point me in another direction if this isnt a simple answer. The problem i ran into was with sharepoint @2:22 of the video. I dont have the ability to add an attachment column. I went into the Sharepoint column settings as other sites directed but Attachments is not an option. I THINK its because im not actually working in a list but rather a folder? If i cant add an attachment, should I start looking into just adding a file directly into a folder?
@@NeilJavier-zu9dn Add a sharepoint list, not library, adn then steal the attachment control from it.
how about using the new import button ?
What new import button?
The import button in the tools,
It doesn’t work. The function.run() has syntax errors, helppp