web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - Building Flows
Answered

Automating E-mail sending when Excel not modified

Like (0) ShareShare
ReportReport
Posted on 22 Feb 2024 08:02:55 by 13

I have a SharePoint site with Excel sheets which requires people from external organisations to fill in specific data into every month. I would like to create a flow on Power Automate to send e-mail notifications to those external parties if they forgot to fill in their data

 

At the moment, this is what my flow looks like.

 

jkoh_1-1708588914342.png

I am genuinely very new to this platform and I am not sure how to proceed. The flow works whenever the Excel sheet is modified - hence the TRUE works and I receive an email when I run the test. But how do I test the FALSE condition?

I have the same question (0)
  • Verified answer
    lbendlin Profile Picture
    8,246 Super User 2025 Season 2 on 28 Feb 2024 at 02:08:15
    Re: Automating E-mail sending when Excel not modified

    You are doing great.  Inside the Apply to each add a yes/no control.  In the condition test if the file date is older than x days. Put the email sending in the yes branch.  you can leave the no branch empty.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 736 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 396 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 339

Last 30 days Overall leaderboard
Loading complete