cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diepic
Resolver II
Resolver II

send an e-mail with attachment retrived from a column of a dataverse table

Hi all,

in first picture  I've a table with a column with file to attach

diepic_1-1663771870947.png

how can I retrive name or other data need to insert in the fields of the 2nd picture?

diepic_2-1663771918238.png

 

thanks for any help or suggestion

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
diepic
Resolver II
Resolver II

I've solved by myself and this is the that for my flow in Dynamics 365 sales and dataverse is working:

1 - when e row is updated and respect filters, "Get a row from ID" from 3 different tables.

diepic_1-1663929131935.png

2 - with references from the 2nd "Get a row from ID", I've inserted "Download a file/image" with the "unique ID" of this table and the "column name" that store the file to attach to my mail

diepic_2-1663929207018.png

3 - finally in the parameters of the mail:
in "attachment" I've inserted the output of the "downolad" viewed in the previous step and in the "Name of attachment" a field expression with data of the 2nd tabel ("Get a row from ID" - ATH-Doc_Opportunita) and the name of column that contain the file to attach to this mail.

diepic_3-1663929519236.png

hope this can help someone

 

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @diepic ,

 

Please try to use 'download a file or an image' action.

vxiaochenmsft_0-1663831919284.png

vxiaochenmsft_1-1663831951775.png

 

Best Regards,

Wearsky

Hi @v-xiaochen-msft thank you for your reply.

I try as your example, but this is the error that return:

diepic_0-1663858113409.png

I've data [File Allegato] (that is 'File Attachment') in trigger not in 'Get row by ID'

 

 

diepic
Resolver II
Resolver II

I've solved by myself and this is the that for my flow in Dynamics 365 sales and dataverse is working:

1 - when e row is updated and respect filters, "Get a row from ID" from 3 different tables.

diepic_1-1663929131935.png

2 - with references from the 2nd "Get a row from ID", I've inserted "Download a file/image" with the "unique ID" of this table and the "column name" that store the file to attach to my mail

diepic_2-1663929207018.png

3 - finally in the parameters of the mail:
in "attachment" I've inserted the output of the "downolad" viewed in the previous step and in the "Name of attachment" a field expression with data of the 2nd tabel ("Get a row from ID" - ATH-Doc_Opportunita) and the name of column that contain the file to attach to this mail.

diepic_3-1663929519236.png

hope this can help someone

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,525)