Answered

List rows in power automate

(0) Share

Report

Posted on by Petrusottie

Good day,

Kindly assist, I'm get the error: "A binary operator with incompatible types was detected. Found operand types 'Edm.Date' and 'Edm.String' for operator kind 'Equal'." I am comparing the date, see attached screenshot.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You are storing your calculated date in a String Variable. If you want to use it in a List Rows filter you need to cast it back to an actual date using the FormateDateTime() function.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Petrusottie 17 on at

Like (0)

Report
Copy link

Link copied!

I still getting an error

Was this reply helpful? Yes No
Petrusottie 17 on at

Like (0)

Report
Copy link

Link copied!

Code: cr473_dateclosed eq null and cr473_datecreated eq @{formatDateTime('varDate2DaysAfter')}

Error: Unable to process template language expressions in action 'List_rows' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string 'varDate2DaysAfter' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please post the formula you are using for setting the variable. Something about it is setting the value to be a non-compliant date format.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Petrusottie 17 on at

Like (0)

Report
Copy link

Link copied!

Here is my formula: cr473_dateclosed eq null and cr473_datecreated eq @{formatDateTime('varDate2DaysAfter')}

Where the variable (varDate2DaysAfter) -> addDays(utcNow(),-2,'MM/dd/yyyy')

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Remove the format string "MM/dd/yyyy" from the AddDays. That is making the output a non ISO 8601 date format, which is required for the query in List Rows. The format string is optional and ISO 8601 format is the default.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Petrusottie 17 on at

Like (0)

Report
Copy link

Link copied!

Hi Pstork1,

I have removed the string format, but now I getting: cr473_dateclosed eq null and cr473_datecreated eq 2026-02-22T15:48:36.1868248Z,

whereas on my dataverse table I've set Date Only for cr473_datecreated column. Now the filter condition evaluates to false, meaning no row is returned. How can I remove this part after the date 2026-02-22T15:48:36.1868248Z so that I compare date only with the date.

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You don't want to remove it entirely. You want to set it to 00:00:00.000Z. Use the following mask in the formatDateTime

'yyyy-MM-ddT00:00:00.000Z'

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No