Power Platform Community Forum Thread Details

Hello,

I am trying to schedule date to send email in an automated flow. I want to send email every 3,6,9 and 12 months from base time.

I couldn't use 'Delay Until" due to time constraint of 30 days.

My trigger is 'change in phase' which is irrelevant to date/base time.

This flow is for number of projects with different base time. I am hesitant to use 'Delay'.

Is there a way to define 'Delay' action with actual date (dynamic content) instead of 'count and unit.'

Categories:

General topics

If you have the base time within the list already which it appears you do. You can schedule the flow to run every day and get all items (or that one item if it is just one) and check if those base dates are 30 days, 60 days, 90 days past etc using conditions in parallel branches or using an if condition in a single action.

Alternatively you can get schedule the flow to run every day and then have parallel branches that only get items that are 30,60/90 past and run your actions on all of them:

Create a new flow by clicking “Automate” > “Power Automate” > “See your flows”.
Start with a recurrence trigger that fires once a day.
Follow that with 3 Get Items actions each with a filter query.
The filter queries will look something like this for the first email: Status eq 'Pending' and Created eq 'addDays (utcNow (), -30,'yyyy-MM-dd')'.
If there are some items, send the reminder email.

--------------------------------------------------------------------
🌟 If I have helped give me a thumbs up! 👍
If I have answered your question, please mark it as solved ✅