Reminder emails
Hello!
I was wondering if I could please have some advice. I'm trying to set up a system where power automate checks my spread sheet to see if a task had been completed and sends candidates who haven't completed the task a reminder email every 3 days. I've managed to make it so it sends a reminder every morning however it is getting buggy changing to the 3 days. On my spread sheet I have the person's name, their email and if the task is complete or incomplete, if their reminder emails are active yes or no, and when the last reminder was sent. I have the trigger as recurrence, lost rows present in a table -> for each (body/value) -> condition 1 (reminders active is equal to YES) -> true -> condition 3 last reminder sent is equal to blank or last reminder sent is less or equal to ticks(addDays(utNow(), -3) -> true -> Send an email (V2) -> update a row
Any advise on this? I've been trying for days but keep getting stuck.
Thanks in advance