Sent Reminder Email if Date Column is blank after xx days

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Hello,
did you try to start creating a flow?

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

Like (0)

Report
Copy link

Link copied!

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,081 on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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