Sharepoint Get items, Odata filter, column data type is not match the column type of sharepoint column

Like (0) Share

Report

Posted on 31 May 2024 07:41:13 by navy

Hello All,

I encountered a very change error on Sharepoint Get items Odata filter. The column data type in my list is single line text. When I put the filter value as string, it gave me error "The expression "Item_No eq ‘K39124WW’" is not valid. Creating query failed.
clientRequestId". But when I put the filter value with number, it worked Ok.

I tried on different lists for column in text, the flow can't work. There is no such issue before. Please help, thanks a lot!

All responses (1)

Answers (0)

Expiscornovus 32,169 Most Valuable Professional on 02 Jun 2024 at 15:38:10

Like (0)

Report
Re: Sharepoint Get items, Odata filter, column data type is not match the column type of sharepoint column

Hi @navy,

It looks like you used an ’ character instead of a ' character, these are two different characters.

Can you try the below instead?

Item_No eq 'K39124WW'