Share
Report
2Hello Everyone,
I'm a novice to using Power Automate however i've received a requirement that I need to automate a series of scheduled emails - set against a set number of period relative to a future date for a data migration. So for example i want to send an email 30 days out, 15, 7 and 1.
I have created the below "test" environment from which to work. You can see the Migration date column Which is formatted as a "date" and the "Programme Lead" column which is formatted as people with multiple options selected.
Here is the flow as i had it so far:
The plan was to have a recurring check each day where the flow will check the list for is the migration date is 30 days from now.
I have used the following expression in the filter query as i've seen in some of the other solutions on this site:
Migrationdate eq 'addDays(utcNow(),30)'
when testing however, i am receiving an email when the Migration Date is exactly 30 days out from today +30 days but also when it's more than 30 days or less than 30 days.
Can anyone assist me with calibrating my flow to work relative to the migration date correctly? I will be scaling this solution into a much larger list.
All responses (
Answers (
