Add entity image (entityimage) to attachments array

[Anonymous]

Hi Power Automate Community!

I'm putting the final touches on a Flow and I'm having some troubles with an image. Since everything else in the Flow is working properly, I'm goingo to focus on this part. If you need any more details feel free to ask for them though!

I have an entity called Expenses with a field called entityimage. In my flow I have an array of attachments called ImageArray (though it contains an Excel file + some images). This attachments are then sent to an email account. However, the images are sent but corrupted and can't be displayed.

The contents are:

{
  "Name": "image_@{variables('ImageCounter')}.png",
  "ContentBytes": {
    "$content-type": "image/png",
    "$content": @{items('Apply_to_each')?['entityimage']}
  }
}

Any help would be great! Thanks in advance.

[v-litu-msft]

Hi @Anonymous,

If you want to send these image through Email attachments, the array should as below:

"value": {
     "Name": "@{items('Apply_to_each')?['{FilenameWithExtension}']}",
     "ContentBytes": "@{base64(body('Get_file_content'))}"
}

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

[Anonymous]

Hi @v-litu-msft,

Your approach doesn't work for me. The image doesn't come from a Sharepoint list, but from a CDS entity that I'm looping through.

Here's a broader view:

[v-litu-msft]

Hi @Anonymous,

What's the error report when you execute the Flow?

And how do you store these images into CDS entity?

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

[Anonymous]

Hi @v-litu-msft,

The error doesn't show on Power Automate, but on the image itself when I try to download or preview from Outlook (format not supported).

The image is stored in a CDS entity record from Power Apps and it's ok because I can send it if it's the only file attached, but not in an array of attachments. I think that's where the issue is but can't see why is not working.

[v-litu-msft]

Hi @Anonymous,

Well, I reproduced the Flow you created, get the image from an image field of CDS and send an email, and it works well. 

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

[Anonymous]

Hi @v-litu-msft,

Does it also work if the array of attachments contains another type of file? For example my array always contains an Excel file and 0, 1 or more images.

Thank you.

Edit: I just tried the array without appending the Excel file and it didn't work either. Seems like there's a a problem with the images in an array since I can put attach them to an email separately (different emails, not the desired/expected behaviour though). Any thoughts on this?

[Anonymous]

Update on this if anyone is interested:

The Flow was built and triggered from Power Apps, since now you cannot import external Flows into Power Apps (the ones that are not created via Power Apps > Action > Power Automate > Create a new flow). I couldn't get it to work and it was not clear why.

I reproduced the Flow but I built it outside Power Apps. Everything else is the same but I just trigger it manually (doesn't fit my client needs but it was nice for a test). And it works. The same Flow can't send an array of Images (the byte content is the same) inside Power Apps but it can outside of it.

Is this a known bug? Should I report it?