Power Automate Trigger For When 'To Date' Field Equals Today

(0) Share

Report

Posted on by nisar542

Hi All,

I am hoping someone can help me.

I have a flow which I want to trigger when a record is modified (on the Resource Requirement entity).

I want the flow to only trigger if the 'To Date' field equals today.

The below is the field that I am looking to filter on and how the data shows from D365.

I have tried:
@equals(triggerBody()?['msdyn_todate'],utcNow('dd-mm-yyyy'))
@equals(triggerBody()?['msdyn_todate'],utcNow('yyyy-mm-dd'))
@equals(triggerBody()?['body/msdyn_todate'],utcNow('dd-mm-yyyy'))
@equals(triggerBody()?['body/msdyn_todate'],utcNow('yyyy-mm-dd'))
@equals(triggerBody()?['msdyn_todate'],startOfDay) - this expression isn't accepted when I try to save the flow.

But none of these make the flow trigger.

Can anyone help and tell me what I am doing wrong?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

RE: Power Automate Trigger For When 'To Date' Field Equals Today

Hi nisar542,

mm need to be uppercase. Please try @equals(triggerBody()?['body/msdyn_todate'],utcNow('yyyy-MM-dd')).

I tested this and it can work:

Result:

Was this reply helpful? Yes No