Forum Discussion

Mona_Alsayed's avatar
Mona_Alsayed
Copper Contributor
Apr 08, 2024

Power automate to bulk emails

Hi there,

Using Power Automate to pull information from Excel, is there a way to perform the below?

*( I know that there are current Microsoft work plugins ins that can perform this, but I need to do this with Power Automate if possible. Colleagues in the team are finding it difficult to use those plugins or troubleshoot any encountered error, so I thought power automate shared flow will be easier since they won't need to perform anything.)

I want to create a workflow to bulk emails to users in a spreadsheet. One user might have multiple rows in the spreadsheet, so they should only receive one email at the end. The information is sent to users in a table inside the email body, so this table should be automatically adjustable based on each user's rows in the spreadsheet.

Below are some data from a dummy Excel sheet and what the bulked emails should look like.

I would really appreciate any help in this regard.


Many thanks in advance.

 

Dummy data:

Dummy data

 

Desired Output (1) and (2) showing below:

Output 1Output 2

No RepliesBe the first to reply

Resources