Re: Frequency based alerts
Hi @Ayush09
Do you want to receive an email 6 month from the "completion date" if the Plan no. column's value is equal to 'A'?
You can build a scheduled cloud flow,run it once a day, check that the value of 'Plan No.' in the list is equal to A, and the date of today minus 180 is equal to 'completion date' .
I set up a flow,you can refer to the screenshots below to see if it helps.
This is my test list.
Flow in details:
Filter query:Planno_x002e_ eq 'A' and CompletionDate eq '@{addDays(utcNow(),-180,'yyyy-MM-dd')}'
'Planno_x002e' and 'CompletionDate' are the internal names of 'Plan no.' and 'CompletionDate' column respectively.
After flow runs, I will receive an email like below.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
