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:
Desired Output (1) and (2) showing below:
