Send a email if an excel Online file is not updated

[Yakine]

Hi everyone,

I'm trying to build a flow that send a reminder email if the excel online file is not updated after 7 days. I got stuck in the last step, what should I write as condition to make it mork ?

 

Thank you,

[efialttes]

Hi!
GetPastTime() can do de magic you need
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#g...

Please have a look to this example
https://powerusers.microsoft.com/t5/General-Power-Automate/Filtering-quot-Get-Items-quot-by-Modified...

Hope this helps

[Yakine · Accepted solution]

Thank you @efialttes 

I found a response to my own question 😄

Below the condition, I created to make it work:

addHours(utcNow('yyyy-MM-ddTHH:mm:ssZ'),-6)

I did some test and it seems working for now!

Y 

[efialttes]

@Yakine 

Thans for taking some extra time to describe the solution you fould by your own! ¡I'm sure it will help others in the future.

You guys make this community great!!