Unanswered

Run scheduled flow on a date from list items

(0) Share

Report

Posted on by xvzms

103

Hi!
I've a Task List with items as task and every task has an Expiry Date.

I want notifications to be sent to the mail for each item at the time when the Expiry Date and Time are set for it.
Each item has its own date and time when notifications should be sent to the mail.
Could you tell me please how can I set up my schedule trigger to run it strictly on these dates and times?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report

Triggering the flow in such a way is not possible (IMHO).

However, you can set the trigger's recurrence to one hour and check with the Get item's Filter Query if the ExpiryDate is within the hour.

Another way to archive your goal would be to chose a trigger "When an item is created or modified" and use the Delay until action.

After the delay, you could check, if the ExpiryDate has changed and send the mail, if not.

Keep in mind that this has some limitations (e.g. flow duration limit)

Was this reply helpful? Yes No
BarbC 12 on at

Like (1)

Report

@xvzms Although you can't set the recurrence trigger this way, you could set it to run each day in the morning. Then in your Apply to Each step, if Date = today, delay until time = scheduled time and then send the email. The Apply to Each normally runs sequentially, but in Settings you can change it to run Concurrently so each item will trigger when the time arrives. Might want to set the degree of Parallelism to a pretty good level depending on the number of items it'll be processing each day.

Was this reply helpful? Yes No
xvzms 103 on at

Like (1)

Report

@Chriddle, @BarbC Thank you for your responses!
It seems I was able to set up the workflow.

First I get all the items from the list, Filtered by today ExpiryDate and sorted by ExpiryDate. The items should now be in the order of that ExpiryDate.
Next, in Apply to each, I used Delay until ExpiryDate time and send notification to the mail.

Was this reply helpful? Yes No