Hi, I am trying to trigger a flow comparing the SP modified field against another date time field called CUOSignOffDt.
I only want to compare down to format dd/MM/yyyy hh:mm format.
I have managed to successfully add a condition at the beginning of the workflow comparing the two fields using the format date time expression and this works fine. However, ideally I don't want the flow to trigger, so need to do the comparison in the 'When an item is created or modified' trigger action as a Conditional trigger. To note the 'When an item is created or modified' trigger action is using a gateway connection to an on prem version of SP so can't use the 'Get changes for an item or a file action'
I need to compare the two date time fields, making sure they are the same down to dd/MM/yyyyy hh:mm format in a trigger condition in the 'When an item is created or modified' trigger action.
I tried various syntax options, along the lines of, but saying incorrect syntax:
@
@equals(triggerBody()?formatDateTime(['Modified'], 'dd/MM/yyyy hh:mm')?['value'],formatDateTime(['CUOSignDt'], 'dd/MM/yyyy hh:mm'))
Any help would be highly appreciated.
