How to filter Sharepoint List Items Queried with Microsoft Graph

Question

I am using the .net SDK. Trying to filter a large list with Microsoft Graph,

My query works fine using .Items.Request().Expand("fields").GetAsync(); However, if I add a filter, it doesn't work as expected.

I have tried two approaches :

Add .Expand("fields").Filter("fields/Archived eq false").GetAsync(); That works, but returns all the list items without filtering.
Add .Expand("fields($filter=Archived eq false)").GetAsync(); This does not work - it gives me an error that expand, select, and filter are the only allowed queries.

What does work is ("fields($select=Archived)"), but of course, no filtering is done.

So how are we to query large lists using Microsoft Graph?

Marc LaFleur · Accepted Answer · 2018-02-08 18:12:57Z

4

You need to quote the value you pass into your filter: Fields/Archived eq 'false' (note the 's):

var result = graphClient
    .Sites["root"]
    .SiteWithPath("siteId")
    .Lists["listId"]
    .Items
    .Request()
    .Expand("Fields")
    .Filter("Fields/Archived eq 'false'");

answered Feb 8, 2018 at 18:12

Marc LaFleur

33.4k4 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanjay Makwana · Accepted Answer · 2018-03-12 12:27:54Z

1

After too much research on this issue i found below solution and its working fine for me:

To Filter you need to add Header parameter as follow: Prefer : HonorNonIndexedQueriesWarningMayFailRandomly

And Graph api will be as follow: &$filter = Fields/Archived eq False

answered Mar 12, 2018 at 12:27

Sanjay Makwana

239 bronze badges

1 Comment

CKelly-Cook Over a year ago

Alternatively you can add the column in SharePoint as an index, this will improve performance rather than filtering against an un-indexed column support.microsoft.com/en-us/office/…

Collectives™ on Stack Overflow

How to filter Sharepoint List Items Queried with Microsoft Graph

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related