Unanswered

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

(0) Share

Report

Posted on by CU20011233-0

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

All responses (4)

Answers (0)

MJain 2,450 on at

Like (0)

Report

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

Hi @selimdag ,

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

Thanks
CU20011233-0 54 on at

Like (0)

Report

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

Hi @ManishJain,

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

Thanks
MJain 2,450 on at

Like (0)

Report

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

Hi @selimdag ,

The list of supported operators :

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/queryfunctions?view=dynamics-ce-odata-9

Thanks
CU20011233-0 54 on at

Like (0)

Report

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

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"