Answered

Canvas App & Dataverse - How do you read email attachments?

(0) Share

Report

Posted on by Maciej Pokrzywinski

Hi Community!

I have a Canvas App to prepare in which I am displaying emails from Dataverse. For the current displayed email message, I also want to display a list of attachments. The attachment list should display the name of the attachment, an icon (Or a small preview) of the attachment, and have the functionality to open the attachment in the Preview window. How can I achieve this? So far I have found two partial ways:

Way #1 - The email message record has a FileAttachments attribute which stores some information. However, I cannot find documentation about it, nor can I find a way to open such an attachment in preview
Way #2 - The Attachment table (activitymimeattachment EntityType (Microsoft.Dynamics.CRM) | Microsoft Learn) stores information about attachments, but it only stores attachment metadata, not the attachment itself

Do you know a way to implement this requirement?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MaciejPokrzywin ,

You are close. The attachment's content is stored in the attachment table.

They are base64 string.

If you want to show the pdf attachment in canvas pdf viewer control, please try this

Best Regards,

Wearsky
Maciej Pokrzywinski 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft, thanks for your reply! One step closer to achieving my goal. Unfortunately, I'm running into another obstacle. The field: "Body" from the attachment table (ActivityMimeAttachment) is not available in the Canvas App. However, as far as I can see this only happens on my environment (On a completely new environment I managed to map what you have shown). I will already report this problem to Microsoft support. Thanks for your help!