sending attachment though power apps to power automate but data is incomplete

Like (0) Share

Report

Posted on 31 Dec 2023 11:01:12 by GTurkistane

114

I made an app that uploads its attachment to Power automate so that I can send it to an email as an attachment, here is the formula am using to get attachment data:

Set(data, JSON(Image3.Image, JSONFormat.IncludeBinaryData));

Collect(rawdata, {contentBytes: Mid(data, Find(",", data)+1, Len(data) - Find(",", data) -1), name:Last(Ducements.Attachments).Name});

and here is how it is sent to the flow:

SendEmailAttV2.Run(JSON(rawdata));

here is the flow am using to process the data nd send it in an email:

Schema:

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "name": {
 "type": "string"
 },
 "contentBytes": {
 "type": "string"
 }
 },
 "required": [
 "name",
 "contentBytes"
 ]
 }
}

upon receiving the email, i can not open any of the attachment saying that it is corrupted, they all have correct names and types, here is the flow run:

NOTE: i am required that i send the emails from power automate and can not just simply send it from power apps

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on 31 Dec 2023 at 11:51:04

Like (0)

Report
Re: sending attachment though power apps to power automate but data is incomplete

Hi @GTurkistane ,
After doing a Parse JSON, we can now use it in a loop and then using the “Convert” action, we will convert the “ContentBytes” property from Base64 to Binary using the following code.

@{base64ToBinary(items('Apply_to_each')['ContentBytes'])}

After doing a conversion, we will now append this value to our array along with the filename.

Best Regards,
Sunshine Gu