Two video updates here if it helps you on the topic. A version of this video but with v2 connectors czcams.com/video/cjcDH7_v6cE/video.html Advanced Uploads czcams.com/video/AHWvG2C9vQo/video.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.
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
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. 😃
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.
Just when I finished watching it on the training portal, boom, it's on CZcams. 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!!
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.
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.
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!
I am sorry you have a hard time following. Maybe you should try learning more of the Power Apps basics? I am not sure why you are having a hard time following. 😔 Literally millions of people watch my videos and have followed along just fine. At the time stamp you posted I explained that part in detail in the first upload video. So, I didn't repeat that depth here. If you haven't figured out how to upload a single file then go back and work through that video again. Once you have that part fully working you will be able to apply it here. Good luck.
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 , 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 .
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.
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 czcams.com/video/cjcDH7_v6cE/video.html
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!
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?
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?
Great solution Shane. My usual question to Microsoft stands, why make dealing with files in PowerApps so hard?. ;) This video gives me food for thought in terms of using multiple attachment controls and being able to use them to separate out files type based on which control someone used to upload them in. e.g. One control for file 1 here, Then another control for file 2 somewhere else on the form. Run a flow on submit that grabs the files from each control / collection and files them in the right places. Instead of lumping them together in one place like you traditionally do. Also maybe for security rerasons or a process you have where files need to go to different audiences for further processing or security requirements. Also you can identify the file s with metadata etc. Might be a bit of a performance killer in the app though with additional controls.
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.
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.
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?
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.
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)?
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.
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?
Awesome job again Shane! Thanks again for all the hard work you put into these videos! I can select and upload multiple files using Windows, however, when I use my app on mobile I can only select one file at a time. Is that a mobile limitation or is there a way around it?
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.
Watch this video, it will help with that part better czcams.com/video/3QaiM8SeWfM/video.html Work out uploading one file and then doing multiple is easier. 🤩
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
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.
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.
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?
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 :)
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!
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.
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.
Hey, it is me again! Your Videos are godsend and I love your energy. I've copied the code and all but I'm pretty sure I did something wrong and I am not sure why and where and what... I am fairly new to PowerApps. It underlined the "Base64" and "Name" and tells me it is expecting an identifier name. Do you have any idea what that could mean?
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.
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, 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
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. czcams.com/video/QcWjAt7QVn4/video.html Not saying what you want isn't possibl,e just not something I have handy.
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?
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!!!!!!
Shane, First off - thank you very much for your content. Secondly, how would I go about setting all uploaded documents to be sequentially named using the uploader's username and a time/date stamp (e.g. nk5501_121120200950, nk5501_121220200830 or something similar)? Thank you again!
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!
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.
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 ?
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.
@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
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. czcams.com/video/cjcDH7_v6cE/video.html
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?
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!
Hey Shane! Thank you so much for this video. It has helped a lot! I have a question though. It worked fine for months, but then a few days ago every file that gets uploaded through it cannot be opened. (Either through the web app or if I download it through the desktop app). Each file has content. I checked the workflow and it still does what it does, but for some reason every file cannot be opened. I checked around and someone else I know has the same issue (started at around the same time) Are you familiar with this and if so, do you know a solution? :) Thank you in advance!
@@ShanesCows Hey Shane, I found the reason. It seems to be connected to using the base64 output as the file content in Create File in Power Automate. When I added the expression there base64tobinary as file content and gave it the base64 that was passed down from the app the files opened normally again. I have no idea though why it worked before and now suddenly stopped working. (Not just in my solution, but that of a friend as well).
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.
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)
@@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!
God bless you man!
Two video updates here if it helps you on the topic.
A version of this video but with v2 connectors
czcams.com/video/cjcDH7_v6cE/video.html
Advanced Uploads
czcams.com/video/AHWvG2C9vQo/video.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.
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
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!
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!
Just when I finished watching it on the training portal, boom, it's on CZcams. 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! 😍
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.
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. :)
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!
13:38 you lost me. followed 3 of your videos now and you jump all over the place...
I am sorry you have a hard time following. Maybe you should try learning more of the Power Apps basics? I am not sure why you are having a hard time following. 😔 Literally millions of people watch my videos and have followed along just fine.
At the time stamp you posted I explained that part in detail in the first upload video. So, I didn't repeat that depth here. If you haven't figured out how to upload a single file then go back and work through that video again. Once you have that part fully working you will be able to apply it here. Good luck.
Shane! I have been trying to figure this out. You are the man. Give Chewy a treat for me.
Will do! 🐶♥
Thanks Shane, for help us to learn how to use Power App. Happy life Paolo Italy.
Happy to help. Have a great day. 🐶
This is perfect, great addition and something I've been looking forward to seeing happen for ages!
Thanks 🙏
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!
Thanks Shane, you've broken this down really well.
Thanks
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. 🐶
Thanks Shane, this really helps. I have not watched the first video yet, but will do now. :) Job well done.
Thanks 😊
I have been waiting for this! Thank you! You are a genius!
You're very welcome!
Absolutely awesome... This is amazing, thanks Shane!!!
Happy to help. Have a great day. 🐶
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 .
Awesome Shane 😊
Thank you! 🥰 I have a new upload video coming very soon. 🤩
Just could not get past Compose _Inputs in flow coming from PowerApps.
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.
Amazing and good for our job to be able to use as drag and drop functionality.
Awesome 😎
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 czcams.com/video/cjcDH7_v6cE/video.html
@@ShanesCows oh yes that was it! Thanks Shane!
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!
Great Stuff Shane. Another tool to add to the armoury.
Awesome, build awesome things
how to create the flow used in this video?
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.
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?
Great solution Shane.
My usual question to Microsoft stands, why make dealing with files in PowerApps so hard?. ;)
This video gives me food for thought in terms of using multiple attachment controls and being able to use them to separate out files type based on which control someone used to upload them in. e.g. One control for file 1 here, Then another control for file 2 somewhere else on the form. Run a flow on submit that grabs the files from each control / collection and files them in the right places. Instead of lumping them together in one place like you traditionally do. Also maybe for security rerasons or a process you have where files need to go to different audiences for further processing or security requirements. Also you can identify the file s with metadata etc.
Might be a bit of a performance killer in the app though with additional controls.
I like the creativity of thought! Run down the rabbit hole and see where it takes you. 😍
Pure magic Shane!
It is great!!
Thanks Juan 🐱🏍
Hey Shane. Excellent video as always! Is there a way to turn this solution into one that will upload to multiple Sharepoint items?
Just solved one my needs. Great video!
Great to hear!
Wow!! FINALLY!! cool! 🤩🤩
One.qs..any way to hide the filenames inside the attachment control?
Change the font color to Transparent :)
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.
Thank you Shane. This is amazing!
You are welcome!
Many thanks❤❤❤
You're welcome 😊
Thanks so much!! This is really great!! Gonna test this out!! Good job!!
Happy to help!
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.
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 czcams.com/video/2gE0e_AsdMw/video.html
Thank you Sir
Most welcome
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.
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)?
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.
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.
Appreciate the insight! great video
Thanks for watching!
Thank you so much Shane!, would this work saving the attachments to a SharePoint List?
Attachments are different czcams.com/video/K74UFYgrKB4/video.html
Awesome job again Shane! Thanks again for all the hard work you put into these videos! I can select and upload multiple files using Windows, however, when I use my app on mobile I can only select one file at a time. Is that a mobile limitation or is there a way around it?
Not sure. I haven’t tried on mobile but wouldn’t be surprised that was just a limitation 😬
@@ShanesCows , thanks for your response. If it is, sure hope it changes in the near future! Thanks again for the work u do!
@@belandry1 Any solution?
@@bierjas not yet
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. :)
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
czcams.com/video/e0kMjb686tc/video.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 czcams.com/video/3QaiM8SeWfM/video.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.
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 czcams.com/video/3QaiM8SeWfM/video.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?
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.
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.
This is awesome, thanks a lot!
You're very welcome!
It's even more than perfect! it's SHMERFECT!!
Love it! 🥰
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, 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. :) czcams.com/video/e0kMjb686tc/video.html
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 czcams.com/video/vpjf5mD-COs/video.html
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 :)
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. 😔
Hi, Thanks for sharing! Really, really usefull!!
You are welcome 🤗
A flawless victory.
Thank you, thank you very much!
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
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?
Thanks Shane happy life.
Thanks 🐶 Have a great week!
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.
Hey, it is me again! Your Videos are godsend and I love your energy.
I've copied the code and all but I'm pretty sure I did something wrong and I am not sure why and where and what... I am fairly new to PowerApps.
It underlined the "Base64" and "Name" and tells me it is expecting an identifier name. Do you have any idea what that could mean?
Thanks a ton - Great stuff! - 'Chewy Says Amazing Job!!!'.. (same expression though.. 😁)
😂🐶
Been running with 24 files @ 50Mb max for quite some time.
Thanks. Good to know
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.
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. czcams.com/video/cjcDH7_v6cE/video.html
@@ShanesCows It worked perfectly. Thanks a ton!
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 :) czcams.com/video/2gE0e_AsdMw/video.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
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. czcams.com/video/QcWjAt7QVn4/video.html Not saying what you want isn't possibl,e just not something I have handy.
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?
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! :)
Shane,
First off - thank you very much for your content. Secondly, how would I go about setting all uploaded documents to be sequentially named using the uploader's username and a time/date stamp (e.g. nk5501_121120200950, nk5501_121220200830 or something similar)?
Thank you again!
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!
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.
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.
Very Nice and Thanks Millions
Happy to help
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 ?
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.
@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! 😩
Makes sense now!
Awesome. That is what I want, everyone to be able to do all of the things. 😀
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
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. czcams.com/video/cjcDH7_v6cE/video.html
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! 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
czcams.com/video/K74UFYgrKB4/video.html
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. :)
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.
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?
Hey Shane! Thank you so much for this video. It has helped a lot!
I have a question though. It worked fine for months, but then a few days ago every file that gets uploaded through it cannot be opened. (Either through the web app or if I download it through the desktop app). Each file has content. I checked the workflow and it still does what it does, but for some reason every file cannot be opened. I checked around and someone else I know has the same issue (started at around the same time) Are you familiar with this and if so, do you know a solution? :) Thank you in advance!
I haven’t heard anyone else having problems with this. 🤨 Hopefully it cleared up for you.
@@ShanesCows Hey Shane, I found the reason. It seems to be connected to using the base64 output as the file content in Create File in Power Automate. When I added the expression there base64tobinary as file content and gave it the base64 that was passed down from the app the files opened normally again. I have no idea though why it worked before and now suddenly stopped working. (Not just in my solution, but that of a friend as well).
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.
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)
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!