Power Automate

Found operand types Edm.Guid and Edm.String for operator

(1) Share

Report

Posted on by NS-10041416-0

184

Hi,

I am able to see the error message in the List of Rows activity as mentioned in the subject

I am entering the exact RequestId but still it is failing

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

You're getting an error because you're comparing a text value ('1234') with a column that expects a different data type, likely a GUID. The column az_createapprequestid is not the right one for your value.

Step 1
Open your Dataverse table and check the column that holds the value 1234. It is in the RequestNumber column.

Step 2
In the Power Automate List rows action, replace the filter with
RequestNumber eq 1234
Use single quotes only if RequestNumber is a text column
RequestNumber eq '1234'

Step 3
Remove the current filter
az_createapprequestid eq '1234'
because it causes a type mismatch error

Step 4
Save and test your flow again. It should work without the type error.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,504 Super User 2025 Season 2 on at

Like (0)

Report

Hi @NS-10041416-0

As @SwatiSTW mentioned you are clearly comparing a GUID (which is the record identifier) to that Number.

The question is: What are you trying to actually do. Why are you using the unique record ID on one side and then using the Number column on the other.

Is the other a lookup column?

@SwatiSTW is correct to change the column name is thats what you mean to compare, but that seems like a big like mistake to intentionally add the unique id column but use another columns value, so that's why I am trying to verify what you are trying to do as you are either going to change the column as she States, or you have to find the right Record GUID id to compare it too.

Was this reply helpful? Yes No
NS-10041416-0 184 on at

Like (0)

Report

Hi @Michael E. Gernaey and @SwatiSTW,

Thanks for the reply.

After little research, I understood that

I have to use dynamic expression and map formatted value of choice.

Please guide me on this.

Regards,

Sudheer

Was this reply helpful? Yes No