web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send emails based on E...
Power Automate
Unanswered

Send emails based on Excel Table when a file is updated

(0) ShareShare
ReportReport
Posted on by 91

Hi,

I am after some advice on the best way to build a flow for sending emails from data in an excel table. To explain, this would be the process:

1. Excel file is saved, which overrides previous data (each month a new report will be uploaded and saved over previous version) 

2. In the report, where there is no contact number in 'Telephone number' column, send an email to the email address listed for that contact. 

 

Further to this, when the file is saved, is there a way to make sure the data is made into a table automatically without manually going into it to select the data.

 

Thanks in advance! 

 

 

Categories:
I have the same question (0)
  • eliotcole Profile Picture
    4,388 Moderator on at

    Hi, @MB35, would you be able to show us what you have tried so far?

     

    Just embed (not attach, as many cannot download) some screenshots of your flow from the designer view. It will assist those who want to help in having context, and those with the same question that they're in the right place. 🙂

     

    ---

     

    Quite separately, have you considered moving this data (and the inputting) into a SharePoint list? The data points really sound like they'd be much better off living there. 🙂

  • MB35 Profile Picture
    91 on at

    Hi @eliotcole 

    At the minute I've not got my flow written, I'm trying to figure out the best type of flow and actions to use. 

    Unfortunately the file will be excel as it is an extract from another system so ideally just working from that to save the need of creating a sharepoint list as one would not be required to be kept for this task.

     

    My initial thoughts were:

    * When an item or file is modified

    * Run Script to create a table in the excel 

    * list rows present in a table to include filter query of Telephone number eq null

    * apply to each

    * send email

     

    Does this sound possible?

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard