Hi team,
So I have 2 Entities: Event and Event Schedule
Event has a Start Date and End Date
Event Schedule has Service Start Date/Time and Service End Date/Time.
Event (1) : Event Schedule (N) relationship
I want a workflow to fire off a notification to a user if the Event Schedule Service End TIME is past 8:01 PM.
How do I get that to work?
Thanks!
Hi Roohi,
I was hoping there was a way OOTB to do this. Your suggestion is a good one and I'll give it a shot and update this request.
Thanks,
Cheerz!
Hi Lu,
The trigger is when the Event Schedule record is created.
And yes, you're right - the Event entity doesn't have much to do with this.
So the Event Schedule TIME is what needs to be checked once the record is created.
Hi,
In workflow, there is no OOB way to set a condition on the time part of date time field.
You can use a trick here,
Create a new flag field (two option), suppose “Is Time Past” on “Event Schedule” entity.
Now write a JavaScript that will trigger on change of “Service End Date/Time”.
Follow JavaScript logic as:
Set “Is Time Past” to 1 if “Service End Date/Time” > Service End Date with time as 8:01 PM.
Build a workflow or Power Automate FLOW which triggers on change of “Is Time Past” and your first condition in workflow/FLOW would be “Is Time Past” = 1, if true then fire off a notification to a user.
Hope this help!
Hi partner,
It seems that the Event entity does not play any role in this request.
Also, what's the trigger for this workflow?
Generally, workflow triggers have records being created, updated, and deleted.
Hi team,
So I have 2 Entities: Event and Event Schedule
Event has a Start Date and End Date
Event Schedule has Service Start Date/Time and Service End Date/Time.
Event (1) : Event Schedule (N) relationship
I want a workflow to fire off a notification to a user if the Event Schedule Service End TIME is past 8:01 PM.
How do I get that to work?
Thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156