Send email base on date that are overdue

[David1966]

Hi i new to power automated and trying to have a power automated email me when a date on a spreed sheet become overdue i have follow a YouTube guild that work but it only sent email on the date it was due date not overdue dates but now after redoing the power automated i get a error is this a error in the power automate or my spreed sheet thanks.

formatDateTime(convertFromUtc(utcNow(), 'E. Australia Standard Time'), 'yyyy-MM-dd')

[ManishSolanki · Accepted solution]

Hi @David1966 

Pls add a blank or white space after eq operator in filter query.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[David1966]

How would i go about making my flow email overdue dates in a spreed sheet?

[ManishSolanki]

Hi @David1966 

Pls refer the below flow:

Input Excel Sheet:

Flow action after "List rows present in a table":

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[David1966]

Yes i have it working but the problem is it only sends a email with the due date on that day but misses the overdue dates 

[ManishSolanki]

Hi @David1966 

In that case, we can use less than or equals 'le' operator in place of 'eq' operator:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[David1966]

Thanks again for your help when i put "le" get below error.

would it be a better way if i just have it look for changes in the "Status" column for EXPIRED and EXPIRE SOON then send email if so can you recommended a good guide or point me in the right direction thanks.