Awesome hack using the image control with the attachment control. Can't believe this isn't base in powerapps, but at least I can use this workaround! Thanks for putting this out.
hello paul... thanks for the video... cant figure out the parse jason section how u defined that schema... can u plz explain in details for a beginner like me? and also how to save it in sharepoint list
For anyone who wants to make so that the formula would save the file name, just do this: 1. Add a label to the canvas. 2. In the formula spacebar of the label write Concat(DataCardValue.Attachments, Name) 3. In the formula bar for the button your using for SharePoint upload write JSONUpload.Run(JSON( { Name: "Label Name".Text, File: "Image Name".Image }, IncludeBinaryData)) If you do this you can save both the file name and the file contents to the flow.
Hey Paul, thank you for this great tutorial, for beginners like me :) I understood the most of your explanation and got it to work. But the JSON part in the flow brings me to desperation. Ican`t find/create this step, could you give me a clue how to do this step? Best wishes from Germany, Frank
Hey Paul... Would this work for saving to a SQL table? If so, how would you retrieve the files from SQL so that you could open those files when the record is opened in PowerApps? Is there some way to repopulate the attachment control? Could a gallery be used in some way to reconstitute the files into PowerApps?
Hi Paul. Fantastic video thanks. I'm trying to use your 'audio' code, and if I use it 'exactly' as you describe here it works! But if I replace the 'File: Microphone1.Audio' with 'File: Audio', where 'Audio' is a field name in a collection of Microphone1 recordings. So the collection 'Field: Audio' is save as Audio: Microphone1.Audio. Why does this method fail when I get the Microphone1.Audio from a collection? Much appreciated for your help...
Hi Paul, thanks for the video. If I use the JSON formula I get a string starting with data:image instead of data:application which (I assume) causes that the files are not saved properly to SP. They are visible in the SP document library but I can't open them. Any idea why this is happening? Thanks!
Is anyone familiar with the JSON action in this flow? I'm brand new to Power Automate/Power Apps and when I click on "New Step" in my Power Automate flow, I can't find an option for a JSON action like the one in the video. Maybe it's custom made?
I Feel like i'm missing something where do i get the JSON Value? i found it in Expression but it looks empty am i supposed to know what to add in there? could you send me your copy so i can backwards decode what you did?
I did this by adding the JSON data to a collection then running the flow on each row of the collection using forall. There's probably a way to send all of the attachments as JSON then parse in Flow but that worked for my purposes.
Hi sir , u have shown the actual function on each button for other 3 types except the last one , can u please ping the function from the last send to sp button, I am getting an error unable to process template language
Hi Paul, you've shared a great vidoe the but how do you save an audio file (.aac and .3gp) into sharePoint List using mobile devives (Android and IOS)? It looks like your video is only applied to .OGG (using web browser). By the way, I managed to record an audio using IOS device and try to play the .aac Audio file (outside of powerapps) and none of well known audio players can play the audio. Any feedback?
Extended Hack: If you want to then show the attached file in the same control, you can do a hack to show the files from the library. First:Add a connection to the destination document library to your app. Then paste this in the Items property of the attachments control: {'{FilenameWithExtension}':"Filename",'{Link}':"Link"} This presets the fields that the control will show, since the Name and Value selectors are not-editable in the control. You could change it to reflect different columns from the doc library. Then, edit the Items property again to a filter for your document library connection with a filter to get the appropriate documents. The fields set in the previous step will persist, if they exist in the next set datasource. The uploaded document will show as an attachment in the control. To go a step further. Have the Flow return a value to to powerapps and set a variable with the output; this lets the flow finish before powerapps resumes, and allows you to put a refresh after the flow call to update the document library connection.
Not sure if you already know but your voice audio is only on the right ear track. Makes it difficult to listen to as I have headphones and a L/R wired speaker setup so either it sounds like you're over my shoulder talking, super distracting.
I thought this is helpful. :( I hope those who would like to help people would show the full page of their videos -- and maybe you should put in your description that this is not for newbies.
Awesome hack using the image control with the attachment control. Can't believe this isn't base in powerapps, but at least I can use this workaround! Thanks for putting this out.
Would you be able to share the dataUriToBinary code you used? Thanks!
hello paul... thanks for the video... cant figure out the parse jason section how u defined that schema... can u plz explain in details for a beginner like me? and also how to save it in sharepoint list
Paul, your video is the best ! Thank you
Please, can you share the full Expression in File Content Step? 🥲
HI Paul Great video!! what would you do to attach any of these to a sharepoint list with flow?
For anyone who wants to make so that the formula would save the file name, just do this:
1. Add a label to the canvas.
2. In the formula spacebar of the label write Concat(DataCardValue.Attachments, Name)
3. In the formula bar for the button your using for SharePoint upload write JSONUpload.Run(JSON( { Name: "Label Name".Text, File: "Image Name".Image }, IncludeBinaryData))
If you do this you can save both the file name and the file contents to the flow.
HI Paul. Would you do the same video but with PowerApps (V2)? Thanks a lot
Great Video, As always. Also that intro music is top class.
Hey Paul, thank you for this great tutorial, for beginners like me :) I understood the most of your explanation and got it to work. But the JSON part in the flow brings me to desperation. Ican`t find/create this step, could you give me a clue how to do this step? Best wishes from Germany, Frank
The JSON action is actually just an Initialise Variable action that has been renamed to "JSON"
I didn't undertand that part :(
OMG!!!!!! so simple when you know how. that appres thing was killing me!
Hi Paul, Could you show how to do the Audio upload from a Collection of saved Microphone recordings? Thanks...
Paul, great video. Is there any way to save an ID number with the file so it can be referenced from another SP list?
Hey Paul... Would this work for saving to a SQL table? If so, how would you retrieve the files from SQL so that you could open those files when the record is opened in PowerApps? Is there some way to repopulate the attachment control? Could a gallery be used in some way to reconstitute the files into PowerApps?
a question, will you know how to block the option to delete attachments?
Hi Paul, I cant save the file with the Attachment control with the formula in the video, pease help
Hi Paul. Fantastic video thanks. I'm trying to use your 'audio' code, and if I use it 'exactly' as you describe here it works! But if I replace the 'File: Microphone1.Audio' with 'File: Audio', where 'Audio' is a field name in a collection of Microphone1 recordings. So the collection 'Field: Audio' is save as Audio: Microphone1.Audio. Why does this method fail when I get the Microphone1.Audio from a collection? Much appreciated for your help...
Hi Paul, thanks for the video. If I use the JSON formula I get a string starting with data:image instead of data:application which (I assume) causes that the files are not saved properly to SP. They are visible in the SP document library but I can't open them. Any idea why this is happening? Thanks!
Is anyone familiar with the JSON action in this flow? I'm brand new to Power Automate/Power Apps and when I click on "New Step" in my Power Automate flow, I can't find an option for a JSON action like the one in the video. Maybe it's custom made?
The JSON action is actually just an Initialise Variable action that has been renamed to "JSON"
Great workaround Paul!
Paul, instead of uploading the entire excel document, can I append the content of uploaded excel file - in table format - to a existing SP list?
Well done, Paul!
Paul, how get Scheme in Parse Json?
Super helpful. Definitely going to use this.
Hi,
I didn't get how you changed the appres to dataUri.
I need that.
Thx
I Feel like i'm missing something where do i get the JSON Value? i found it in Expression but it looks empty am i supposed to know what to add in there? could you send me your copy so i can backwards decode what you did?
Hi Paul, did you ever get to post a video on multiple attachments?
I did this by adding the JSON data to a collection then running the flow on each row of the collection using forall. There's probably a way to send all of the attachments as JSON then parse in Flow but that worked for my purposes.
Hi sir , u have shown the actual function on each button for other 3 types except the last one , can u please ping the function from the last send to sp button, I am getting an error unable to process template language
Could i also send an attachement per E-Mail instead of sending it to Sharepoint?
Hi Paul, you've shared a great vidoe the but how do you save an audio file (.aac and .3gp) into sharePoint List using mobile devives (Android and IOS)?
It looks like your video is only applied to .OGG (using web browser).
By the way, I managed to record an audio using IOS device and try to play the .aac Audio file (outside of powerapps) and none of well known audio players can play the audio.
Any feedback?
For the peninput i got an error say invalid template is there a something that i miss out?
EPIC! as usual. I have a question on the attachment, is it possible to add multiple attachments?
I just worked out how to do it... follow up video this weekend I hope
Great Stuff. Thank you for this video
Extended Hack: If you want to then show the attached file in the same control, you can do a hack to show the files from the library.
First:Add a connection to the destination document library to your app.
Then paste this in the Items property of the attachments control:
{'{FilenameWithExtension}':"Filename",'{Link}':"Link"}
This presets the fields that the control will show, since the Name and Value selectors are not-editable in the control. You could change it to reflect different columns from the doc library.
Then, edit the Items property again to a filter for your document library connection with a filter to get the appropriate documents. The fields set in the previous step will persist, if they exist in the next set datasource.
The uploaded document will show as an attachment in the control.
To go a step further. Have the Flow return a value to to powerapps and set a variable with the output; this lets the flow finish before powerapps resumes, and allows you to put a refresh after the flow call to update the document library connection.
Thanks so much! You are the best!
Brilliant. A magnificent significant achievement.
Can anyone help to share the full expression? :(
Great video. Thanks for sharing
Has anyone gotten this to work with the pen input?
AMAZING HACK BRO!
Nice... Thanks for sharing!
Works. Thanks
Thanks! ¡Gracias!
Not sure if you already know but your voice audio is only on the right ear track. Makes it difficult to listen to as I have headphones and a L/R wired speaker setup so either it sounds like you're over my shoulder talking, super distracting.
You r god.........love it 80000000
Wizardry!
I thought this is helpful. :( I hope those who would like to help people would show the full page of their videos -- and maybe you should put in your description that this is not for newbies.