Holy heck I can’t upvote this enough, I was running around watching complex videos on this all day and still kept having issues all while making my flow complex, adding more controls to my powerapp and hurting my brain. This is so much simpler than every other method I’ve seen and it makes perfect sense, thank you so much!!!
Great video Chino! Would love to see the follow-up video on creating links based on the file ParentID or a video on how to send an email with the files based on the ParentID in powerautomate.
Good job. I had been doing it the "old" way with the JSON entries, etc... This is much simpler, thanks for spotting this method with the v2 trigger. Cheers
Works perfectly!!! My follow up question would be how would you add attachments to an existing project and link them together? Say a week later you want completed action pics... Thanks.
Hi Chino, Thanks for sharing the flow. I was able to use it as an outline. I had two dropdowns (Fields 1 and 2) in my app I was trying to use as meta-data. Was able to simplify the button formula: No need for me to create a variable. This might help some other users. ForAll(AttachmentsDataCardValue#.Attachments, FlowName.Run( Field1.SelectedText.Value, Field2.SelectedText.Value, {file: { contentBytes: Value, name: Name }} ))
Many ways to do things... When I put these videos together I always try to simplify the approach to make it as easy as it can be for people. My hope is that my demonstration will then give people ideas on how to solve their issues
Hey Chino, this works great. I was playing around with this and made a slight change and filtered my gallery using a unique text field instead and oops, delegation error. I thought filtering a text column in a document folder would be delegable like a SP list but apparently not. Thankfully going back to the numerical ID works fine.
Honestly I've been fighting attachments in an app for a week... I hadn't spotted v2! I have a need to save files to multiple list items but didn't want to duplicate the data to each record... This will save a lot of automate work! Thanks!
If getting users to read a document is important, you could always save the action of them reading it to a log / SharePoint list, in that way they are accountable for it. You can do this by triggering on the select property within the gallery field
@@ChinoDoesStuffthat's a great idea, my company is very strict on data gathering though and it wouldn't be worth the admin. There are so many things you can gather in power apps, time on page, what was clicked... All of which I haven't gone near as I'll turn a fun app project into a administrative nightmare!
I'm relatively new to Power App development and this worked like a charm on my first app. THANK YOU A bunch and looking forward to learning more from you. :)
I have been searching for videos like this for a looooong while now and finally you came up with this solution which is absolutely clear to do, Thanks for that I started following you because the way your videos are structured and very easy to understand. I have a question though .. I have a screen with a gallery with a filter on the name of a person, next another gallery with a collection of the data from the people chosen in the previous gallery, and finally and attachment control where all the items should have the same attachment for every single record selected, is it possible to save this attachment in the sharepoint for of each record, I know it's going to be the same attachement for all but that's why I've been struggling with for a little while and I cannot find a solution? I'd really appreciate your support. Thanks in advance!
Thank you, great video. Works well! Did you ever make a follow up video on how to look up and display/view the attachments within Power Apps? I cannot see one on your channel and am struggling to lookup between the list and library to get the relevant attachments.
Hey Gita...I'm glad you liked it.. I try and only do videos on concepts that I get really excited over.. fortunately, I've recently had another great idea for a video so that will be coming up soon..
Thanks a lot. Works like a charm, when I use it with a local attachment, as you described. Unfortunately, when I try it with a Power Apps collection of previously taken photos, it doesn't work at all, giving me an error. Any idea on how to make photo uploading work?
Good stuff Chino. Can you also explain. If for same parent ID, how can we override files ? Eg: You uploaded 4 files, I can visit this form with ParentID 12 again and remove 2 files and save it. How to acccomplish that.
@@ChinoDoesStuff Chino EXCELLENT video, timely and helpful. Followed everything and got it working but still experience same problem mentioned that any additional file posted will overwrite everything in the DOC library. Concatenating the ParentID+FileName would be fine but I've been trying for days and can't get the contatenation working. Eager for your video-3 on fully managing Attachments using this approach.
Hey Dave..... The concatenation should be happening on the Create File action in your Power Automate. On the File Name property use the Fx function - concat(triggerBody()['number'],'_',triggerBody()['file']['name']) It may be a little different for your app but essentially this is all that is needed.
Hi Chino , Thanks for you super awesome solution. But is there any way to save the attachment to the attachment column to the same list where we are saving our complete record ?
Hey Dax... good question..Not sure that if you limit it to only one file you no longer require the ForAll() function. I'll do some testing and let you know..
Hola! al parecer en la nueva versión ha cambiado la forma de declarar la propiedad file, ya no permite agregar los corchetes. Sabes como debo hacerlo para declarar correctamente mi función? ForAll( AdjuntosTona.Attachments; SaveFileToSharepointTona.Run("file";recID) );; En donde se encuentra "file" no permite agregar lo que compartiste en tu video, sabes que puedo hacer?
Add a form with only the attachement control inside of it. Before patching the rest of your data, submit the form, grab the ID from the created form and use that to patch the rest to. I can't see doing anything else. Am I missing some advantages from doing it the way you describe?
Tons... for one, Document libraries and the files they contain can be managed and maintained independently. Governance is way way easier storing files in doc libraries than it is when files are 'baked' into each record..
Good video tuts Chino. I followed your tutorial and it works. The only problem that I am encountering is that I can only upload a file that is small in size 500kb or less. If it is more, I am getting a "Network Error" error. Have you encountered this same error before?
Hello Does thanks for the video. how would you have to do it, if for example you don't add the attachments in Issue Attachments like you did, but add the attachments in the Issues list of existing entries?
I do exactly your steps... but when I reach to the point from 18:50 where we type the .Run it is different for me and I get errors: For you, you have in 18:56 Run(number, {file:Record}) I have Run(file, number) --> Error: "Expecting a Record value instead" Then, in the contentBytes and name, another error in both of them "Invalid argument type (Record): Expecting a Number value instead" Do you know what's wrong? :(
Are you getting the same error? My suggestion would be that if this is your first time attempting this then get the example working first and follow the video precisely before you attempt to apply it to your own project. Good luck! Let me know how you go :)
Hi Chino, thanks for this video, this is really helpful. How do you get the right syntaxis for the Patch function? I need it for a Sharepoint list with a couple of dozens of columns, instead of a Doc Library like in your example...
Hey Bubba...most of my videos feature the Patch command in some way.. here's a link to a video I did a few years ago that shows you how to use patch to save to a SharePoint list. Hopefully you will find it helpful ua-cam.com/video/dTUuP9rL7_I/v-deo.html
Is there a way to make a column with name as attachID and have it values as Attach1, Attach2..... unique value for each attachment in that attachment form control. Please reply.
How do you get over the issue of files being uploaded with the same filename as a file already uploaded, at the moment the new uploaded file overwrites the old file and also replaces the ID with the uploaded file ID
Hey TBB...check the comments as I've been asked this before but essentially I added a step in the Power Automate workflow to append the id followed by a underscore to the beginning of the file. This will ensure the filename is always unique.
My biggest problem is when I use download instead of launch in a gallery or by a link, one browser may download the file and another may launch it directly. When it opens it directly, it can allow the see the actual file location, which I don’t want them to see or it allows them to modify the original. I want them to download the file and if they modify it, the upload it as a new attachment. My organization uses Edge and Chrome. Both browsers don’t always respect when I use download instead of open. Do you have any ideas on that one❓ The only way I can get it to work is to have the attachment control which filters out which attachment it is and then when they click on it, it will only download and doesn’t show the actual file location.
Can we do like - when I upload the file name called "test attachment", after uploading I want space to be removed in the file name and hitting on submit form, the file name "testattachment" Should be stored in SharePoint.
Hi My use case is to upload single pdf files in two separate input Fields in Power apps (Field 1: Sample File and Field 2: Sample_1 File). For this I have written following expression "'PowerAppV2->Compose'.Run('Sample Text'.Text,{file:First(Sample.Attachments),file_1:First(Sample_1.Attachments)}". However Run Button of Power Apps is showing error "Invalid number of Argument- Received 3 expected 1-2.Pls help me how to overcome this issue. I even posted in Power apps community but nobody is able to solve this problem.
Yep..there's been plenty of comments and follow ups about that... Just make sure you tack on something to the filename that makes it unique...time date stamp or perhaps the record id
It is possible and I do have older videos showing how to do this but, as the video name suggests, in my opinion the better way is to use a doc library and link the files to your record via the ID field of the list record.
Thanks a lot Chino. This video was a lifesaver and I could implement a similar app. But I'm facing a problem with this solution that you may be able to help with. When I upload the same file (for a different issue ID), Power automate uses the file that already exists in the library and updates its IssueID with the new Issue. Power automate does not create a new record Then the old issue loses its reference to the attachment. What would you advise for solving this problem? Many Thanks Eduardo
Hey Ed... One way to stop this from happening is to modify your Power Automate flow so that it concatenates the record ID to the beginning of the filename, that should keep the file extension intact but will mean every file saved to the library will have a unique name.
@@ChinoDoesStuff Thanks for the advice, I changed the .run in the Powerapps to " name: rec.ID&Text(Now(),"mmss")&Name", this renamed my files to ID, Minute and seconds prior the name. Therefore if a user attaches 5 files with the same name at the same time they will save with different names.
If upload attachment with same name it overwrites attachment thta it finds. I have no idea why. How to solve this? like a create file action generates same itemid if attachment with that name exists
Yes.. I have already responded to similar comments... Make a small change to your power automate wf.. add a unique identifier to the filename when saving to SharePoint. I normally use the record Id as I know it will always be unique
Hi Johannes, I have a gallery in my PowerApps to view the files, I than have a button that sends the information("File name with extension") to Powerapps(V2).In your flow you only require Powerapps(V2), Get file content using path and send an email(V2)
Hi Chino, nice tutorial. But what if I want to have multiple attachment fields instead of one? My project required 1 attachment field per file, how can we upload all of the files from each field in 1 click? We have to do ForAll() to all of the field?
Please help me on this, I am trying like below i am getting this error error: 'Missing column. Your formula is missing a column 'contentBytes' with a type of 'Blob'.' code: {file: { contentBytes: First(attachmentDC.Attachments).Value, name: First(attachmentDC.Attachments).Name }}
Thanks for the video. Let's say your user then wants to open the record and add another attachment (or remove attachments). Can you display these attachments in the attachment control on edit??
Mmmmm.. definitely an indicator that you are doing something different from what I demonstrate in the video. Perhaps attempt it first with a new blank app and try and follow the video until completion. Let me know how you get on.
Not really... Would really need to know more about your implementation. My suggestion is to try and get exactly what I demonstrate in the video working first.
I was so excited when I found this video and its elegant way to save attachments BUT, when I got to the bit about the ‘set’ and ‘patch’ functions for the save button, it all went very wrong. No matter what I did to the functions PowerApps didn’t like it - so back to the drawing board for me.
It definitely works so I strongly recommend you persist with it.. maybe try a really simple example first and follow the video as closely as you can before trying to use this in your own solution..
@@ChinoDoesStuff Thanks for replying, I have no doubt at all that it works - I just don’t know anything about ‘patch’, so with that massive knowledge gap, I’ll never make it work.
Hi Chino-Thanks so much for posting it . I am new to power app and trying to create a simple apps.. something just like in your video , only difference , I used a drop down too and Marked it as Selected Text in the patch function.... I followed the exact steps but I get an error in the Patch function "The patch function has some invalid Arguments" . Any thoughts on why I get this error? Thanks!
Good day Chino! I have a question, where did the "Issues" date come from from the Patch function? It is the name of the list that we are working on? Thanks a lot for the video!
I actually got that straight, now I have an error in my code in the function part: ForAll(DataCardValue15.Attachments, SaveFilesonSharepointFolder.Run { file: { contentBytes: Value name: Name } } ) Says it has an invalid number of arguments, it says it has 2, and the code expects 3-4. What can I do? My flows has 4 inputs, and your has 2 i don't know if this is the source of the problem.
Hello! On my form OnSelect it's currently SubmitForm(EditForm2) How do I make it so that when I'm pressing that button it also uploads the attachments to the document library? I followed your video but the OnSelect code is different so when I add in what you have it just makes an error :( Can't seem to find any answers online for this issue either.
Hey thanks so much for this. I've followed your steps but i've had an error in Power Automate. I've also got my patch slightly different to yours. instead of it being RecID its a varRecord - is this is the reason why the 'Create_File' action in automate failed? Can you help? I'm an absolute noob with Powerapps so sorry in advance if its something really silly .
Hey Abu..thank you so much for your comments. Because you are new to power apps, my suggestion would be to try and follow the video, precisely, step by step to get it working before you try and apply it to your own project. That way you will get the theory right good luck.
Hii i tried this but i found a issue if i am uploading same file name in different I'd that time it is overlapping the earlier I'd is replaced with new I'd and i am losing the data can someone help me with this to overcome this i added parentid-filename but when I did that if i want to see that record id-filename is coming i don't want id when I am displaying in gallery data I just want file name can someone help me in this
@@ChinoDoesStuff I have many users adding attachments to forms. They don’t know what characters are not permitted and there’s no notification that they have done anything wrong. They do no have access to the “empty” Sharepoint folder where the file is supposed to be stored.
Do you mean using the attachments field in a list item to save files for each record? If so, check my previous video on file attachments but I recommend using the updated method in this video
Depends... Are you attaching one file to one email or multiple files to a single email? There's actually quite a few different ways you could achieve each.. my first thoughts are that you probably wouldn't need an array .
For sure! That's exactly what I demonstrate in this video with the 'RecID' that I pass to the flow from Power Apps. Use this same method to set any meta data on the file that you wish :)
@@ChinoDoesStuff Brilliant! I guess my confusion is the linkage between SPO list and library. In my case it were better to simply have everything in a doclib without using the associated list, should you wish to illustrate that in a future video. :) If I get the first part working I intend to augment by printing screen of the finished form to pdf file and then attach that to the lib to accompany the forms metadata.
. I figured it out. I was operating under the assumption that you had created the text inputs by inserting a form tied to the data source and populated with fields from the source. Turns out you simply used text boxes and labels. After that observation and changing all my data cards for simple text inputs, the clouds dispersed, the scales fell from my eyes and all started working as yours did in your tutorial! Words cannot express my gratitude to you for supplying this tutorial to the community!
Thank you! Very good solution, simple and elegant.
That's a huge honour coming from you Elon! ... Oh wait.. wrong Elon :) Still a big honour.. thank for watching and commenting.
Holy heck I can’t upvote this enough, I was running around watching complex videos on this all day and still kept having issues all while making my flow complex, adding more controls to my powerapp and hurting my brain. This is so much simpler than every other method I’ve seen and it makes perfect sense, thank you so much!!!
Feel free to keep upvoting and just upvote all of my videos to show your appreciation ;) Glad it helped.
fully echo this statement and sentiment
Chino has done something that most of the Channels couldn't do!!!!! Simply the best!!! Simple does it
Thanks Java.. Its comments like yours that encourage me to keep going with the channel.
Awesome solution for a problem I struggle to solve since a weak! Thank you Chino!
Great video Chino! Would love to see the follow-up video on creating links based on the file ParentID or a video on how to send an email with the files based on the ParentID in powerautomate.
Glad you liked the video... Here is part 2 that covers some of those topics ua-cam.com/video/oFa96qlDoLE/v-deo.html
Good job. I had been doing it the "old" way with the JSON entries, etc... This is much simpler, thanks for spotting this method with the v2 trigger. Cheers
one of the easiest way to upload multiplt file from powerapps Thanks a lot
Works perfectly!!! My follow up question would be how would you add attachments to an existing project and link them together? Say a week later you want completed action pics... Thanks.
Hi Chino, Thanks for sharing the flow. I was able to use it as an outline. I had two dropdowns (Fields 1 and 2) in my app I was trying to use as meta-data. Was able to simplify the button formula: No need for me to create a variable. This might help some other users.
ForAll(AttachmentsDataCardValue#.Attachments,
FlowName.Run(
Field1.SelectedText.Value,
Field2.SelectedText.Value,
{file: { contentBytes: Value, name: Name }} ))
Many ways to do things... When I put these videos together I always try to simplify the approach to make it as easy as it can be for people. My hope is that my demonstration will then give people ideas on how to solve their issues
Hey Chino, this works great. I was playing around with this and made a slight change and filtered my gallery using a unique text field instead and oops, delegation error. I thought filtering a text column in a document folder would be delegable like a SP list but apparently not. Thankfully going back to the numerical ID works fine.
Honestly I've been fighting attachments in an app for a week... I hadn't spotted v2!
I have a need to save files to multiple list items but didn't want to duplicate the data to each record... This will save a lot of automate work!
Thanks!
It's so much easier and technically superior using this method
Check part 2 out for more file attachment goodness! ua-cam.com/video/oFa96qlDoLE/v-deo.html
@@ChinoDoesStuff thanks for highlighting to me, getting people to just read the attachment without downloading is worth the watch alone!
If getting users to read a document is important, you could always save the action of them reading it to a log / SharePoint list, in that way they are accountable for it. You can do this by triggering on the select property within the gallery field
@@ChinoDoesStuffthat's a great idea, my company is very strict on data gathering though and it wouldn't be worth the admin. There are so many things you can gather in power apps, time on page, what was clicked... All of which I haven't gone near as I'll turn a fun app project into a administrative nightmare!
Excellent, you provided a solution to something I was trying to figure out for a couple days without using the power automate button.
Not a problem.. Glad it helped
Great video - exactly what I have been trying to do for a couple of days. Perfect solution.
Chino, Yes! A follow up video would be great. I will give it a go but would love to see your solution. Currently I am thinking cascading galleries.
Not sure about cascading galleries :)
@@ChinoDoesStuff That’s just proof that I need a follow-up video :-). I was thinking nested gallery when I said that.
Yes..I figured you were talking about nested galleries..galleries within galleries..there's a much easier way :) stay tuned...
Hi Chino. Thank you so much for doing this. It was just what I was looking for.
Please do the follow up video.
Its done.. Hope you watched it.. Liked it... and commented on it :)
Thanks for the video. Using it I finally worked out how to upload an attachment and send it in an email.
I'm relatively new to Power App development and this worked like a charm on my first app. THANK YOU A bunch and looking forward to learning more from you. :)
Awesome video. It may take me another 2 or 3 views to fully implement, but great work!
I have been searching for videos like this for a looooong while now and finally you came up with this solution which is absolutely clear to do, Thanks for that I started following you because the way your videos are structured and very easy to understand. I have a question though .. I have a screen with a gallery with a filter on the name of a person, next another gallery with a collection of the data from the people chosen in the previous gallery, and finally and attachment control where all the items should have the same attachment for every single record selected, is it possible to save this attachment in the sharepoint for of each record, I know it's going to be the same attachement for all but that's why I've been struggling with for a little while and I cannot find a solution? I'd really appreciate your support. Thanks in advance!
Thanks a lot for a very simple explanation and straight forward process.
Glad it was helpful
Chino, you are a lifesaver. Thank you so much !!!
Thank you Chino, excellent video. I did not know about the Patch statement and Set command. Superb stuff and really useful.
Yep.. super useful... glad its helped you out.
Pleeease Chino do us the video! ehehe I think i can do that, but your solutions are always very nice! Nice video anyway
Thanks Jo...
Excellent, Chino. Do another video.
Here you go... ua-cam.com/video/oFa96qlDoLE/v-deo.html
This was a great new way to accomplish uploading.
Thank you for uploading this .. just what I needed
Excellent Video and made it so easy. Can not thank you enough for this.
You're very welcome B.. make sure you watch part 2 of this video for more tips on file attachments
Thanks SO MUCH!!! It worked the first TIME!!!
You're welcome!
Thank you, great video. Works well! Did you ever make a follow up video on how to look up and display/view the attachments within Power Apps? I cannot see one on your channel and am struggling to lookup between the list and library to get the relevant attachments.
ua-cam.com/video/oFa96qlDoLE/v-deo.html
Great video. I wish you would create stuff like this more often!!
Hey Gita...I'm glad you liked it.. I try and only do videos on concepts that I get really excited over.. fortunately, I've recently had another great idea for a video so that will be coming up soon..
Hey!!! I posted two video in the last two weeks so I hope you are enjoying the frequent videos! :)
Hey Chino, 1000 thanks for this Sharing !
10,000x thankyou for liking and commenting!
Really Nice. Make it look so easy.
In your flow, For file name, you can type: triggerBody()['file']['name']. It will give you the attachment name.
Thanks that was useful - just used it for my proof of concepts - appreciate it!
Not a problem victor..
You are a champion my friend!
Thankyou! I am glad the video helped.
Hi Chino, can you show how to take an image file that was just uploaded in power apps the include that image in a pdf?
Very interesting way to do that !!!! Tks a lot !
Cheers!
Thanks a lot. Works like a charm, when I use it with a local attachment, as you described.
Unfortunately, when I try it with a Power Apps collection of previously taken photos, it doesn't work at all, giving me an error. Any idea on how to make photo uploading work?
Excellent content
Thanks so much Ves...
thanks you for this video, works perfect! Do you also have a video to add these files in a flow to email them as attachments based on the ParentID?
Bro, you really a saviour, thanks a lot.
Absolutely any time my PA brother
Was there ever a follow up video on the last topic you mentioned at the end of the video?
Thank you sir. Good stuff
You are very welcome
Great tutorial
Good stuff Chino. Can you also explain. If for same parent ID, how can we override files ? Eg: You uploaded 4 files, I can visit this form with ParentID 12 again and remove 2 files and save it. How to acccomplish that.
I think I am going to do a follow up video on file attachments so I will be sure to cover removing/deleting files in the video
Waiting eagerly for the follow up video. On working with these attachments in edit mode. Any ideas?
:) I'll see if I can get something out in the following week..
@@ChinoDoesStuff Chino EXCELLENT video, timely and helpful. Followed everything and got it working but still experience same problem mentioned that any additional file posted will overwrite everything in the DOC library. Concatenating the ParentID+FileName would be fine but I've been trying for days and can't get the contatenation working. Eager for your video-3 on fully managing Attachments using this approach.
Hey Dave..... The concatenation should be happening on the Create File action in your Power Automate. On the File Name property use the Fx function - concat(triggerBody()['number'],'_',triggerBody()['file']['name'])
It may be a little different for your app but essentially this is all that is needed.
DUDE!!! THANK YOU SO MUCH!!!
Anytime Simm... Glad I could help..
Thanks a lot
Most welcome
Hi Chino , Thanks for you super awesome solution. But is there any way to save the attachment to the attachment column to the same list where we are saving our complete record ?
Yes there is but a different technique is required and the process is slightly more clunky to implement.
Is there a way to send the attached files that are in a sharepoint, all together in one email?
Yes.. :)
@@ChinoDoesStuff how do i do it?
Thank you very much for the video!
Do you have any idea of how can I upload photos to the sharepoint using this flow?
This method will work for all types of files, including photos.
Hello Chino, just wondering if only single file, would the formula much more simplier?
Hey Dax... good question..Not sure that if you limit it to only one file you no longer require the ForAll() function. I'll do some testing and let you know..
Great Vídeo Chino,
There's a video where you put theses files in folder separated by each ID's?
I think I am going to do a follow up video on file attachments so I will be sure to include folders in what I cover.
Hi @chino my document library won’t allow me add pass 7docs. Do you have a solution for this. By the way your code works really well thanks.
Not sure.. Could be a policy that your system admin has set. Did you end up solving this issue?
Hola! al parecer en la nueva versión ha cambiado la forma de declarar la propiedad file, ya no permite agregar los corchetes. Sabes como debo hacerlo para declarar correctamente mi función?
ForAll(
AdjuntosTona.Attachments;
SaveFileToSharepointTona.Run("file";recID)
);;
En donde se encuentra "file" no permite agregar lo que compartiste en tu video, sabes que puedo hacer?
What is the formula to program a button in power app . That the function will be to attatch a document
Add a form with only the attachement control inside of it. Before patching the rest of your data, submit the form, grab the ID from the created form and use that to patch the rest to. I can't see doing anything else. Am I missing some advantages from doing it the way you describe?
Tons... for one, Document libraries and the files they contain can be managed and maintained independently. Governance is way way easier storing files in doc libraries than it is when files are 'baked' into each record..
Good video tuts Chino. I followed your tutorial and it works. The only problem that I am encountering is that I can only upload a file that is small in size 500kb or less. If it is more, I am getting a "Network Error" error. Have you encountered this same error before?
thank you🤟🥰
Hello Does
thanks for the video.
how would you have to do it, if for example you don't add the attachments in Issue Attachments like you did, but add the attachments in the Issues list of existing entries?
I do exactly your steps... but when I reach to the point from 18:50 where we type the .Run it is different for me and I get errors:
For you, you have in 18:56 Run(number, {file:Record})
I have Run(file, number) --> Error: "Expecting a Record value instead"
Then, in the contentBytes and name, another error in both of them "Invalid argument type (Record): Expecting a Number value instead"
Do you know what's wrong? :(
Did you fix it ?
Are you getting the same error? My suggestion would be that if this is your first time attempting this then get the example working first and follow the video precisely before you attempt to apply it to your own project. Good luck! Let me know how you go :)
@@mynameis211yes, but I followed a different approach. I did the one I found in Matthew Devaney’s blog
@@ChinoDoesStuffthank you for replying. I found the solution in Matthew Devaney’s blog
Trying to do this with regular submit form .Seams the submit doesn't return the ID fast enough to pass to power automate.
Thanks a lot, it worked for me and keep uploading nice videos...😇
Hi Chino, thanks for this video, this is really helpful. How do you get the right syntaxis for the Patch function? I need it for a Sharepoint list with a couple of dozens of columns, instead of a Doc Library like in your example...
Hey Bubba...most of my videos feature the Patch command in some way.. here's a link to a video I did a few years ago that shows you how to use patch to save to a SharePoint list. Hopefully you will find it helpful ua-cam.com/video/dTUuP9rL7_I/v-deo.html
Is there a way to make a column with name as attachID and have it values as Attach1, Attach2..... unique value for each attachment in that attachment form control. Please reply.
When I remove the pdf in power apps it is still in the library. How should I control this?
hello Chino, Im new in sharepoint. just ask if how to create that "Issue Attachment" for file. thanks
Great video! Everything works except my new submissions are overwriting the previous submission. Any thoughts on the root of this issue?
Sounds like you are saving your file with same file name every time. Check how you are selecting the file name and work from there..
How do you get over the issue of files being uploaded with the same filename as a file already uploaded, at the moment the new uploaded file overwrites the old file and also replaces the ID with the uploaded file ID
Hey TBB...check the comments as I've been asked this before but essentially I added a step in the Power Automate workflow to append the id followed by a underscore to the beginning of the file. This will ensure the filename is always unique.
My biggest problem is when I use download instead of launch in a gallery or by a link, one browser may download the file and another may launch it directly. When it opens it directly, it can allow the see the actual file location, which I don’t want them to see or it allows them to modify the original. I want them to download the file and if they modify it, the upload it as a new attachment.
My organization uses Edge and Chrome. Both browsers don’t always respect when I use download instead of open. Do you have any ideas on that one❓ The only way I can get it to work is to have the attachment control which filters out which attachment it is and then when they click on it, it will only download and doesn’t show the actual file location.
Can we do like - when I upload the file name called "test attachment", after uploading I want space to be removed in the file name and hitting on submit form, the file name "testattachment" Should be stored in SharePoint.
Yep..make the change in the power automate wf
Hi My use case is to upload single pdf files in two separate input Fields in Power apps (Field 1: Sample File and Field 2: Sample_1 File). For this I have written following expression "'PowerAppV2->Compose'.Run('Sample Text'.Text,{file:First(Sample.Attachments),file_1:First(Sample_1.Attachments)}". However Run Button of Power Apps is showing error "Invalid number of Argument- Received 3 expected 1-2.Pls help me how to overcome this issue. I even posted in Power apps community but nobody is able to solve this problem.
what happens if you upload a file with the same name? sharepoint doesnt take, nor does it tell you the upload was unsuccessful?
Yep..there's been plenty of comments and follow ups about that... Just make sure you tack on something to the filename that makes it unique...time date stamp or perhaps the record id
Good stuff! Now, instead of saving to a doc library, i want to save the file to the sharepoint item that is being created. Is that possible?
It is possible and I do have older videos showing how to do this but, as the video name suggests, in my opinion the better way is to use a doc library and link the files to your record via the ID field of the list record.
Thanks a lot Chino. This video was a lifesaver and I could implement a similar app.
But I'm facing a problem with this solution that you may be able to help with.
When I upload the same file (for a different issue ID), Power automate uses the file that already exists in the library and updates its IssueID with the new Issue. Power automate does not create a new record
Then the old issue loses its reference to the attachment.
What would you advise for solving this problem?
Many Thanks
Eduardo
Hey Ed... One way to stop this from happening is to modify your Power Automate flow so that it concatenates the record ID to the beginning of the filename, that should keep the file extension intact but will mean every file saved to the library will have a unique name.
@@ChinoDoesStuff Thanks for the advice, I changed the .run in the Powerapps to " name: rec.ID&Text(Now(),"mmss")&Name", this renamed my files to ID, Minute and seconds prior the name. Therefore if a user attaches 5 files with the same name at the same time they will save with different names.
Hi Chino - When I try and create a new form, the attachment does not come up in my form. How do I get that to show up?
Hey BB..make sure you connect the form to a SharePoint list that has file attachments enabled
If upload attachment with same name it overwrites attachment thta it finds. I have no idea why. How to solve this? like a create file action generates same itemid if attachment with that name exists
Yes.. I have already responded to similar comments... Make a small change to your power automate wf.. add a unique identifier to the filename when saving to SharePoint. I normally use the record Id as I know it will always be unique
Hi, Can you please tell me the data type of column "Name" in which you saving files, and files can be open right?
Sorry..not sure if I understand your question.
Hi Chino, great video...
Is there a way the i can pull these attachements (PDF) from the document lib back into powerapps and send it in a email
Hi Johannes, I have a gallery in my PowerApps to view the files, I than have a button that sends the information("File name with extension") to Powerapps(V2).In your flow you only require Powerapps(V2), Get file content using path and send an email(V2)
Great, Thx
Hi Chino, nice tutorial.
But what if I want to have multiple attachment fields instead of one?
My project required 1 attachment field per file, how can we upload all of the files from each field in 1 click? We have to do ForAll() to all of the field?
If it's multiple attachment controls just use multiple calls to the workflow separated by ;
Please help me on this,
I am trying like below i am getting this error
error: 'Missing column. Your formula is missing a column 'contentBytes' with a type of 'Blob'.'
code:
{file: { contentBytes: First(attachmentDC.Attachments).Value,
name: First(attachmentDC.Attachments).Name
}}
Please make sure you follow all instructions given within the video precisely
Hi, is this really correct? I don't believe PowerApps will wait for your flow unless you tell PowerApps to receive a variable back from them flow?
It actually is.. Test it for yourself! :)
Thanks for the video. Let's say your user then wants to open the record and add another attachment (or remove attachments). Can you display these attachments in the attachment control on edit??
Use a gallery to display and for edit
Hi Chino I followed your instructions but I am getting the red scriggly lines of death in my powerapp. Can you help ?
Mmmmm.. definitely an indicator that you are doing something different from what I demonstrate in the video. Perhaps attempt it first with a new blank app and try and follow the video until completion. Let me know how you get on.
Hi thanks for this video can we zip the attachment and save
Hi there it is giving me two errors... contentBytes should be Blob but is "Error" and Name isn;t recognized... any ideas?
Not really... Would really need to know more about your implementation. My suggestion is to try and get exactly what I demonstrate in the video working first.
Did u find a solution
15:18 i somehow do not have the action button any idea where is it Chino?
No idea. Sorry. :)
I was so excited when I found this video and its elegant way to save attachments BUT, when I got to the bit about the ‘set’ and ‘patch’ functions for the save button, it all went very wrong. No matter what I did to the functions PowerApps didn’t like it - so back to the drawing board for me.
It definitely works so I strongly recommend you persist with it.. maybe try a really simple example first and follow the video as closely as you can before trying to use this in your own solution..
@@ChinoDoesStuff Thanks for replying, I have no doubt at all that it works - I just don’t know anything about ‘patch’, so with that massive knowledge gap, I’ll never make it work.
Take a look at some of my other videos...I pretty much use Patch() for every app I demo
Hi Chino-Thanks so much for posting it . I am new to power app and trying to create a simple apps.. something just like in your video , only difference , I used a drop down too and Marked it as Selected Text in the patch function.... I followed the exact steps but I get an error in the Patch function "The patch function has some invalid Arguments" . Any thoughts on why I get this error? Thanks!
Honestly, could be a number of things but take a look at your patch function first.
Good day Chino! I have a question, where did the "Issues" date come from from the Patch function? It is the name of the list that we are working on?
Thanks a lot for the video!
I actually got that straight, now I have an error in my code in the function part:
ForAll(DataCardValue15.Attachments,
SaveFilesonSharepointFolder.Run
{
file: {
contentBytes: Value
name: Name
}
}
)
Says it has an invalid number of arguments, it says it has 2, and the code expects 3-4. What can I do? My flows has 4 inputs, and your has 2 i don't know if this is the source of the problem.
Hey Leandro...perhaps first try and build an app following my example. Once you have that working then adapt it to what you are trying to achieve.
Hello! On my form OnSelect it's currently SubmitForm(EditForm2) How do I make it so that when I'm pressing that button it also uploads the attachments to the document library? I followed your video but the OnSelect code is different so when I add in what you have it just makes an error :(
Can't seem to find any answers online for this issue either.
Make sure you add a semi colon ; after each statement
Hey thanks so much for this. I've followed your steps but i've had an error in Power Automate.
I've also got my patch slightly different to yours. instead of it being RecID its a varRecord - is this is the reason why the 'Create_File' action in automate failed?
Can you help?
I'm an absolute noob with Powerapps so sorry in advance if its something really silly .
Hey Abu..thank you so much for your comments. Because you are new to power apps, my suggestion would be to try and follow the video, precisely, step by step to get it working before you try and apply it to your own project. That way you will get the theory right good luck.
Hi Chino, thanks for this video. can you help me how to display document on attachment based on ID?
A gallery and the Filter function are your friends... Im sure you'll work it out..I have faith in you!
Hii i tried this but i found a issue if i am uploading same file name in different I'd that time it is overlapping the earlier I'd is replaced with new I'd and i am losing the data can someone help me with this to overcome this i added parentid-filename but when I did that if i want to see that record id-filename is coming i don't want id when I am displaying in gallery data I just want file name can someone help me in this
He Aish...just trim the id from the filename when displaying in the gallery
how do you handle attachments with special characters in the file name? Seems that the Sharepoint Do Library doesn’t accept or show them.
If a file contains 'forbidden', I'd just rename the file before saving it
@@ChinoDoesStuff I have many users adding attachments to forms. They don’t know what characters are not permitted and there’s no notification that they have done anything wrong. They do no have access to the “empty” Sharepoint folder where the file is supposed to be stored.
I meant that you should get power automate to check filename for forbidden character and automatically rename/replace
This is great! can you add the attachments into a list item? so, basically create an item and then attach all the attachments to that list item.
That's exactly what the video demonstrates! :)
@@ChinoDoesStuff i mean add multiple attachments into a single list item. Not create multiple records with every attachment
Do you mean using the attachments field in a list item to save files for each record? If so, check my previous video on file attachments but I recommend using the updated method in this video
Hi Chino, I am looking at sending the attachments in an email, would you recommend using arrays as it sends multiple emails
Depends... Are you attaching one file to one email or multiple files to a single email? There's actually quite a few different ways you could achieve each.. my first thoughts are that you probably wouldn't need an array .
@@ChinoDoesStuff Multiple files to a single email, when I am using your flow in the video with 3 attachments, it will send me 3 different emails.
good stuff Chino, is there a way to pull metadata from the powerapp into the flow to populate with file?
For sure! That's exactly what I demonstrate in this video with the 'RecID' that I pass to the flow from Power Apps. Use this same method to set any meta data on the file that you wish :)
@@ChinoDoesStuff Brilliant! I guess my confusion is the linkage between SPO list and library. In my case it were better to simply have everything in a doclib without using the associated list, should you wish to illustrate that in a future video. :) If I get the first part working I intend to augment by printing screen of the finished form to pdf file and then attach that to the lib to accompany the forms metadata.
. I figured it out. I was operating under the assumption that you had created the text inputs by inserting a form tied to the data source and populated with fields from the source. Turns out you simply used text boxes and labels. After that observation and changing all my data cards for simple text inputs, the clouds dispersed, the scales fell from my eyes and all started working as yours did in your tutorial!
Words cannot express my gratitude to you for supplying this tutorial to the community!
In my Powerapps, ForAll doesnt appear FileAttachment option.
Make sure you follow the video, step by step. If you miss something, it could affect the result.
What if I use a form..