Return to Question

edited body

Source Link

edited Nov 1, 2022 at 16:47

If iI run a query

.../_api/web/lists(<GUID>)/items?$filter=Field eq 'Option1'

then it returns all items containing Option1 in multi-choice Field including:
[Option1],
[Option1, Option2],
[Option1, Option3, Option4]

What query should iI run to get all items which have only Option1 in multi-choice Field i.e.:
[Option1] [Option1]?

If i run a query

.../_api/web/lists(<GUID>)/items?$filter=Field eq 'Option1'

then it returns all items containing Option1 in multi-choice Field including:
[Option1],
[Option1, Option2],
[Option1, Option3, Option4]

What query should i run to get all items which have only Option1 in multi-choice Field i.e.:
[Option1]?

If I run a query

.../_api/web/lists(<GUID>)/items?$filter=Field eq 'Option1'

then it returns all items containing Option1 in multi-choice Field including:

What query should I run to get all items which have only Option1 in multi-choice Field: [Option1]?

Source Link

asked Nov 1, 2022 at 16:43

Filter SharePoint list by multichoice column for exact match

If i run a query

.../_api/web/lists(<GUID>)/items?$filter=Field eq 'Option1'

then it returns all items containing Option1 in multi-choice Field including:
[Option1],
[Option1, Option2],
[Option1, Option3, Option4]

What query should i run to get all items which have only Option1 in multi-choice Field i.e.:
[Option1]?