Sent Reminder Email if Date Column is blank after xx days

(0) Share

Report

Posted on by Community Power Pla...

Hello dear Power Automate Community,

I am looking for two solutions on my problems.

1. There should be a reminder email sent out if a certain date column is blank after 30 days.

After this the reminder should be sent out weekly.

2. A reminder email should be sent out if the date column above is filled out but a second one is not filled out afterwards within 14 days. Again the reminder should be sent out weekly.

Since I am new to this I would appreciate explanatory solutions since I can't code etc..

Thank you for the help!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Hello,
did you try to start creating a flow?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I saw that there where topics about it with the function recurrence, but I couldnt figure out how to condition this Flow with the conditions I have. E.g. do I have to use "Get Items" and then use the condition trigger ?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

No. A flow should have only one (initial) trigger.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

So is it possible to find a solution for my problem with one flow or a two flows necessary?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I did a solution for the first problem but I get a mistake for the second problem.
I did a recurrence and as next step get items for the sharepoint list and I want to put a filter query in order to get the solution this is the expression I uses:

'FirstDateColumn ne null and SecondDateColumn eq null and days(diffDays(utcNow(),FirstDateColumn)) ge 14'

Any ideas why I get a mistake.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

I found a solution myself, if anyone has a similar request this is how I did it:
DateColumn eq null and days(diffDays(utcNow(),Created)) ge 30
The second solution:
FirstDateColumn ne null and SecondDateColumn eq null and days(diffDays(utcNow(),FirstDateColumn)) ge 14

Was this reply helpful? Yes No