Can ( Dataverse Data Type File ) be used with Power Automate ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Guru !

I want to know if I can use dataverse ( Data Type : File ) with Power automate to send an email with attachment ?

GOAL :

I upload a file into Dataverse, the power automate triggers and send an email with the attachment to Mr X ?

If yes, can you guide me ?

I also understand that there is a limitation to like 1 attachment... ( Might not be the good solution but I'm very curious into the question )

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Please have a look at my video tutorial. You may need to change the trigger accordingly.

Power Automate - How to Retrieve Multiple Attachments from Dataverse & Send Email? - YouTube

Thanks

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Please ignore my earlier reply I have realised that you were asking the file type instead of notes.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Bump, anyone ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous :

Do you want to send a file as an attachment to someone after it has been uploaded to the File field of a table in the dataverse ?

If so , you could use 'Download a file or an image' to get the file content and then sand an email. But there is a difficulty, that is, flow cannot directly obtain the file name of the file in the file type field, so the created attachment cannot get the correct suffix dynamically. In order to solve this problem, my suggestion is to add a text type file name field.

Here's a thread describing the problem and offering a workaround:(Flow to download file from dataverse record and send as email attachment).

Here is my flow:

Best Regards,

Bof

Was this reply helpful? Yes No