Unanswered

Send email with attachment from Dataverse

(0) Share

Report

Posted on by Xinlin

Hi,

I have a PowerApps that is used to submit form to Dataverse and there's an attachment column in the form. I need to send email notification with the said attachment. I tried multiple workarounds but it doesn't seem to capture my attachment and send it out through email.

Appreciate to get insights on the challenges I'm facing now. Below listed my trials as reference. Thank you in advanced!

- Workaround 1: attach the Dynamic Content of 'Attachment' directly in the email template

- Workaround 2: Initiate array variable with base64ToBinary(items('Apply_to_each_2')?['crf38_attachment']) in Each filename and content

- Workaround 3: Initiate array variable with array(triggerOutputs()?['body/crf38_attachment']) in Each filename and content.

Here is the output of flow that didn't manage to capture my file attachment.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Xinlin

You will want to use the Dataverse action "Download a file or an image"

Was this reply helpful? Yes No
Xinlin 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried with Download a file or an image too and got an error

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Xinlin

This error and the Json you pasted indicate that there is no parent record (recordId).
You should check the data in Dataverse.

Was this reply helpful? Yes No
Xinlin 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I might encounter with an issue in Dataverse that not manage to capture my attachment properly. Correct me if I'm wrong, the file name and type (eg.pdf) should be shown in the attachment column, right? But I'm just getting a 'file' instead.
Thank you.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Xinlin

Could you please show the screenshot of your flow.

I think this link will help you a lot:

Get Files from File Column in Data Verse using Pow... - Power Platform Community (microsoft.com)

Best Regards,

Levi

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Xinlin

So, this picture is from Dataverse? The attachment column is not what your looking for. Dataverse has a file type column. Attachments are used for other scenarios (Not like SharePoint).

Was this reply helpful? Yes No