Hello team,
I have come across a requirement where we need to send multiple emails to list of recipients (50+) :
1. Email body contains a data table which we get from Excel files
For 50 recipients, we have 50 different excel files created (using VBA) and we need to get table from each excel file to paste in email body.
For example take a look at below email :
I have maintained User emails in excel file. But, I am still to figure out how to get data table from excel files pertaining to specific User.
Highly appreciate your ideas and help.
#Power Automate flow
Hey @AJ_vizMan
Try the technique mentioned in the following video:
https://www.youtube.com/watch?v=tp0jLnmKcEs
So firstly take out the emails, then find the unique emails with the help of union, then do apply to each on that emails. And after that use filter array to take specific table values related to that email and then send email.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional