You’re offline. This is a read only version of the page.
Announcements
2
Hello 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.
I found a solution that works here:
https://powerusers.microsoft.com/t5/Building-Flows/Need-help-creating-a-Power-Automate-flow-30-days-before-due-date/m-p/2018640
Share
Report
All responses (
Answers (
