You’re offline. This is a read only version of the page.
Announcements
I have a excel table something like below:
Task Name, Duration, Status, Name, Email
Task 1, 20, Open, ABC, abc@xxx.com
Task 1, 20, Open, PQR, pqr@xxx.com
Task 1, 20, Open, XYZ, xyz@xxx.com
Task 1, 20, Open, ABC, abc@abc.com
Task 1, 20, Open, PQR, pqr@xxx.com
Task 1, 20, Open, XYZ, xyz@xxx.com
I am using Power Automate Desktop flow and i am able to send loop through each record of the excel and send an email for the Open Tasks.
What I want to do is: Send 1 email to each resource calling out the tasks open form them with additional details in the row. So, in this case Desktop flow should send 3 email to ABC, PQR and XYZ respectively.
Any help ?
We have a couple of posts on this logic, so I’ll give you the short version.
First, sort by email. Then…
create list called attachments
for each row
set current email to email in row
set next email to email in next row
add attachments from current row to list attachments
if next email <> current email, then send email with list attachments
endif
end loop
this will loop through each row adding the data that you need to a list and then you can send one email with the entire list once it knows that the next row is not going to be the same email address. If the next row is the same email address, it will skip writing the email and move to the next row to add more to the list.
Share
Report
All responses (
Answers (
5,727
