'Power Automate reminders to be send on number of days from initial day
I am working on SharePoint List solution that acts on date trigger. The base date is a date of parcel receipt. I need a set of reminders that stop once Picked field is turned "yes".
Idea here is:
- Initial info on "New Item" - done and work fine
- Flow to send reminders on 2nd, 4th and 7th working day from the initial date (parcel receipt).
- Fields Reminder 1, 2 and 3 to be updated by the flow accordingly
I can not create a flow that will meet above criteria and execute on each record respectively. I have constructed various flows, but each of those seem create a different issue.
Solution I believe will solve that would need to be constructed with following elements:
- Schedule run every 1 week on workdays (Mo-Fri) as Initial trigger
- Get items filtered ODATA Picked eq No
- Condition on Arrival if greater or equal Today -X (X a number of days for reminder)
- Send reminder email to Parcel Recipient
My biggest concern is step 3 as I am lacking syntax/formula function writing skills. Can you suggest a steps to follow?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|