Flow Designer Wait For Condition 15 minutes before a start time

[David168]

Good Morning;

The Need:

Am working through a scenario where I need to trigger the creation of an interaction record 15 minutes before a specified time.

The Scenario:

We created a custom app in Studio to create a booking time where a client can "book an agent" for a 15 minute time slot during the day,  Our Team Leads will create these 'events' daily and they are presented on a catalog item for our clients to choose a valid time slot.  This is all working perfectly.  My issue is I need to create an interaction record 15 minutes before the event start that will be triaged through Advanced Work Assignment.  The AWA portion also works perfectly.  

The Problem:

I am having a difficulty with the wait for condition to trigger the creation of interaction record. 

I have the following 'wait for condition' set in Flow Designer 

Record: Event Name (custom table built in App Studio)

Table: x_todsb_client_a_0_event

Condition: "Starts" relative before 15 minutes ahead

'Starts' is the start date/time of the event. 

If anyone has completed a scenario like this, your assistance would be appreciated.  Or perhaps you have a better option? I am open to suggestions. 

Thanks; 

Dave Trimble

[James Schwab · Accepted solution]

Hi Dave,

The challenge I assume you are facing here is that you have set a condition for your Flow to begin, but there is no event (insert, update, create, or delete) that is happening to actually trigger that Flow, as the passage of time will not count as a trigger event.

I would consider these two options to manage the timed events:

1. Run a Scheduled Flow every minute, that queries for all events that are between 14 and 15 minutes ahead of time, and creates the interaction.

1. When the event is created start a Flow, that has a "Wait for Condition" that will wait until 15 minutes before the start time, and then proceed to create the interaction.