Answered

Automating E-mail sending when Excel not modified

Like (0) Share

Report

Posted on 22 Feb 2024 08:02:55 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?

All responses (8)

Answers (1)

jkoh 13 on 28 Feb 2024 at 03:21:56

Like (0)

Report

Re: Automating E-mail sending when Excel not modified

Ah yes, it did work. Thank you so much for your help! You've been a God send.
lbendlin 8,101 Super User 2025 Season 2 on 28 Feb 2024 at 02:58:26

Like (1)

Report

Re: Automating E-mail sending when Excel not modified

wait, did the filter query work? Then you wouldn't need the choice control.
jkoh 13 on 28 Feb 2024 at 02:41:45

Like (0)

Report

Re: Automating E-mail sending when Excel not modified

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?
lbendlin 8,101 Super User 2025 Season 2 on 28 Feb 2024 at 02:36:10

Like (0)

Report

Re: Automating E-mail sending when Excel not modified

looks good to me - test it and see how it behaves.
jkoh 13 on 28 Feb 2024 at 02:20:23

Like (0)

Report

Re: Automating E-mail sending when Excel not modified

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?
Verified answer

lbendlin 8,101 Super User 2025 Season 2 on 28 Feb 2024 at 02:08:15

Like (1)

Report

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.
jkoh 13 on 28 Feb 2024 at 01:56:18

Like (0)

Report

Re: Automating E-mail sending when Excel not modified

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.
lbendlin 8,101 Super User 2025 Season 2 on 22 Feb 2024 at 15:52:06

Like (1)

Report

Re: Automating E-mail sending when Excel not modified

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.