cancel
Showing results for 
Search instead for 
Did you mean: 

trigger a flow based on date and time

How about adding the ability to trigger based on date and time?

 

The basic scenario would be manually entered date/time  or recurring date/time, such as “every Monday morning do this...”

 

It would be really useful though, if triggers could be based on data in various apps and services. Here are some examples:

1. A property on a SharePoint/OneDrive document library or list. It could be “100 days after file created” or “when this date/time in a custom column occurs”. We have a use case, where contracts are stored in a doclib with custom columns for expiration. It would be very useful to be able to trigger a workflow on or before those dates occur.

 

2. Outlook reminders, on/before/after meetings occur or on/before/after tasks are due

 

3. Planner, ToDo and classroom assignments are all services that have due dates, which could benefit from reminders before or on the date, but also after to follow up or be reminded of overdue tasks.

 

Those were just some examples, but basically anywhere dates and times are to be found, either as existing fields or custom, would be applicable.

Status: Completed

This feature is available with the Recurrence trigger: https://flow.microsoft.com/en-us/blog/download-history-recurrence/

Comments
Level: Power Up

Crenstrom,

 

I need help setting up step 3a.  I am a novice and this logic function to trigger is confusing.   I am trying to trigger an email to a specific person 30 days before a date in their row has been met.


Level: Powered On

There's a lot of ways to accomplish the same thing.  The way I would do is a flow triggered to run at your desired frequency, a "Get Items" connector to your source, a "For each" control to iterate through each row from your source, then within it a "Condition" control to identify/filter which of your source items need to have the email sent.

 

Within that condition control you have a couple options, which you've probably found searching around the various microsoft and reddit forums... What works with my thought pattern is in the Condition control: "Date field" "is less than or equal to" "adddays(utcnow(), 30)".  Only the last one is an expression.  You could use the "is equal to", but then you'd have to get into the formatting so it's not looking at hours, minutes, etc.

 

Hopefully that gives you some ideas.