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

[Medoomi]

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!

[Medoomi]

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 · Accepted solution]

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

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

[abm · Accepted solution]

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

[abm]

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

[Medoomi]

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

[Medoomi]

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.

[Azee]

Not working it gives error syntax error near at _objectid_value eq ...... at this line it gave error

[abm]

Hi @Azee

Could you post a screen shot of your flow and error?

Thanks

[Azee]

I got it fix but really thankful to you, your tutorial save my life, as my flow required condition that only send attachments when more then one are added to notes, therefore using if condition i got it fixed 

[abm]

Hi @Azee

Thanks for letting me know.