Unanswered

odata contains

(0) Share

Report

Posted on by sasrsc

678

I'm doing a getFiles action step with the properties only.... trying to do contains (which is apparently a substringof).
I have tried contains and substringof - neither works.
I also couldn't find a good reference to this in the Msft documentation that is actively updated.
I am currently using a startswith odata filter successfully and not sure why this is rejected.

Categories:

General topics

All responses (7)

Answers (0)

Sort by

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @sasrsc

This post is very helpful:

https://diyd365.com/2019/11/20/every-power-automate-ms-flow-filter-query-you-ever-wanted-to-know-as-a-functional-consultant/

contains does work. If you’re having issues with contains, please post the error you are getting, with your syntax
sasrsc 678 on at

Like
a
(2)

Report
Copy link

Link copied!

So I got this to work...
substringof('@{triggerBody()['text']}', Title)

Notice that the "search for this text" is before the variable that I'm searching in. I think I found that on another site.

I tried this...
contains(Title,'@{triggerBody()['text']}')
and I get this error...
The function operator 'contains' is not supported or its usage is invalid.
clientRequestId: a5bc9929-de80-4e9e-a10a-e060a2727bbe
serviceRequestId: a5bc9929-de80-4e9e-a10a-e060a2727bbe

I tried flipping them...
contains('@{triggerBody()['text']}',Title)
and the same error.

The person on this page is mentioning List Records in all their examples and not specifically querying a sharepoint list/document library, so I'm wondering if there are differences where SP won't accept some of those example Odata filters.
sasrsc 678 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jcook thanks for that tip. I had been using that site and couldn't figure out why my specific use case was failing.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sasrsc

Not all the ODATA filter queries are qualified to run via Power Automate connectors.

Thanks
sasrsc 678 on at

Like
a
(0)

Report
Copy link

Link copied!

do you know if there's a webpage that tells you what odata filters work with different connectors?
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sasrsc

I have not seen any Docs that describe which Odata filters work for what connector.

You could also try using the 'Filter array' action
danishpowerapps 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sasrsc

I ran into the same issue - it seems you were onto the fact that "contains" is not supported by Sharepoint list.

Seems it's bloody hard to get something working on a text field where you filter on contains/not contains...

Check the documentation for query options here (scroll down to a diagram showing the overview):
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests

Cheers