Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Send an email if an excel file has been modified

(0) ShareShare
ReportReport
Posted on by 101

Hello,

 

I'm trying to create a flow that informs users if an excel file is present in a sharepoint library
has been modify.


If the file has been modified an email is sent at 7 a.m. otherwise nothing is sent

At first I wanted to start with a sharepoint trigger but I'm stuck with the timeout.

 

How to set up a library scan every day at 7 a.m. and if the file has been modified
an email is sent?

 

Thank you

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Send an email if an excel file has been modified

    @Edvhdy  you are welcome friend

  • Edvhdy Profile Picture
    101 on at
    Re: Send an email if an excel file has been modified

    @ChristianAbata  Thank you for your precious help !

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Send an email if an excel file has been modified

    excellent @Edvhdy  please mark as solution the parts you consider could help to other users 😉

  • Verified answer
    Edvhdy Profile Picture
    101 on at
    Re: Send an email if an excel file has been modified

    I think I succeeded,

    This is how I did it:
    1st flow:

    When a file is created or modified (properties only)
    Get files (properties only)
    Apply to each - value - Create item in list A


    2nd Flow:
    Recurrence
    Get items
    Condition - empty (body ('Get_items')? ['Value']) is equal to false
            yes - send email and delete items to make the list A empty

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Send an email if an excel file has been modified

    hi @Edvhdy  please follow this example

     

    schedule.PNG

  • Edvhdy Profile Picture
    101 on at
    Re: Send an email if an excel file has been modified

    hi @ChristianAbata ,

     

    I thought of making your solution,

    I did create my first flow https://ibb.co/5sVwqts , but I don't know how to make the second flow, how do I compare?

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Send an email if an excel file has been modified

    hi @Edvhdy  you can use two flows, one to capture the modify propertie and save that into a sharepoint list. A second flow schedule that runs in the time you need and read the sharepoint list that contents your data about files modified and filanny notify by email 🙂

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1