I need a flow that can send an email out to the assigned individual on a SharePoint list, reminding them every 2 weeks to update their item if they haven't done so in a week.
Here is the screenshot below of what I've built, but I'm sure I'm doing it wrong. Hope you can help, thank you!!
You'll want to use a filter query on your Get items action. I can provide an example but I don't quite understand your requirement. Do you want an email to go out if the item hasn't been updated in a week or 2 weeks?
Finally, Create a column in the list to store Reminder Sent Date and Update the date to todays date after you send email. Then add a condition just before SendEmail to check if Difference between todays date and EmailSend date is > 14 days. If yes, send email else not.
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |