Answered

Automating E-mail sending when Excel not modified

(0) Share

Report

Posted on by jkoh

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.

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?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

You need to use a schedule trigger (for example daily), and then compare the last modified date for the excel file to today's date. If the difference is more than x, send a reminder.

Was this reply helpful? Yes No
jkoh 13 on at

Like (0)

Report

Hi @lbendlin , thank you for your reply.

Given my limited knowledge in Power Automate (only started using it 2 weeks ago), I am not quite sure how to proceed with this. Here is what I have right now though. Would be great if you could provide an example/guidance.

Was this reply helpful? Yes No
Verified answer

lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
jkoh 13 on at

Like (0)

Report

Thank you for the encouragement @lbendlin !
Do you mean doing it like this?
I inserted the email sending in the NO branch as I would like the email only when the file is not modified (date is modified less than the start of the day - my filter query below)
Does this seem correct?

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

looks good to me - test it and see how it behaves.

Was this reply helpful? Yes No
jkoh 13 on at

Like (0)

Report

Here's the message I received from the test - hence i did not receive the email despite the selected folder not being modified
Should I be doing anything with the condition expression?

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

wait, did the filter query work? Then you wouldn't need the choice control.

Was this reply helpful? Yes No
jkoh 13 on at

Like (0)

Report

Ah yes, it did work. Thank you so much for your help! You've been a God send.

Was this reply helpful? Yes No