Can't run an Odata filter on URL Column?

(1) Share

Report

Posted on by jmathur

I'm trying to create a flow that retrieves a file based on the URL column, but keep running into this error:

{

"status": 400,

"message": "The field 'URL' of type 'URL' cannot be used in the query filter expression.

}

Any idea why this is or how to get around it?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

dbro 194 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jmathur ,

this is a limitation of the api. So i'm afraid filtering by a hyperlink column is not possible unless you use a caml query. In which case the following should work:

   <Where>
      <Eq>
         <FieldRef Name='URL' />
         <Value Type='URL'>https://yourdomain.sharepoint.com/sites/yoursite</Value>
      </Eq>
   </Where>

If you must find the item in flow via odata, you could try setting the value of your hyperlink column at some point to a text value in a different column (hidden). Then you could do a get item(s) action based on the value of type text.

If this has answered your question, be sure to mark it as answered.

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@jmathur

Since odaa does not work on URL column
first get all files

then run for loop and then use condition to filter it out

Not the most effectoive solution but will work

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @jmathur ,

The URL type is not supported in Filter Query. Please refer to this blog for more details on Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

Please consider using Condition or Filter array directly to filter items.

Best Regards,

Was this reply helpful? Yes No