Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Send an email to the email address found in excel using power automate


I am struggling to get the output that I want for this example:

so this is how my excel file looks:



basically, I want to create a power automate that will:

1. send 1 email to the specific email in the email column

2. the email address will only get those information that are theirs


so the output of the email is, for example I only want to send those with 3 days left to respective emails from the above data

email: will receive this table in their email

3ABC co789
3ABC co987


I have tried a flow for this but it ends up sending the information of the other email address as long as the daysleft is 3

so from the first table, this is what is receiving:

3ABC co789
3ABC co987
3DEF co876
3DEF co765


this is my flow. I made the union so that only 1 email is sent to the email mentioned in the email column in the first table above.

If I do not do that, it will send one email per row to the same email address. However, with this the above mentioned 3rd table is sent to the respective email. Hope you can help, I am not sure if I am missing any filters so that only those items to the respective email will be sent.


flow for excel.JPG


I think you can achieve this using similar logic as described in this answer. 

You'd need Office Script to generate a simple array/object containing the summarized set of data as JSON and use that in the send email action.


hi @sumurthy ,

thanks for your advise. However, is there another way for this like a filter maybe in power automate? I'd like to take that route as it is a bit challenging for me to do the office scripts. Thank you!

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (938)