Microsoft.OData.ODataException: An unknown function with name 'utcNow' was found

[selimdag]

Hey,

I am trying to add a filter expression as in the ss below. But I am getting the error "An unknown function with name 'utcNow' was found when I trigger the flow. I am not able to add utcNow() function as an expression, since that is a filter expression and not a filter query. Any Idea how I can achieve this? 

PS: I could add a condition in the next steps but I would like to make it efficient, so that the flow won't be triggered, if the expression is not satisfied. 

Greetings 

[selimdag]

Update: 

I added the expression somewhere else - copied and pasted it there: 

Now I'm getting this error: 

"Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThan'.\r\n"

[ManishJain]

Hi @selimdag ,

The list of supported operators :

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/queryfunctions?view=dynamic...

Thanks

[selimdag]

Hi @ManishJain, 

can you give me an example, how to use these expressions? 

Thanks 

[ManishJain]

Hi @selimdag ,

https://diyd365.com/2019/11/20/every-power-automate-ms-flow-filter-query-you-ever-wanted-to-know-as-...

Thanks