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?
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:
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,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156