Power Apps Attachment input to Power Automate Email attachment

[GFinlayTerumo]

I have a Power App which the user attaches files into and part of the submit function then sends an email to a defined list of users with those files as the attachment.

Currently the Power Automate sends the files with incorrect contents, they have the raw JSON data.

Attachments control in Power App

Code for converting the attachments to a collection then running the Power Automate, converting the Collection to JSON Binary Data

Collection with the attachments

Power Automate solution getting the files and defining the array

Parsing JSON

Placing the files into the array, this seems to be where the problem is, I think the DataStream needs converted but I don't know how.

This is what the email attachment files are sent as, I know I need the data after the base64, but I don't know how to define that from what is in the Parse JSON action.

Is there another way to do it or can I have a variable that gets the bas64 data from the DataStream output?

Thanks

[GFinlayTerumo · Accepted solution]

Figured it out by using 

dataUriToBinary(items('Apply_to_each_3')['DataStream'])

[alrez]

Hi,

Thanks for your follow up post! I am glad that you were able to resolve your issue. Hopefully this will prove useful for future communities users.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @GFinlayTerumo, thanks for posting your solution here. I'm facing the same issue. I'm uploading file from my PowerApps, but I don't quite know how to implement your process. Is it possible to explain it in more details?

Thank you so much for your time

[GFinlayTerumo]

Hi

If you place the dataUriToBinary(items('Apply_to_each_3')['DataStream']) into the ContentBytes section of the Append to array variable hopefully it will work for you as it did for me.

Thanks

[Anonymous]

Thank you! I'd like to ask you what is the process to convert an attachment with the edit form from blobmanager to contentbyte. How did you convert a file in byte in powerautomate?

Thank you in advance

[GFinlayTerumo]

Hi I did not use blobmanager for this process.  The second image in my original question shows how I collected the attachment data as JSON and then parse through it within Power Automate.

Thanks

[Anonymous]

In my case I'm trying to import file from my local device. I found out I can use the trigger PowerApps(V2) and get the contentBytes from the Body, but it does not work when you have N attachments. They're all imported as blobmanager file in my powerapps