cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericam
Level: Power Up

Does Flow support Odata filtering for contains

Hi-

 

I am using OData filtering on a Sharepoint list and would like to use contains. Is this supported?

 

Thanks,

ERica 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Does Flow support Odata filtering for contains

Hi @ericam,

 

Currently OData filters are not implemented yet by all connectors.

See the response from SameerCh in the following thread:

ODATA Filters - are these implemented yet?

 

 

But the filter query works for SharePoint lists.

53.PNG

Currentlly the Filter Query under the Action Act as the 

$filter in OData Query,

The Order By act as the:

$orderby

There is no $select query implemented under the Action.

So if you would like to return special fields from the SharePoint list (See OData reference for SharePoint REST query), you may consider submit this as an idea, to add the $Select as an available Query under the Get Items Action.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Super User
Super User

Re: Does Flow support Odata filtering for contains

the answer is to use substrigof

 

substringof('add',Title)

      is equivalent to

contains(Title,'add') 

 

note the reverse order of the arguments \

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Does Flow support Odata filtering for contains

Hi @ericam,

 

Currently OData filters are not implemented yet by all connectors.

See the response from SameerCh in the following thread:

ODATA Filters - are these implemented yet?

 

 

But the filter query works for SharePoint lists.

53.PNG

Currentlly the Filter Query under the Action Act as the 

$filter in OData Query,

The Order By act as the:

$orderby

There is no $select query implemented under the Action.

So if you would like to return special fields from the SharePoint list (See OData reference for SharePoint REST query), you may consider submit this as an idea, to add the $Select as an available Query under the Get Items Action.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User
Super User

Re: Does Flow support Odata filtering for contains

I am also struggling with filtering data effectively.

 

Reading the referenced ODATA documentation, the following expression shourd work as $filter equivalent 

 

substringof(ParcelType,'d')

==> The function operator 'substringof' is not supported or its usage is invalid. clientRequestId: 7ffb26aa-5e14-4f31-a871-c28913ed6492 serviceRequestId: 3687659e-60ef-5000-cfae-fc2dec4a8e75

 

substringof(ParcelType,'d') eq true

==> The query is not valid. clientRequestId: 23684da9-2a8c-4369-ad0a-4a06447fd64b serviceRequestId: 5a87659e-60b7-5000-99fd-366ddd21103a

 

Also CONTAINS does not work - although is is efined in 

http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/part2-url-conventions/odata-v4.0-er...

 

contains(ParcelType,'d') eq true

The function operator 'contains' is not supported or its usage is invalid. clientRequestId: 4e09447a-6b56-49b4-8a9f-f3b8d8a42cc4 serviceRequestId: 4a86659e-e0fb-5000-99fd-3241e5e4e886

 

help will be much appreciated 

vince_jennings
Level: Powered On

Re: Does Flow support Odata filtering for contains

I'm having a similar problem.

I am trying to use the following Filter query on a SharePoint contact list

tolower(Email) eq 'someEmailAddress'

 

I get the following error:

"The query is not valid.\r\nclientRequestId: b4df2051-c8ec-4df4-8740-33a1182776b5\r\nserviceRequestId: a0ee8a9e-b000-6000-f58f-8d9fba05c8f2"

Highlighted
Super User
Super User

Re: Does Flow support Odata filtering for contains

the answer is to use substrigof

 

substringof('add',Title)

      is equivalent to

contains(Title,'add') 

 

note the reverse order of the arguments \

View solution in original post

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,485)