cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Medoomi
Helper V
Helper V

Is it possible to send multiple Dataverse attachments on a single email

I have been looking at the workflow Sunay Vaishnav posted at this link to send multiple Sharepoint attachments on a single email:

https://powerautomate.microsoft.com/en-us/blog/multiple-attachments-single-email/

This centers around using Sharepoint & uses the "Get attachments" and "Get attachment content" actions to build an array of file attachments.

Is it feasible to think the same process could be used to retrieve multiple Dataverse file attachments? I'm worried that the available actions for Dataverse are more limited than those available for Sharepoint...

Any input would be hugely appreciated!

2 ACCEPTED SOLUTIONS

Accepted Solutions
abm
Super User
Super User

Hi @Medoomi 

 

Use the list rows action step to read from Notes entity and filter the rows by GUID of the record (_objectid_value eq GUID)

 

Next collect all the attachments in below format

 

image.png

 

Above expression is 

base64ToBinary(items('Apply_to_each_2')?['documentbody'])
 
Append the above compose into an Array. That means all the attachments will be in an array collection
 
Finally set the array variable under the Send Email action step.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

abm
Super User
Super User

Hi @Medoomi 

 

I have made a tutorial video for this. Please see this video and description where I mentioned the expression I used in my flow.

 

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

 

Hope its useful. Let me know if you need any further help in this.

 

Thanks

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

6 REPLIES 6
Medoomi
Helper V
Helper V

Does anyone have insight on this--Ideally I would like to create a flow which retrieved two attachments from a single Dataverse record, and sent them in a single email.

Is this possible with the current Flow actions?

abm
Super User
Super User

Hi @Medoomi 

 

Use the list rows action step to read from Notes entity and filter the rows by GUID of the record (_objectid_value eq GUID)

 

Next collect all the attachments in below format

 

image.png

 

Above expression is 

base64ToBinary(items('Apply_to_each_2')?['documentbody'])
 
Append the above compose into an Array. That means all the attachments will be in an array collection
 
Finally set the array variable under the Send Email action step.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @Medoomi 

 

I have made a tutorial video for this. Please see this video and description where I mentioned the expression I used in my flow.

 

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

 

Hope its useful. Let me know if you need any further help in this.

 

Thanks

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @Medoomi 

 

If you need any further help please let me know.  If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Medoomi
Helper V
Helper V

thanks @abm  , will do. I have yet to implement, but should be able in the next few days 🙂

Medoomi
Helper V
Helper V

Thanks so much again @abm ,

I've been able to implement the solution & adapt it to my needs. I really appreciate you breaking it down like you have. The video was very helpful.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,447)