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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dTUuP9rL7_I.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!
