65
I'm trying to create a flow that retrieves a file based on the URL column, but keep running into this error:
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,
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.
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.
Share
Report
All responses (
Answers (
