$filter contains function doesn't work

Question

$filter contains function doesn't work

Vincent Gagnon 6

This is the error I get: "Unsupported property filter clause operator 'Contains'."

Example in the Graph Explorer

https://graph.microsoft.com/v1.0/users?$filter=contains('m',displayName)

RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-13T05:42:45.357+00:00

Hi @Vincent Gagnon ,
would you please provide us with an update on the status of your issue?
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-15T01:33:02.2+00:00

Hi @Vincent Gagnon ,
I am checking to see how things are going there on this issue.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-18T01:04:15.747+00:00

Hi @Vincent Gagnon ,
If there's anything you'd like to know, don't hesitate to ask.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-21T09:54:50.397+00:00

Hi @Vincent Gagnon ,
I am checking to see if the problem has been resolved.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-25T08:06:07.86+00:00

Hi @Vincent Gagnon ,
Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Thanks,
Raytheon Xie
Vincent Gagnon 6 Reputation points

2021-10-25T17:32:31.387+00:00

Hi @RaytheonXie_MSFT , I was looking for a solution using the Graph API, which doesn't seem to exist as of now. I ended up doing the filtering in the code... Thanks anyway
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-11-02T01:13:34.28+00:00

Hi @Vincent Gagnon ,
There is no such method currently，I would recommend you rest api to meet your requirement

1 answer

Your answer

RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-13T05:42:45.357+00:00

Hi @Vincent Gagnon ,
would you please provide us with an update on the status of your issue?
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-15T01:33:02.2+00:00

Hi @Vincent Gagnon ,
I am checking to see how things are going there on this issue.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-18T01:04:15.747+00:00

Hi @Vincent Gagnon ,
If there's anything you'd like to know, don't hesitate to ask.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-21T09:54:50.397+00:00

Hi @Vincent Gagnon ,
I am checking to see if the problem has been resolved.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-25T08:06:07.86+00:00

Hi @Vincent Gagnon ,
Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Thanks,
Raytheon Xie
Vincent Gagnon 6 Reputation points

2021-10-25T17:32:31.387+00:00

Hi @RaytheonXie_MSFT , I was looking for a solution using the Graph API, which doesn't seem to exist as of now. I ended up doing the filtering in the code... Thanks anyway
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-11-02T01:13:34.28+00:00

Hi @Vincent Gagnon ,
There is no such method currently，I would recommend you rest api to meet your requirement

Answer 1

RaytheonXie_MSFT 40,481 Microsoft External Staff

Hi @Vincent Gagnon ,
As far as I know, The contains function are not available for users. You can use startsWith since it's available

https://graph.microsoft.com/v1.0/users?$filter=startsWith(displayName,'m')

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Vincent Gagnon 6 Reputation points

2021-10-05T13:48:24.573+00:00
Is there a way to know which function is supported where? I'd like to use contains on a single line of text column in a sharepoint list. Example:
contains(columnName, 'query')

https://graph.microsoft.com/v1.0/sites/root/lists/d7689e2b-941a-4cd3-bb24-55cddee54294/items?$expand=fields&$filter=contains(fields/Title,'e')
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-06T08:59:00.673+00:00

Hi @Vincent Gagnon ,
Per my test, We have the function of contains, but the function is not used to get the items which a column contains the string you want to query. The contains is for some other properties. I tested startswith or endswith the url works well, but when I use contains, it returns item not found. Here is the link for reference:
https://learn.microsoft.com/en-us/graph/query-parameters#error-handling-for-query-parameters
Vincent Gagnon 6 Reputation points

2021-10-06T13:18:46.023+00:00

Ok. startswith and endswith are not completely doing what I want to do. I looked at $search which is interesting but it doesn't seem to work either. I guess I am looking for a "REST Api's substringof" equivalent.
RaytheonXie_MSFT 40,481 Reputation points Microsoft External Staff

2021-10-07T01:49:49.097+00:00
Hi @Vincent Gagnon ,
I tested the REST Api 'substringof' and found it works well. The following url might meets your requirement:

/_api/web/lists/getByTitle('Address')/items?$select=Title,Id,Company,City&$filter=substringof('e',Company)

Share via

$filter contains function doesn't work

1 answer

Your answer