Two video updates here if it helps you on the topic. A version of this video but with v2 connectors ua-cam.com/video/cjcDH7_v6cE/v-deo.html Advanced Uploads ua-cam.com/video/AHWvG2C9vQo/v-deo.html
@@ShanesCows Still I like this video more because it enables me to pass list of attachments (files) to Power Automate and PA do the bulk upload. No need to do ForAll in Power App. That takes more time I think.
Im a nurse in an Emergency Department and just delving into PowerApps to improve our antiquated paper systems that still exist within our department. From research to auditing to stock and staff onboarding and education. Your tutorials are amazing and so helpful and opened up what's possible. I have delved into this without any IT support just your channel for guidance and have come so far in just a few weeks. Keep up the great work 👍👍
@@ShanesCows I am a nurse as well in Vietnam and trying to apply power platform and powerapps to help reduce the paper work as well as get the data to analyze :) thank you for your videos! great videos!
I wanted to drop a comment thanking you for your vids. By just your vids alone, I've been able to create an app in only several hours. It's not done yet, but the progress is awesome!
Thank you so much! I was trying to get this kind of thing to work based on your original "upload file to SharePoint document library" video. I also thought to use a collection, but was creating an image component for each individual uploaded file, and then having to check that the file content was not empty. Using the gallery's image is brilliant in its simplicity!
Thanks. I was pretty tickled with myself when I came up with it. 😊 I wouldn't have shared it if it had of been something crazy complicated. Simply or nothing.
Great video, Shane. Thans to your videos, I always manage to make improvements to the apps within our company. I combined your flow for creating an item in a Sharepoint list and uploading the attachments. Since I couldn't use the standard upload, thanks to your video, I can now add multiple attachments to an item. Thank you so much for sharing your knowledge with us.
Awesome video Shane! I wanted to pass along that there is a function in Power Automate that does what you're doing with the Mid function called dataUriToBinary so you could simplify the code in the upload all button to something like this: ClearCollect(colFiles,ShowColumns(AddColumns(Gallery1.AllItems,"Content",With({imageContent: Image3.Image},imageContent)),"Name","Content")); uploadFiles.Run(JSON(colFiles,JSONFormat.IncludeBinaryData)); and use the dataUri function in your flow where you need the binary data to create a sharepoint file: dataUriToBinary(items('Apply_to_each')?['Content'])
Hello both, Shane your videos are always amazing and I love that you are as enthusiastic as me, quick question I’ve used power apps V2 in power automate and have the issue that expect text but my colFiles is a table should I be using PowerApp instead or is there a way with V2. Sorry to comment on your comment Michael but I just wondered if you used V2? Thank you both
Just what I was looking for. Thanks Shane! Also gave a thumbs up to a previous comment about doing folders. I can drill down folders and grab the folder names in a flow but was having trouble uploading the files from within the flow (not using your method). Using this video, I can ask the user to point to the top level and grab the folder names first, put that in a dropdown, and then ask the user to grab the files from the specified folder - using the folder name as metadata on the document library file. Would be nice to do it all in one step though.
Hello Shane. Thanks to your videos I was able to add great new solutions to my departament with sharepoint/flow/powerApps and now starting to explore powerbi. Iam always recomending your channel to anyone interested in this systems. Looking forward to the Next live. 😃
Just when I finished watching it on the training portal, boom, it's on UA-cam. And perfect timed, yesterday spent time polishing your no SQL Expense that had only SQL references app I have downloaded from the training portal :) and this is the cherry on the cake, thank you!!
Wonderful Shane!! We have been waiting for the Multiple drag drop feature too! What would also be great is to also select Sharepoint library items from a gallery and drag them to a Windows folder or an email. Essentially the reverse. Or the ability to select items from a gallery and download them to a folder. It will come, I am sure of it, but this is a great step forward and thank you for showing the entire process of this integration and more!
Awesome video! You have no idea how much this has helped me in my project. I immediately hit the subscribe button. I have learnt a lot from this video and the single upload one! And I also love the enthusiasm! I'm sure I'll be learning so much more from you.
Since you can no longer select the PowerApps trigger and have to use the new PowerApps (V2) version, do you have a video that explains how to use the new trigger?
Hi Shane , thanks so much. Q , Can you upload a folder instead of single docs? I see it does show you folder from you PC I think you can upload folder IDK?...What workaround can I use if I want to assemble set of docs? Folder would be ideal as my client is familiar with folder , It's for Doc approval scenario. Requirement is multiple related docs/related set of docs could be routed for approval at once. I'd appreciate your response .
You have to manually add a Form control, connect it to a SharePoint list, and then steal the attachment control from there. This video shows it ua-cam.com/video/cjcDH7_v6cE/v-deo.html
Thanks for the fantastic video and lesson. Question... I am planning on using this to upload files for project tracking. In the Documents Library I have a LookUp column that looks at the projects list. How can I set that up at the time of upload so that the uploads are associated with a project from the list?
@@ShanesCows thx Shane, only the step for the JSON format in automate isn't clear for me, single attachament upload to sharepoint document library works fine for me. ho to get the json format, any video's? Many thanks in advance.
Hi Shane. Thanks so much for this video. I'm not able to get past the Parse JSON function. When I copy the putput of compose to the parse json "create from sample", the resulting schema is just a {type: "string"}. Do you know what could be causing the issue?
@@swwoberallgau6767 if the output data has double-quotes at the beginning and end, remove those 2 characters and try again. I also did a find & replace of escape character for double quotes => find: \" replace: " and the "NewLine" invisible character ( find: \ replace ) for the formatting. I think removing the beginning and ending double-quote would be enough to fix the issue, though.
Hello. On my "OnSelect" property of the button, the formula for the 'flow'.run() expects me to put "Compose_Imputs" and "Createfile_FileContent". Why is this happening? Did I miss something?
Awsome video! Excellent work as always! One question - the flow that is created keeps replacing the files, if one with the same name is already in Library. Is there a way that Automate will just upload the file without overwritting the one that is already there?
Hey Jennifer. You would have to capute the links one at a time in Power Automate, probably in a string variable, and then send that back to Power Apps to save. Or you could get fancy and after the create file action, but inside the apply to each, add an update item step that writes the link to a new home for you.
do you have any sample for uploading multiple files and viewing them in dataverse, and download them 1 by 1? I tried the previous approach using datacard but it seems it doesnt work anymore
I cant seem to get the steps where i find out what to put in the Parse JSON Schema. I cant get the flow to run because it needs that step, So i cant get it from the Compose. Any pointers?
Same Shane, I can't get the flow to run. When you said you ran the flow once to get the hot garbage, how did you do that? When I say I want to test the flow (in PowerAutomate), I select Manually, and it opens a panel that asks me to input something...I'm not sure what...into a field under the heading "Compose_Inputs." Do I need some hot garbage of my own? How do I find it if I need to run the flow in order to obtain said garbage but it won't let me run it without any garbage?
Good video, a question. I need to be able to extract the path and name of a file that is on a local server. Can I apply something similar to obtain these values? At first glance, I can easily obtain the name but not the path.
I can get the file to upload to specific sharepoint files, but when I try to access it, it says, "This workbook couldn't be opened because the file format may not be matching with the file extension." Any ideas on where I may have gone wrong?
hi, how about displaying all the upload file on the field? like for example, i have selected an item in the gallery with 2 attachments, and I want to display them back to the same upload file. is that possible?
You can use a Gallery to display them. You could do nested galleries or a separate gallery. If Nested the items property would be ThisItem.Attachments That should get you in the right ball park anyway.
I am following exactly your steps, but I am getting an error in PowerApps when I use the FLOW - "Invalid number of arguments: received 1, expected 2" ... Any idea !!
@@ShanesCows Thank you for reviewing my question... but in your video at 14:05 you have one input called Compose_Inputs and the second input at 15:55 in the Create File - CreateFile_FileContent. Did I misinterpret it somehow ?
I have the perfect excuse to set the max file size limit to 25Mb using this single upload, as it the limit for email attachments haha Cheers for the great ideas Shane... again :)
Hi Shane, my ParseJSON isn't generating the same type of schema that yours is. It is only resulting with a "type": "string" . Do you know what might be happening?
This is the last step in a full day's worth of headaches trying to get this to work. The single upload approach worked great. Not sure why it isn't generating the schema from copying and pasting. :(
I GOT IT TO WORK! So in your video when you say to "copy all the garbage", what the flow was looking for was the inline schema output. You mentioned using a really small file. When you do that, it shows the schema within the action itself and you don't have to click to view the output which puts it into a different format. (which is really annoying). Thank you for the great video!
If this was performed by a mobile user, can they use also select multiple photos from their Photo Library, or would they be required to select each image one by one by one until all images were chosen? I am trying to upload anywhere from 10-15 images, at once into a Document Library using this approach. It clearly works on desktop, but my primary users will be on mobile so I am curious if they will have the same interaction, or if it will be much more tedious (due to having select up to 15x images individually rather than a bulk selection). Thanks!
Watch this video, it will help with that part better ua-cam.com/video/3QaiM8SeWfM/v-deo.html Work out uploading one file and then doing multiple is easier. 🤩
Thanks for the video Shane, I have a question on the file sizes, Can we upload large files of more than 100 MB from Powerapps to ADLS or Sharepoint Document Library?
Hello Shane, thanks for this video. but i am getting same binary data for all attached documents. need clarification on image3.image property value . in single upload data you have used image1.image property - "Last(attachmentControl.Attachments).Value". and please let me know what we have use in multi upload option.
Did you manage to solve ? I have the same issue, shows 3 separate files in the gallery but then when it is pushed to sharepoint they all have the same data.
Solved. Make sure in OnSelect property of your button, where the image is referenced that no brackets or any other characters surround your image reference. Example: [@image5].Image should just be Image5.Image.
Erich there is a property of the attachment control you can change to the number of uploads allowed. I don't have it in front of me but if you look through the list it should be obvious. Like Max Number of Attachments or something.
Hello, Thank you for you video. Everything works but I have a problem with uploaded files from power apps. When I tried open a files I have error. The message says: "This workbook cannot be opened because the file format may not match the file extension." for the excel file. or "Unable to open this document type object for editing". It is with all kind of files. Do you have idea why files are uploaded to folder but I cant open it online? It is a problem with json?
@@ShanesCows Yes, I think so, but I don't know how to fix it. Do you think the code is ok? Set(varshowloading1newclient;true);; Set(vardemofromattachmentcontrolnew;JSON(Image1_1.Image;JSONFormat.IncludeBinaryData));; ClearCollect(colclientnew; ShowColumns(AddColumns(Gallery1newsales1.AllItems;"base64"; With({vardemofromattachmentcontrolnew:JSON(Image1_1.Image;JSONFormat.IncludeBinaryData)};Mid(vardemofromattachmentcontrolnew;Find(",";vardemofromattachmentcontrolnew)+1;Len(vardemofromattachmentcontrolnew)-Find(",";vardemofromattachmentcontrolnew)-1)));"Name";"base64"));; NowyklientSprzedażPowerAppdokumentyiaktualizacjakolumn.Run(JSON(colclientnew;JSONFormat.IncludeBinaryData);DataCardValue1.Text);; Reset(attachementsales1);; Clear(colclientnew);; Set(varshowloading1newclient;false);; Notify("Przesłano dokumenty";NotificationType.Success;3000)
Hi Shane, Many thanks for your great job and enthusiasm. Do you have a solution how to download all attachments (added in sharepoint list) by one click button? For example, I have app for purchase request where the user adds several attachments and I want to download these attachments (it is best to send them immediately) by one click.
Brilliant Shane! Now I could really use to combine this method with 1. Metadata, and 2. creating SP Docset and depositing the files into it. Pretty please! I get lots of errors when I attempt to combine your methods.
Due primarily to Shane's most excellent tutorials, I figured this out. Throw away DLPlaytime, and add the metadata fields after the compose bits, like so Set(varShowLoading, true); ClearCollect(colFiles, ShowColumns(AddColumns(Gallery1.AllItems, "base64", With({varDemoFromAttachmentControl: JSON( Image3.Image,JSONFormat.IncludeBinaryData)},Mid(varDemoFromAttachmentControl, Find(",", varDemoFromAttachmentControl)+1, Len(varDemoFromAttachmentControl) - Find(",", varDemoFromAttachmentControl) -1 ))), "base64", "Name") ); 'Compose1'.Run(JSON(colFiles,JSONFormat.IndentFour), Title, Ac1, Ac1Amt, Ac2, Ac2Amt, Ac3, Ac3Amt, Ac4, Ac4Amt, Department, Description, PBBP1, RequestorName, SubmittorName); Reset(AttachmentControl); Clear(colFiles); Set(varShowLoading, false); Launch("mySPOsitename.sharepoint.com/sites/lucky/UKDemo",{}, LaunchTarget.Replace) I also managed to create a folder in the flow for SharePoint, then in update file properties used the content type guid for docset. Now the flow uploads up to 10 files and drops them into a docset folder. The folder then shows the metadata, the files in the folder don't show metadata, which I wanted but may have to settle for this. Many thanks to Shane Young and others who have been of unimaginable help to me!
Hi Shane, your content is simply amazing. I just want to know if are there any videos that teach how to TREAT answers from a Power Automate flow inside a PowerApps Application? Things like sending a message to say your flow run properly or the current state of the flow, like, "running", "finished", etc. I look for some interaction between my App and my Flows.
Hello I hope that I can get my answer as soon as possible it would be amazing please. I followed the video step by step, however, when I come to the flow and parse to JSON the huge block of text generated by the compose (the outputs of it), I only get this small scheme: { "type": "string" } Nothing more. So I just cannot get my data (name etc.). If you can help me.
Hey , thanks for this video. I have a quick Q , Can I have a browse button in app , so that users can select their excel from lets say one drive or dataverse . And the template functioning of app can be intact with different excel but with same structure and metadata
This is as close to that as I have come. ua-cam.com/video/QcWjAt7QVn4/v-deo.html Not saying what you want isn't possibl,e just not something I have handy.
When we use PowerApp in Mobile the selection of the file can select only single only . Could anyone guide me how make it can select multiple items to the attachment?😢
I don't thinki it is possible. :( There is a new version of this video that shows how to upload easier but it does not fix your multi file on mobile problem. ua-cam.com/video/cjcDH7_v6cE/v-deo.html
Great video! Is it possible to choose which specific folder in your SharePoint library you want to upload to? Maybe via dropdown menu or something like that?
Thanks to this and the previous Upload video, I was able to complete my project. I learned something very interesting. I needed an additional field brought into the workflow and tried to set the variable with that BEFORE the compose action and Parse JSON. It did not like that. It gave me a Parse JSON error that it was expecting an array and got an integer instead. So I had to set it after the Parse JSON and before the Apply to all.
@Shane Young is it required to use a Document Library for multiple files? I was successful in adding a single file via your other video, but I have a SharePoint list. Really would like to avoid migrating to a Document library if possible.
Technically you could adapt this to add the files as attachments. I don't like attachments, so I would do it this way, but if you want to do attachments should be possible.
@@ShanesCows The Document Library won't work for me unfortunately because I would like to allow the user to attach multiple attachments to a single record. I did try to implement this technique in with the other video that you posted, but no cookies. I'll keep playing around with it. Thanks for your help!
Hi Shane, I followed your instructions on the video but, I encounter some error on the PowerApp ->Compose.Run(JSON(colFiles,JSONFormat.IndentFour)); The error prompt "Invalid number of arguments: received 1, expected" 2. " Could you please help clarify where I might have gone wrong? Thank you
@@ShanesCows I'm not sure what I'm passing from PowerApps at this point. In PowerApps, I've copied all of your code exactly as shown in the video. In PowerAutomate, I can't run the flow in order to get the hot garbage to paste into the Generate from sample space because I can't run the flow successfully to obtain that code. Instead, I typed in exactly what you have in the Schema field. (Paused that video so many times as you were scrolling through that schema!!) The flow still won't run for me. 😭 I have no idea what I'm doing wrong!
Thanks for the video! Does anyone know why the name of the new column "base64", is throwing the error "Expected Identifier Name"? "ShowColumns " and "AddColumns" also say "Invalid Argument", but i assume the issue is coming from the column name. It doesn't matter what I name the columns, the issue remains...
SOLVED: For anyone else facing this issue in future, the issue was the double quotes around the column names... The requirement for quotation marks on AddColumns, ShowColumns, DropColumns and RenameColumns was removed in a recent authoring framework update.
Glad you got it. two things 😎 1 - There is a new, easier way to do uploads finally ua-cam.com/video/cjcDH7_v6cE/v-deo.html 2 - My next video 10/14 will be about the updates to AddColumns and company Have a great day!
@@ShanesCows Hello! I tried that video initially but it doesn't explain how to pass additional meta data e.g., Unique ID alongside multiple files. I was pointed in the direction of this video to solve that... 😏 I managed to get the system above to transfer the files using the text input but they're corrupted.. Not sure if that's because of the new trigger
Thank you Shane for sharing. It's quite useful. Any idea on how to check file “magic number”; the word value $5A4D (“MZ or “ZM” in ASCII) of the file before upload to prevent .exe.? Is it possible in Power Platform ? From JSON Binary not able to identify this. What's your view, suggestion on this? Thanks
@@ShanesCows Thanks. If user rename an .exe to .pdf, there it's a security concern, file content type remains .exe. we can check only extension in Power App, there I got stuck.
Hi, your videos are awesome. I have a question, do you have a video where the user can specify the Sharepoint site to save the files to, rather than specifying the same Sharepoint site and library each time in Flow.
@@ShanesCows awesome, instead of specifying just the Teams in the dropdown, do you know what function to use to display all the Sharepoint sites the user has permission too. I have Team sites but they dont’t all have a Team to go with it
Yes, but you would have to do it a bit differently. Dataverse doesn't support "create file" like this instead it would be a column in a DV table. 😑 I am so comfortable with SharePoint document libraries even in DV scenarios I prefer it for the files.
Hi Shane! Will you be redesigning your "Upload Files to SharePoint" modules to use the new Power Apps (V2) trigger in Power Automate which includes the file data type as an input?
I am not planning to so far. I could but honestly I still use the v1 trigger. I think because it is a known trigger. Also, a lot of times I need flexibility, like this video, and it wouldn't work as well (at least in my head). But time will tell. 🤪
hi thanks for the video. Everything works perfectly until I want to open an attachment. Then it gives an error message that there is something wrong with the file. I think I am doing exactly what you are doing but still I am not succeeding? What exactly am I doing wrong I don't know.... :-)
Hello Shane great video. I've tried sending my attachments by e-mails instead of creating them into Sharepoint. But I keep receiving this error, can you help fix it? Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'. Thanks!
This works great Shane, thanks for sharing! One question, do you know the best way to update each of the file properties using Flow? I'm doing this using the individual file upload method but this does not work the same way. Basically, I just need to match up a submission id in one list with each attachment submitted.
@@MrEk5150 I know this is an old comment but I have 'Update file properties' after 'Create file' in the 'Apply to each' control. Use the ItemId generated from create file and it will loop through all items and update them with whatever value you've put in 😊
@@aislingfaulkner5712 thank you for replying back. I've been meaning to go back and look into this so I can add a new feature to my apps. I'll check this when I have a chance.
@@MrEk5150 If you add columns into the JSON collection, you can pass them into the apply to each loop in power automate as dynamic variables. I've tried this on a few different column types and haven't come across any issues yet :)
Yes. The mechanics would be a tad different as with Azure blob you would use a ForAll to loop through the files to upload them. And you wouldn't need the base64. But very possible.
Hi Shane! I used your single attachment video from before which after some tinkering (on my part 🤦🏻♂) is working like a dream. I just wanted to know though, if the developer isn't in a place where they can create a document library, how can I attach multiple attachments at once with the same process as the first video process, which goes to a Sharepoint Record item instead?
Sorry, it sounds working perfectly for everyone where I am struggling in the flow part of the things. My qs is if there is any reason why I can not apply the base64ToBinary(items('Apply_to_each')['base64']) in the Create a file? My problem is that I can only do base64ToBinary(body('Parse_JSON')) on the Write expression :(. Please I really need a help there
@@joelbokelman8689 I had the same issue. I added a Initialize Variable between Parse JSON and Apply_to_each; Set the initialize variable to string, and name the variable 'base64_x', Type: String, and Value: "". Then I add Set Variable in the Apply_to_each and assign it to 'base64'. Then when you do the expression it would be set to: base64ToBinary(variables('base64_x')) - Tested it and it works flawless. Kudos to the great Shane Young!!!!!!
Hi Shane, I am able to upload the files but when I open the file the content is not coming up. am just seeing a blank screen. I have converted base64 to binary in the file content column but still the same issue. Could you please help me with this issue.
Hi guys, got as far as the base64 to binary part, I have a single pic working fine but when doing the multiple picture upload when I do the expression base 64 to binary I dint have "base64" to convert just body, outputs Body from powerapps Compose inputs from poweraps ?
Kind of sounds like you aren't doing the parse JSON step in flow. Assuming you are sending a collection from Power Apps to flow like shown in the video.
@@ShanesCows I am experiencing the same issue and I do have the parse JSON step in my flow. I only see "body" and "outputs" and have tried every combination possible to make it work with no success to include manually typing in the expression as shown when you hover over it in this video. Any ideas what the issue may be? Also, I love your videos. BTW, as a Civil EN with no experience in this area, they have been a huge help in building an RFI management system. This is the first "hiccup" I have ran into that I couldn't resolve.
I think I figured out the issue: within base64ToBinary, the "Apply to each"'s "Current item" needs to be inserted between ( ) followed by ['base64']. Well it passed the test but now I am getting an "invalid number of arguments error" in pwrapps with my flow.
Something I noticed: if you use the app in a browser you can select multiple files in Windows, iOS, or Android. But, if you use the Power Apps app for any of those platforms, it's one file at a time (and no drag and drop). Despite a message when you open the url: "To get the best experience and full set of capabilities on your device, use the Power Apps app." Not true in this case!
excellent video Shane👍 I was successful in using the method you presented, which you explained really well ... really helpful, thanks! What I'm trying to do now is upload a specific file to SharePoint. I'm launching my PowerApp from Excel and passing the filename (including the path) into PowerApps; I'm trying to figure out how to use the Attachment Control to display the file so that I can use your method to extract the binary content, pass to Flow and save to SharePoint. If that's not possible, is there a was to have the Attachment Control open to a specific folderpath (which is being passed as a paramenter from Excel)?
it's brilliant but there is a newer version of the power flow trigger, which is trigger v2 which can take attachment as input and there is not need to convert to JSON or binary base 64 , I think this can make things more simple actually most of the tutorials still use the old trigger version.
I don't understand the 'PowerApp->Compose' part... keep getting an error. Edit_1: Okay so I figure out that i need to create somehting in "Power Automate" i am astuck where in the flow Compose exists but idk about "Compose_Input"... what is that?
I followed the steps and was able to upload files. However, when opening the files I receive error saying the file is damaged. I believe It loaded the files in text/plain ContentType for all types file (pdf, image, etc). How can it be fixed? Thanks.
I added this code to convert data but the uploaded files still not readable - base64ToBinary(items('Apply_to_each')['base64']). Can you help? @ShanesCows
Great video Shane. My version is almost there - it crates the file in Sharepoint, but when I read the file (txt or xlsx) it doesn't open as per the original file. Any ideas? I think I have everything in place as per your demo code... Thanks...
@@ShanesCows Well, it is there "base64ToBinary(items('Apply_to_each')['base64'])".....but I did have to manually type base64, rather than it being selectable in the list of dynamic content. Other than that, it all looks like your demo, together with the UploadAll button in the powerApp. Hmmm.....so close!
I have the same problem. Base64toBinary expression is there. It uploads, but when I download it doesn't open, it is corrupted. Did you manage to solve it?
I just group together a rectangle with whatever controls/labels etc are needed and set the visible field of the group to a boolean variable that I can toggle.
Hey, very good video and i almost got it going. I am getting an issue when the clicking the "Upload Load" button. My Flow is named "Compose". Here's the error message i am getting "Issue, Compose.Run failed: {"code": "InvokerConnectionOverrideFailed", "message": "Failed to parse invoker connections from trigger 'manual' outputs. Exception: Could not find any valid connection for the connection reference name 'shared_sharepointonline' in APIM tokens header"} Location Button3. OnSelect any idea where this issue might be. fyi, I did the other video on this cool method to work.
God bless you man!
Two video updates here if it helps you on the topic.
A version of this video but with v2 connectors
ua-cam.com/video/cjcDH7_v6cE/v-deo.html
Advanced Uploads
ua-cam.com/video/AHWvG2C9vQo/v-deo.html
@@ShanesCows Still I like this video more because it enables me to pass list of attachments (files) to Power Automate and PA do the bulk upload. No need to do ForAll in Power App. That takes more time I think.
Im a nurse in an Emergency Department and just delving into PowerApps to improve our antiquated paper systems that still exist within our department. From research to auditing to stock and staff onboarding and education. Your tutorials are amazing and so helpful and opened up what's possible. I have delved into this without any IT support just your channel for guidance and have come so far in just a few weeks. Keep up the great work 👍👍
Thank you! These types of messages mean a lot to me and keep me going. Iain keep up the awesome work and expanding your horizons!
@@ShanesCows I am a nurse as well in Vietnam and trying to apply power platform and powerapps to help reduce the paper work as well as get the data to analyze :) thank you for your videos! great videos!
This requirement was something we are expecting from past 2 years and you have provided the solution for this problem. thank you so much, great video
Glad to help. 😀
I wanted to drop a comment thanking you for your vids. By just your vids alone, I've been able to create an app in only several hours. It's not done yet, but the progress is awesome!
You are welcome. Keep going on your app. I am sure you will build awesome things.
Thank you so much! I was trying to get this kind of thing to work based on your original "upload file to SharePoint document library" video. I also thought to use a collection, but was creating an image component for each individual uploaded file, and then having to check that the file content was not empty. Using the gallery's image is brilliant in its simplicity!
Thanks. I was pretty tickled with myself when I came up with it. 😊 I wouldn't have shared it if it had of been something crazy complicated. Simply or nothing.
Great video, Shane. Thans to your videos, I always manage to make improvements to the apps within our company. I combined your flow for creating an item in a Sharepoint list and uploading the attachments. Since I couldn't use the standard upload, thanks to your video, I can now add multiple attachments to an item. Thank you so much for sharing your knowledge with us.
Fantastic!
Awesome video Shane! I wanted to pass along that there is a function in Power Automate that does what you're doing with the Mid function called dataUriToBinary so you could simplify the code in the upload all button to something like this:
ClearCollect(colFiles,ShowColumns(AddColumns(Gallery1.AllItems,"Content",With({imageContent: Image3.Image},imageContent)),"Name","Content"));
uploadFiles.Run(JSON(colFiles,JSONFormat.IncludeBinaryData));
and use the dataUri function in your flow where you need the binary data to create a sharepoint file: dataUriToBinary(items('Apply_to_each')?['Content'])
Thanks for sharing Michael. I have never tried that, I will add it to my list to look at. 🤩
Hello both, Shane your videos are always amazing and I love that you are as enthusiastic as me, quick question I’ve used power apps V2 in power automate and have the issue that expect text but my colFiles is a table should I be using PowerApp instead or is there a way with V2. Sorry to comment on your comment Michael but I just wondered if you used V2? Thank you both
Just what I was looking for. Thanks Shane! Also gave a thumbs up to a previous comment about doing folders. I can drill down folders and grab the folder names in a flow but was having trouble uploading the files from within the flow (not using your method). Using this video, I can ask the user to point to the top level and grab the folder names first, put that in a dropdown, and then ask the user to grab the files from the specified folder - using the folder name as metadata on the document library file. Would be nice to do it all in one step though.
Glad you got it Gary. I don’t have a quick fix to make it better.
Hello Shane. Thanks to your videos I was able to add great new solutions to my departament with sharepoint/flow/powerApps and now starting to explore powerbi. Iam always recomending your channel to anyone interested in this systems. Looking forward to the Next live. 😃
Fantastic!
Just when I finished watching it on the training portal, boom, it's on UA-cam. And perfect timed, yesterday spent time polishing your no SQL Expense that had only SQL references app I have downloaded from the training portal :) and this is the cherry on the cake, thank you!!
Adi this makes me so happy! 😍
Wonderful Shane!! We have been waiting for the Multiple drag drop feature too! What would also be great is to also select Sharepoint library items from a gallery and drag them to a Windows folder or an email. Essentially the reverse. Or the ability to select items from a gallery and download them to a folder. It will come, I am sure of it, but this is a great step forward and thank you for showing the entire process of this integration and more!
Awesome video! You have no idea how much this has helped me in my project. I immediately hit the subscribe button. I have learnt a lot from this video and the single upload one! And I also love the enthusiasm! I'm sure I'll be learning so much more from you.
Thanks. Glad it helped you. :)
Since you can no longer select the PowerApps trigger and have to use the new PowerApps (V2) version, do you have a video that explains how to use the new trigger?
Yes, just released it yesterday ua-cam.com/video/vpjf5mD-COs/v-deo.html
Hi Shane , thanks so much. Q , Can you upload a folder instead of single docs? I see it does show you folder from you PC I think you can upload folder IDK?...What workaround can I use if I want to assemble set of docs? Folder would be ideal as my client is familiar with folder , It's for Doc approval scenario. Requirement is multiple related docs/related set of docs could be routed for approval at once. I'd appreciate your response .
I have been waiting for this! Thank you! You are a genius!
You're very welcome!
As always great video Shane! But I noticed that the attachment control is missing from the insert menu. Any idea why and how to get this back?
You have to manually add a Form control, connect it to a SharePoint list, and then steal the attachment control from there. This video shows it ua-cam.com/video/cjcDH7_v6cE/v-deo.html
@@ShanesCows oh yes that was it! Thanks Shane!
Just could not get past Compose _Inputs in flow coming from PowerApps.
Thanks for the fantastic video and lesson. Question... I am planning on using this to upload files for project tracking. In the Documents Library I have a LookUp column that looks at the projects list. How can I set that up at the time of upload so that the uploads are associated with a project from the list?
QTT - Power Apps upload a file to SharePoint and set the metadata
ua-cam.com/video/e0kMjb686tc/v-deo.html That should help. 😎
great tut, only not so clear where or how to make the json file as example for the automate flow. example?
This video has the longer walk through of the JSON part ua-cam.com/video/3QaiM8SeWfM/v-deo.html
@@ShanesCows thx Shane, only the step for the JSON format in automate isn't clear for me, single attachament upload to sharepoint document library works fine for me. ho to get the json format, any video's? Many thanks in advance.
Hi Shane. Thanks so much for this video. I'm not able to get past the Parse JSON function. When I copy the putput of compose to the parse json "create from sample", the resulting schema is just a {type: "string"}. Do you know what could be causing the issue?
get the same issue...
@@swwoberallgau6767 if the output data has double-quotes at the beginning and end, remove those 2 characters and try again. I also did a find & replace of escape character for double quotes => find: \" replace: " and the "NewLine" invisible character ( find: \
replace
) for the formatting. I think removing the beginning and ending double-quote would be enough to fix the issue, though.
Hello. On my "OnSelect" property of the button, the formula for the 'flow'.run() expects me to put "Compose_Imputs" and "Createfile_FileContent". Why is this happening? Did I miss something?
You "Asked in Power Apps" twice. I would probably say easiest thing is just to build the flow again.
@@ShanesCows Is it possible to download your flow from somewhere, please?
Awsome video! Excellent work as always! One question - the flow that is created keeps replacing the files, if one with the same name is already in Library. Is there a way that Automate will just upload the file without overwritting the one that is already there?
Use the Now() function and append it to the filename in Power APps. That way every file has a unique name.
how to create the flow used in this video?
Shane! I have been trying to figure this out. You are the man. Give Chewy a treat for me.
Will do! 🐶♥
Hi Shane, question, in the first video you could save a ling to the file, how would you achieve this with the multi files? Thanks for your videos !!
Hey Jennifer. You would have to capute the links one at a time in Power Automate, probably in a string variable, and then send that back to Power Apps to save. Or you could get fancy and after the create file action, but inside the apply to each, add an update item step that writes the link to a new home for you.
This is perfect, great addition and something I've been looking forward to seeing happen for ages!
Thanks 🙏
Thanks Shane, for help us to learn how to use Power App. Happy life Paolo Italy.
Happy to help. Have a great day. 🐶
do you have any sample for uploading multiple files and viewing them in dataverse, and download them 1 by 1? I tried the previous approach using datacard but it seems it doesnt work anymore
I don't, I don't often store files in Dataverse. SharePoint is cheaper and more functional. 🤩 But I willl consider this for a video idea.
I cant seem to get the steps where i find out what to put in the Parse JSON Schema. I cant get the flow to run because it needs that step, So i cant get it from the Compose. Any pointers?
Same Shane, I can't get the flow to run. When you said you ran the flow once to get the hot garbage, how did you do that? When I say I want to test the flow (in PowerAutomate), I select Manually, and it opens a panel that asks me to input something...I'm not sure what...into a field under the heading "Compose_Inputs." Do I need some hot garbage of my own? How do I find it if I need to run the flow in order to obtain said garbage but it won't let me run it without any garbage?
Good video, a question. I need to be able to extract the path and name of a file that is on a local server. Can I apply something similar to obtain these values? At first glance, I can easily obtain the name but not the path.
Yikes, I am not sure, I haven't tried that one. Sorry
I can get the file to upload to specific sharepoint files, but when I try to access it, it says, "This workbook couldn't be opened because the file format may not be matching with the file extension." Any ideas on where I may have gone wrong?
Usually that means your base64 was bad. Check out the updated way to upload. Maybe give it a go. ua-cam.com/video/cjcDH7_v6cE/v-deo.html
@@ShanesCows It worked perfectly. Thanks a ton!
hi, how about displaying all the upload file on the field? like for example, i have selected an item in the gallery with 2 attachments, and I want to display them back to the same upload file. is that possible?
You can use a Gallery to display them. You could do nested galleries or a separate gallery. If Nested the items property would be ThisItem.Attachments
That should get you in the right ball park anyway.
I am following exactly your steps, but I am getting an error in PowerApps when I use the FLOW - "Invalid number of arguments: received 1, expected 2" ... Any idea !!
You did ask in power apps twice in your flow. 😔 easiest thing to do is to build a new flow and only ask in Power Apps once.
@@ShanesCows Thank you for reviewing my question... but in your video at 14:05 you have one input called Compose_Inputs and the second input at 15:55 in the Create File - CreateFile_FileContent.
Did I misinterpret it somehow ?
I have the perfect excuse to set the max file size limit to 25Mb using this single upload, as it the limit for email attachments haha Cheers for the great ideas Shane... again :)
Yay!
Hi Shane, my ParseJSON isn't generating the same type of schema that yours is. It is only resulting with a "type": "string" . Do you know what might be happening?
This is the last step in a full day's worth of headaches trying to get this to work. The single upload approach worked great. Not sure why it isn't generating the schema from copying and pasting. :(
I GOT IT TO WORK! So in your video when you say to "copy all the garbage", what the flow was looking for was the inline schema output. You mentioned using a really small file. When you do that, it shows the schema within the action itself and you don't have to click to view the output which puts it into a different format. (which is really annoying). Thank you for the great video!
Jonathan I am glad you got it. :)
Hi Shane, I hope you don't mind sharing a tutorial on how to upload multiple file with 1 Metadata in it to be uploaded in sharepoint list.
This video shows you how to add Metadata to the mix. :) ua-cam.com/video/e0kMjb686tc/v-deo.html
If this was performed by a mobile user, can they use also select multiple photos from their Photo Library, or would they be required to select each image one by one by one until all images were chosen? I am trying to upload anywhere from 10-15 images, at once into a Document Library using this approach. It clearly works on desktop, but my primary users will be on mobile so I am curious if they will have the same interaction, or if it will be much more tedious (due to having select up to 15x images individually rather than a bulk selection). Thanks!
Last time I checked they would have to select one at a time. 😔
Thank you Shane! Great vid!! I have a question, what about drag and drop? Has it been set automatically when the attachment control is inserted?
Yes, the control just does it. I just added the visual pieces for effect. :)
Great Video!
Really helped a lot!!
but im Stuck at the Compose/ParseJSON part - how do i let the PowerApps create the ParseJSON?
Watch this video, it will help with that part better ua-cam.com/video/3QaiM8SeWfM/v-deo.html
Work out uploading one file and then doing multiple is easier. 🤩
after rerunning the flow several times it suddenly worked!! :D
is there a way to create a hyperlink for each created item?
Thanks for the video Shane, I have a question on the file sizes, Can we upload large files of more than 100 MB from Powerapps to ADLS or Sharepoint Document Library?
Not that I have ever found.
Hey Shane. Great Video. How did you enable the drag & drop function for the attachement control? Thank you in advance.
I didn’t have to do anything. It just worked for me. Not for you? Maybe try a different browser?
Hi Shane! Thankyou for all the content you share. It's helping me a lot to learn and develop these pieces in my requirements. :))
Happy to help. Have a great day. 🐶
Hello Shane,
thanks for this video. but i am getting same binary data for all attached documents. need clarification on image3.image property value .
in single upload data you have used image1.image property - "Last(attachmentControl.Attachments).Value".
and please let me know what we have use in multi upload option.
Do you have the Image in the gallery? And the image property should be ThisItem.IforgetwhatItwas
Did you manage to solve ? I have the same issue, shows 3 separate files in the gallery but then when it is pushed to sharepoint they all have the same data.
Solved. Make sure in OnSelect property of your button, where the image is referenced that no brackets or any other characters surround your image reference. Example: [@image5].Image should just be Image5.Image.
Hi Shane, where were you getting the AttachmentControl field from? The attachment fields we have only seem to allow for one file to be uploaded.
Erich there is a property of the attachment control you can change to the number of uploads allowed. I don't have it in front of me but if you look through the list it should be obvious. Like Max Number of Attachments or something.
Absolutely awesome... This is amazing, thanks Shane!!!
Happy to help. Have a great day. 🐶
Hello, Thank you for you video. Everything works but I have a problem with uploaded files from power apps. When I tried open a files I have error.
The message says: "This workbook cannot be opened because the file format may not match the file extension." for the excel file.
or
"Unable to open this document type object for editing".
It is with all kind of files. Do you have idea why files are uploaded to folder but I cant open it online? It is a problem with json?
Most likely your JSON is bad or your BinaryToBase64 is missing
@@ShanesCows Yes, I think so, but I don't know how to fix it. Do you think the code is ok? Set(varshowloading1newclient;true);;
Set(vardemofromattachmentcontrolnew;JSON(Image1_1.Image;JSONFormat.IncludeBinaryData));;
ClearCollect(colclientnew; ShowColumns(AddColumns(Gallery1newsales1.AllItems;"base64"; With({vardemofromattachmentcontrolnew:JSON(Image1_1.Image;JSONFormat.IncludeBinaryData)};Mid(vardemofromattachmentcontrolnew;Find(",";vardemofromattachmentcontrolnew)+1;Len(vardemofromattachmentcontrolnew)-Find(",";vardemofromattachmentcontrolnew)-1)));"Name";"base64"));;
NowyklientSprzedażPowerAppdokumentyiaktualizacjakolumn.Run(JSON(colclientnew;JSONFormat.IncludeBinaryData);DataCardValue1.Text);;
Reset(attachementsales1);;
Clear(colclientnew);;
Set(varshowloading1newclient;false);;
Notify("Przesłano dokumenty";NotificationType.Success;3000)
Thanks Shane, you've broken this down really well.
Thanks
Thank you so much Shane!, would this work saving the attachments to a SharePoint List?
Attachments are different ua-cam.com/video/K74UFYgrKB4/v-deo.html
Hi Shane, Many thanks for your great job and enthusiasm. Do you have a solution how to download all attachments (added in sharepoint list) by one click button?
For example, I have app for purchase request where the user adds several attachments and I want to download these attachments (it is best to send them immediately) by one click.
Thanks Shane, this really helps. I have not watched the first video yet, but will do now. :) Job well done.
Thanks 😊
Brilliant Shane! Now I could really use to combine this method with 1. Metadata, and 2. creating SP Docset and depositing the files into it. Pretty please! I get lots of errors when I attempt to combine your methods.
I haven't tried to work with Document sets. Sorry, I am no help.
@@ShanesCows OK, I'll noodle on that part. How bout a hint on combining the functions of "DLPlaytime, and Compose" flows?
Due primarily to Shane's most excellent tutorials, I figured this out. Throw away DLPlaytime, and add the metadata fields after the compose bits, like so Set(varShowLoading, true);
ClearCollect(colFiles, ShowColumns(AddColumns(Gallery1.AllItems, "base64", With({varDemoFromAttachmentControl: JSON( Image3.Image,JSONFormat.IncludeBinaryData)},Mid(varDemoFromAttachmentControl, Find(",", varDemoFromAttachmentControl)+1, Len(varDemoFromAttachmentControl) - Find(",", varDemoFromAttachmentControl) -1 ))), "base64", "Name") );
'Compose1'.Run(JSON(colFiles,JSONFormat.IndentFour), Title, Ac1, Ac1Amt, Ac2, Ac2Amt, Ac3, Ac3Amt, Ac4, Ac4Amt, Department, Description, PBBP1, RequestorName, SubmittorName);
Reset(AttachmentControl);
Clear(colFiles);
Set(varShowLoading, false);
Launch("mySPOsitename.sharepoint.com/sites/lucky/UKDemo",{}, LaunchTarget.Replace)
I also managed to create a folder in the flow for SharePoint, then in update file properties used the content type guid for docset. Now the flow uploads up to 10 files and drops them into a docset folder. The folder then shows the metadata, the files in the folder don't show metadata, which I wanted but may have to settle for this.
Many thanks to Shane Young and others who have been of unimaginable help to me!
Hi Shane, your content is simply amazing. I just want to know if are there any videos that teach how to TREAT answers from a Power Automate flow inside a PowerApps Application? Things like sending a message to say your flow run properly or the current state of the flow, like, "running", "finished", etc. I look for some interaction between my App and my Flows.
I have not done anything like that. Flow can respond to Power Apps but I think just once per run.
Hello I hope that I can get my answer as soon as possible it would be amazing please. I followed the video step by step, however, when I come to the flow and parse to JSON the huge block of text generated by the compose (the outputs of it), I only get this small scheme: {
"type": "string"
}
Nothing more. So I just cannot get my data (name etc.). If you can help me.
this running good in my laptop, but so slow for my user. it takes 1min to upload 300kb files to sharepoint. any idea?
I haven't ran into that unless they were on very poor cellular connections.
Hey , thanks for this video.
I have a quick Q , Can I have a browse button in app , so that users can select their excel from lets say one drive or dataverse .
And the template functioning of app can be intact with different excel but with same structure and metadata
This is as close to that as I have come. ua-cam.com/video/QcWjAt7QVn4/v-deo.html Not saying what you want isn't possibl,e just not something I have handy.
When we use PowerApp in Mobile the selection of the file can select only single only . Could anyone guide me how make it can select multiple items to the attachment?😢
I don't thinki it is possible. :( There is a new version of this video that shows how to upload easier but it does not fix your multi file on mobile problem. ua-cam.com/video/cjcDH7_v6cE/v-deo.html
Drag and Drop does not work any more . Have you seen this issue ?
No. I tested it last week and it worked. Not sure why it isn’t working for you.
Great video! Is it possible to choose which specific folder in your SharePoint library you want to upload to? Maybe via dropdown menu or something like that?
This video ua-cam.com/video/2gE0e_AsdMw/v-deo.html
Thanks to this and the previous Upload video, I was able to complete my project. I learned something very interesting. I needed an additional field brought into the workflow and tried to set the variable with that BEFORE the compose action and Parse JSON. It did not like that. It gave me a Parse JSON error that it was expecting an array and got an integer instead. So I had to set it after the Parse JSON and before the Apply to all.
Interesting. Not sure why.
The files are getting uploaded in sharepoint , but when am trying to open it's showing error(not able to preview). Any idea how to overcome this?
@Shane Young is it required to use a Document Library for multiple files? I was successful in adding a single file via your other video, but I have a SharePoint list. Really would like to avoid migrating to a Document library if possible.
Technically you could adapt this to add the files as attachments. I don't like attachments, so I would do it this way, but if you want to do attachments should be possible.
@@ShanesCows The Document Library won't work for me unfortunately because I would like to allow the user to attach multiple attachments to a single record. I did try to implement this technique in with the other video that you posted, but no cookies. I'll keep playing around with it. Thanks for your help!
@@ShanesCows Got it working, just had to think outside the box a little bit :)! Thank you so much!
@@cperry420 How did you manage this!!! I'm in the same predicament! 😩
Hi Shane, I followed your instructions on the video but, I encounter some error on the PowerApp ->Compose.Run(JSON(colFiles,JSONFormat.IndentFour)); The error prompt "Invalid number of arguments: received 1, expected" 2. " Could you please help clarify where I might have gone wrong? Thank you
Is there anyway to select & attach multiple files from phone? As there is no drag & drop functionality in phone (for PowerApps)
Thanks
Not that I know of. 😐
Hi Shane, what am I doing wrong when the 'Generate from sample' step is giving me back a string instead of an array?
Bert I would check what you are passing from PowerApps. Maybe you are sending text instead of the whole collection?
@@ShanesCows I'm not sure what I'm passing from PowerApps at this point. In PowerApps, I've copied all of your code exactly as shown in the video. In PowerAutomate, I can't run the flow in order to get the hot garbage to paste into the Generate from sample space because I can't run the flow successfully to obtain that code. Instead, I typed in exactly what you have in the Schema field. (Paused that video so many times as you were scrolling through that schema!!) The flow still won't run for me. 😭 I have no idea what I'm doing wrong!
Wow!! FINALLY!! cool! 🤩🤩
One.qs..any way to hide the filenames inside the attachment control?
Change the font color to Transparent :)
Thanks for the video! Does anyone know why the name of the new column "base64", is throwing the error "Expected Identifier Name"? "ShowColumns " and "AddColumns" also say "Invalid Argument", but i assume the issue is coming from the column name. It doesn't matter what I name the columns, the issue remains...
SOLVED: For anyone else facing this issue in future, the issue was the double quotes around the column names... The requirement for quotation marks on AddColumns, ShowColumns, DropColumns and RenameColumns was removed in a recent authoring framework update.
Glad you got it. two things 😎
1 - There is a new, easier way to do uploads finally ua-cam.com/video/cjcDH7_v6cE/v-deo.html
2 - My next video 10/14 will be about the updates to AddColumns and company
Have a great day!
@@ShanesCows Hello! I tried that video initially but it doesn't explain how to pass additional meta data e.g., Unique ID alongside multiple files. I was pointed in the direction of this video to solve that... 😏 I managed to get the system above to transfer the files using the text input but they're corrupted.. Not sure if that's because of the new trigger
Hey Shane. Excellent video as always! Is there a way to turn this solution into one that will upload to multiple Sharepoint items?
Thank you Shane for sharing. It's quite useful. Any idea on how to check file “magic number”; the word value $5A4D (“MZ or “ZM” in ASCII) of the file before upload to prevent .exe.? Is it possible in Power Platform ? From JSON Binary not able to identify this. What's your view, suggestion on this? Thanks
I am not sure, sorry. Could you just check the file extension Right(filename,3) = "exe" or something like that?
@@ShanesCows Thanks. If user rename an .exe to .pdf, there it's a security concern, file content type remains .exe. we can check only extension in Power App, there I got stuck.
Not working for me, there are two errors one is it says base64 column already exists and Add columns has some invalid arguments.
Hi, your videos are awesome.
I have a question, do you have a video where the user can specify the Sharepoint site to save the files to, rather than specifying the same Sharepoint site and library each time in Flow.
This video has the concept :) ua-cam.com/video/2gE0e_AsdMw/v-deo.html You can ask in Power Apps for the values of all of the fields in flow.
@@ShanesCows awesome, instead of specifying just the Teams in the dropdown, do you know what function to use to display all the Sharepoint sites the user has permission too. I have Team sites but they dont’t all have a Team to go with it
Hi Shane. Can you use this functionality to attach files to Dynamics 365 records on a Canvas app and show it as a gallery?
I think the file object in D365 works similar but I have not tried.
Hi Shane,
Great content. Just a quick question- Is this possible with Dataverse as backend instead of SharePoint?
Yes, but you would have to do it a bit differently. Dataverse doesn't support "create file" like this instead it would be a column in a DV table. 😑 I am so comfortable with SharePoint document libraries even in DV scenarios I prefer it for the files.
Hi Shane! Will you be redesigning your "Upload Files to SharePoint" modules to use the new Power Apps (V2) trigger in Power Automate which includes the file data type as an input?
I am not planning to so far. I could but honestly I still use the v1 trigger. I think because it is a known trigger. Also, a lot of times I need flexibility, like this video, and it wouldn't work as well (at least in my head). But time will tell. 🤪
@@ShanesCows Thanks so much Shane! Your videos are amazing BTW, and have helped me out so much. Can't thank you enough :)
hi
thanks for the video. Everything works perfectly until I want to open an attachment. Then it gives an error message that there is something wrong with the file.
I think I am doing exactly what you are doing but still I am not succeeding?
What exactly am I doing wrong I don't know.... :-)
Hello Shane great video.
I've tried sending my attachments by e-mails instead of creating them into Sharepoint. But I keep receiving this error, can you help fix it?
Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'.
Thanks!
This works great Shane, thanks for sharing! One question, do you know the best way to update each of the file properties using Flow? I'm doing this using the individual file upload method but this does not work the same way. Basically, I just need to match up a submission id in one list with each attachment submitted.
I don't have a good answer for that Eric. Hmmm
@@ShanesCows Bummer. I've tried a few different ways using the "Get Item" step and it just will not work for me.
@@MrEk5150 I know this is an old comment but I have 'Update file properties' after 'Create file' in the 'Apply to each' control. Use the ItemId generated from create file and it will loop through all items and update them with whatever value you've put in 😊
@@aislingfaulkner5712 thank you for replying back. I've been meaning to go back and look into this so I can add a new feature to my apps. I'll check this when I have a chance.
@@MrEk5150 If you add columns into the JSON collection, you can pass them into the apply to each loop in power automate as dynamic variables. I've tried this on a few different column types and haven't come across any issues yet :)
Hi Shane! Is it possible to to the same, but with blob Storage instead of SharePoint?
Yes. The mechanics would be a tad different as with Azure blob you would use a ForAll to loop through the files to upload them. And you wouldn't need the base64. But very possible.
Hi Shane! I used your single attachment video from before which after some tinkering (on my part 🤦🏻♂) is working like a dream.
I just wanted to know though, if the developer isn't in a place where they can create a document library, how can I attach multiple attachments at once with the same process as the first video process, which goes to a Sharepoint Record item instead?
Maybe this will give you some ideas? Power Apps Attachments for SharePoint - Files, Images, and Signatures
ua-cam.com/video/K74UFYgrKB4/v-deo.html
Sorry, it sounds working perfectly for everyone where I am struggling in the flow part of the things. My qs is if there is any reason why I can not apply the base64ToBinary(items('Apply_to_each')['base64']) in the Create a file? My problem is that I can only do base64ToBinary(body('Parse_JSON')) on the Write expression :(. Please I really need a help there
try pasting: base64ToBinary(triggerBody()['Createfile_FileContent'])
I am having this exact same issue :( Did you ever find the solution to this anyone??
@Shane Young
@@joelbokelman8689 I had the same issue. I added a Initialize Variable between Parse JSON and Apply_to_each; Set the initialize variable to string, and name the variable 'base64_x', Type: String, and Value: "". Then I add Set Variable in the Apply_to_each and assign it to 'base64'. Then when you do the expression it would be set to: base64ToBinary(variables('base64_x')) - Tested it and it works flawless. Kudos to the great Shane Young!!!!!!
@@keiththoms187 You are a legend man, thank you so much! :)
Great Stuff Shane. Another tool to add to the armoury.
Awesome, build awesome things
Hi Shane, I am able to upload the files but when I open the file the content is not coming up. am just seeing a blank screen. I have converted base64 to binary in the file content column but still the same issue. Could you please help me with this issue.
How to learn from Power Apps 911 Training ? Please guide me.
Here is our free getting started training class. training.powerapps911.com/courses/power-apps-and-power-automate-getting-started
@@ShanesCows Thanks
Hi guys, got as far as the base64 to binary part, I have a single pic working fine but when doing the multiple picture upload when I do the expression base 64 to binary I dint have "base64" to convert just body, outputs
Body from powerapps
Compose inputs from poweraps ?
Kind of sounds like you aren't doing the parse JSON step in flow. Assuming you are sending a collection from Power Apps to flow like shown in the video.
@@ShanesCows I am experiencing the same issue and I do have the parse JSON step in my flow. I only see "body" and "outputs" and have tried every combination possible to make it work with no success to include manually typing in the expression as shown when you hover over it in this video. Any ideas what the issue may be? Also, I love your videos. BTW, as a Civil EN with no experience in this area, they have been a huge help in building an RFI management system. This is the first "hiccup" I have ran into that I couldn't resolve.
I think I figured out the issue: within base64ToBinary, the "Apply to each"'s "Current item" needs to be inserted between ( ) followed by ['base64']. Well it passed the test but now I am getting an "invalid number of arguments error" in pwrapps with my flow.
Pure magic Shane!
It is great!!
Thanks Juan 🐱🏍
Just solved one my needs. Great video!
Great to hear!
Something I noticed: if you use the app in a browser you can select multiple files in Windows, iOS, or Android.
But, if you use the Power Apps app for any of those platforms, it's one file at a time (and no drag and drop).
Despite a message when you open the url: "To get the best experience and full set of capabilities on your device, use the Power Apps app."
Not true in this case!
excellent video Shane👍 I was successful in using the method you presented, which you explained really well ... really helpful, thanks!
What I'm trying to do now is upload a specific file to SharePoint. I'm launching my PowerApp from Excel and passing the filename (including the path) into PowerApps; I'm trying to figure out how to use the Attachment Control to display the file so that I can use your method to extract the binary content, pass to Flow and save to SharePoint. If that's not possible, is there a was to have the Attachment Control open to a specific folderpath (which is being passed as a paramenter from Excel)?
it's brilliant but there is a newer version of the power flow trigger, which is trigger v2 which can take attachment as input and there is not need to convert to JSON or binary base 64 , I think this can make things more simple actually most of the tutorials still use the old trigger version.
I don't understand the 'PowerApp->Compose' part... keep getting an error.
Edit_1: Okay so I figure out that i need to create somehting in "Power Automate" i am astuck where in the flow Compose exists but idk about "Compose_Input"... what is that?
That's the name of his workflow
Been running with 24 files @ 50Mb max for quite some time.
Thanks. Good to know
I followed the steps and was able to upload files. However, when opening the files I receive error saying the file is damaged. I believe It loaded the files in text/plain ContentType for all types file (pdf, image, etc). How can it be fixed? Thanks.
I added this code to convert data but the uploaded files still not readable - base64ToBinary(items('Apply_to_each')['base64']). Can you help? @ShanesCows
Great video Shane. My version is almost there - it crates the file in Sharepoint, but when I read the file (txt or xlsx) it doesn't open as per the original file. Any ideas? I think I have everything in place as per your demo code... Thanks...
Usually if the file is corrupt that is because you forgot the Base64toBinary expression in your flow action :)
@@ShanesCows Well, it is there "base64ToBinary(items('Apply_to_each')['base64'])".....but I did have to manually type base64, rather than it being selectable in the list of dynamic content. Other than that, it all looks like your demo, together with the UploadAll button in the powerApp. Hmmm.....so close!
I have the same problem. Base64toBinary expression is there. It uploads, but when I download it doesn't open, it is corrupted. Did you manage to solve it?
Same issue here.
@@denzoli8 have you figured this out? I have the same issue. Hope you can share with me about what you've found. Thanks much!
Please do a NEW video of popup screns and how to apply them
I just group together a rectangle with whatever controls/labels etc are needed and set the visible field of the group to a boolean variable that I can toggle.
I can add this to the list. Thanks
Multiple images are not selected on the mobile. What should I do?
did you find an answer?
When will this be avaiable for the mobile version? someone knows?
Tried using his ShowColumns formula, but it gives me errors saying it has invalid arguments and can't pinpoint the problem, anyone had similar issues?
Thanks so much!! This is really great!! Gonna test this out!! Good job!!
Happy to help!
Amazing and good for our job to be able to use as drag and drop functionality.
Awesome 😎
Hey, very good video and i almost got it going. I am getting an issue when the clicking the "Upload Load" button. My Flow is named "Compose". Here's the error message i am getting
"Issue, Compose.Run failed: {"code": "InvokerConnectionOverrideFailed", "message": "Failed to parse invoker connections from trigger 'manual' outputs. Exception: Could not find any valid connection for the connection reference name 'shared_sharepointonline' in APIM tokens header"}
Location Button3. OnSelect any idea where this issue might be. fyi, I did the other video on this cool method to work.
you are a STAR!
Glad to help. 😎 If it helps there is an update to this. ua-cam.com/video/cjcDH7_v6cE/v-deo.html