Microsoft Dynamics 365 | Integration, Dataverse...

Trigger a workflow based on TIME

(0) Share

Report

Posted on by eSBe

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!

I have the same question (0)

All responses (5)

Answers (0)

eSBe 97 on at

Like (0)

Report

Trigger workflow based on Time

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!

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

RE: Trigger a workflow based on TIME

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.

Was this reply helpful? Yes No
Suggested answer

Inogic 682 on at

Like (0)

Report

RE: Trigger a workflow based on TIME

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!

Was this reply helpful? Yes No
eSBe 97 on at

Like (0)

Report

RE: Trigger a workflow based on TIME

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.

Was this reply helpful? Yes No
eSBe 97 on at

Like (0)

Report

RE: Trigger a workflow based on TIME

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!

Was this reply helpful? Yes No