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!!!
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
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.
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.
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. :)
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!
wow what an amazing tutorial mate thank you. there is just a small change using the modern tools where you can directly enter your flow "SaveFileToSharePoint" directly. Other than that, it works very well, appreciate in you sharing this knowledge, and taking the time to explain this very technical task in a simple to understand manner.
@@ChinoDoesStuff just watched part 2, that's a neat way to connect the child documents. It will be handy to my user's so can't wait to add this to my apps for a better experience. Once again thank you
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.
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
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.
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!
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 :)
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?
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..
Many thanks! My issue is that I'm using an SPO list with a customized PowerApps form, and the list includes attachments. Users should only have "Add" rights, not "Edit" rights. There are flows that adjust the access rights later. The way SPO attachments work is that the item is saved, then files are added thereafter. So, users need the "Edit" permission to add file attachments. I'll give this method a try so a flow will add the files to a library (using a service account; read-only for users), and then update the SPO item with the links. I'll let you know how it goes. Cheers!
Well... I was hoping that this trick would help adding the attachments to the SPO list, but instead, I'll try adding them to a library and creating links in the PowerApps form. Or, create a new permission when people add entries, then switch it after they submit it. We shall see...
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.
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.
@@ChinoDoesStuff Great stuff. I have an app where users needs to attach 5 different types of attachments. I managed get it to work with your solution when the user initially submits without clicking on the save button. But they have a requirement to save the details first and come back and submit later. I'm getting an error on this so would be great if you can do a video on removing and deleting files.
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?
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 ?
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?
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 th-cam.com/video/dTUuP9rL7_I/w-d-xo.html
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..
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.
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??
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?
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.
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.
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.
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?
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.
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.
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!
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.
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 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)
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.
@@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.
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 .
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
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.
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!
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.
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
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.
Hello mate, I am having issue on the create file flow part the error is the file & name is not existed triggerBody()['file']['name'] can you help please thanks
@@ChinoDoesStuff Hi Chino, I have tried everything and didn't work for the reason says triggerBody()['file']['name']. is there any chance you can share flow file? Thanks
All I can say is that what is shown in the video is verifiable and works. If you are struggling with the concepts perhaps try and get the example working first by following the video step by step. If you are still really struggling with it then perhaps we can organise a quick teams meeting sometime to help you out
It would be nice to have a link to the previous vid where he created the sharepoint whatever so he could get the attachment control to appear. I'm following along and can't get the attachment control to appear.
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 }}
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.
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
Awesome solution for a problem I struggle to solve since a weak! Thank you Chino!
Great video - exactly what I have been trying to do for a couple of days. Perfect solution.
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 th-cam.com/video/oFa96qlDoLE/w-d-xo.html
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.
one of the easiest way to upload multiplt file from powerapps Thanks a lot
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
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. :)
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! th-cam.com/video/oFa96qlDoLE/w-d-xo.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!
wow what an amazing tutorial mate thank you. there is just a small change using the modern tools where you can directly enter your flow "SaveFileToSharePoint" directly. Other than that, it works very well, appreciate in you sharing this knowledge, and taking the time to explain this very technical task in a simple to understand manner.
th-cam.com/video/oFa96qlDoLE/w-d-xo.html this is part 2 if you are interested...
@@ChinoDoesStuff just watched part 2, that's a neat way to connect the child documents. It will be handy to my user's so can't wait to add this to my apps for a better experience. Once again thank you
Thanks for the video. Using it I finally worked out how to upload an attachment and send it in an email.
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.
Awesome video. It may take me another 2 or 3 views to fully implement, but great work!
Chino, you are a lifesaver. Thank you so much !!!
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
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.
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 :)
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 a lot for a very simple explanation and straight forward process.
Glad it was helpful
Thanks a lot, it worked for me and keep uploading nice videos...😇
Really Nice. Make it look so easy.
This was a great new way to accomplish uploading.
Hey Chino, 1000 thanks for this Sharing !
10,000x thankyou for liking and commenting!
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.
th-cam.com/video/oFa96qlDoLE/w-d-xo.html
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...
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 SO MUCH!!! It worked the first TIME!!!
You're welcome!
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
Thanks that was useful - just used it for my proof of concepts - appreciate it!
Not a problem victor..
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?
You are a champion my friend!
Thankyou! I am glad the video helped.
Bro, you really a saviour, thanks a lot.
Absolutely any time my PA brother
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! :)
Excellent, Chino. Do another video.
Here you go... th-cam.com/video/oFa96qlDoLE/w-d-xo.html
Many thanks! My issue is that I'm using an SPO list with a customized PowerApps form, and the list includes attachments. Users should only have "Add" rights, not "Edit" rights. There are flows that adjust the access rights later. The way SPO attachments work is that the item is saved, then files are added thereafter. So, users need the "Edit" permission to add file attachments. I'll give this method a try so a flow will add the files to a library (using a service account; read-only for users), and then update the SPO item with the links. I'll let you know how it goes. Cheers!
Well... I was hoping that this trick would help adding the attachments to the SPO list, but instead, I'll try adding them to a library and creating links in the PowerApps form. Or, create a new permission when people add entries, then switch it after they submit it. We shall see...
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?
Was there ever a follow up video on the last topic you mentioned at the end of the video?
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?
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..
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.
@@ChinoDoesStuff Great stuff. I have an app where users needs to attach 5 different types of attachments. I managed get it to work with your solution when the user initially submits without clicking on the save button. But they have a requirement to save the details first and come back and submit later. I'm getting an error on this so would be great if you can do a video on removing and deleting files.
In your flow, For file name, you can type: triggerBody()['file']['name']. It will give you the attachment name.
Very interesting way to do that !!!! Tks a lot !
Cheers!
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 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?
Thank you sir. Good stuff
You are very 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.
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?
were you able to create another video that you mentioned at the end?
Yes... here is part 2 - th-cam.com/video/oFa96qlDoLE/w-d-xo.html
Hi after attaching files the files names should be below the Attach file , how to go about it?
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 th-cam.com/video/dTUuP9rL7_I/w-d-xo.html
15:18 i somehow do not have the action button any idea where is it Chino?
No idea. Sorry. :)
DUDE!!! THANK YOU SO MUCH!!!
Anytime Simm... Glad I could help..
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.
Excellent content
Thanks so much Ves...
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..
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?
hello Chino, Im new in sharepoint. just ask if how to create that "Issue Attachment" for file. thanks
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.
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
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?
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..
Hi thanks for this video can we zip the attachment and save
Trying to do this with regular submit form .Seams the submit doesn't return the ID fast enough to pass to power automate.
Great tutorial
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..
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?
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.
What is the formula to program a button in power app . That the function will be to attatch a document
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.
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.
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, 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!
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 ;
When I remove the pdf in power apps it is still in the library. How should I control this?
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
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.
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.
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
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, 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)
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 - 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
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
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.
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
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.
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!
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.
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, 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! :)
thank you🤟🥰
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
Hello mate, I am having issue on the create file flow part the error is the file & name is not existed triggerBody()['file']['name'] can you help please thanks
Hey base... Try to follow the video step by step..it's probably something really small you are doing differently
@@ChinoDoesStuff Hi Chino, I have tried everything and didn't work for the reason says triggerBody()['file']['name']. is there any chance you can share flow file? Thanks
All I can say is that what is shown in the video is verifiable and works. If you are struggling with the concepts perhaps try and get the example working first by following the video step by step. If you are still really struggling with it then perhaps we can organise a quick teams meeting sometime to help you out
That's awesome..
@@mjones9683 I have tried several ways and days but didn't work so I give up unless Chino share with us a sample of the app.
It would be nice to have a link to the previous vid where he created the sharepoint whatever so he could get the attachment control to appear. I'm following along and can't get the attachment control to appear.
I'm pretty sure I mentioned that it can be any SharePoint list. There is nothing specific about the one I use.
@@ChinoDoesStuff Thanks for reply. I found it while hunting through 'hidden columns' or some such thing. SMH.
When you add a form control to your app and connect to a SharePoint list, any list, it should be there in plain sight.
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.
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