Microsoft Graph API Filter SharePoint List Items By CreatedBy User

Question

I am using Microsoft Graph API and trying to filter items in a SharePoint List by CreatedBy User but am not sure how to write the filter query.

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$$filter=

I have tried "https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?&$filter=AuthorLookupId eq {user-id}" but it doesn't seem to work.

I'm afraid it's impossible. When a graph api support Ddata query, it will have a setion named Optional query parameters in the api document, but this api doesn't have this section. — Tiny Wang
– Tiny Wang, Commented Dec 25, 2022 at 9:21
why would you use Microsoft Graph API while you can call SharePoint REST API directly — AIMEN BOULAHIA
– AIMEN BOULAHIA, Commented Dec 25, 2022 at 15:01

Zella_msft · Accepted Answer · 2022-12-26 07:58:30Z

0

According to my research and testing, unfortunately, there is currently no Graph API can filter items by CreatedBy User. As a workaround, I recommend you use the following REST API to filter items:

https://xxxxx.sharepoint.com/sites/xxx/_api/web/lists/getbytitle('xxxx')/items?$filter=AuthorId eq 21

Thanks for your understanding.

answered Dec 26, 2022 at 7:58

Zella_msft

3922 silver badges4 bronze badges

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

1 Comment

Ofer Gal Over a year ago

It should be /items?$expand=fields&$filter=fields/AuthorId eq 21 because AuthorId is a field

martinm · Accepted Answer · 2022-12-26 10:23:56Z

0

You can at least filter items by field AuthorLookupId. The filtering can be allowed by adding the header Prefer: HonorNonIndexedQueriesWarningMayFailRandomly.

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields&filter=fields/AuthorLookupId eq '10'

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields&filter=fields/Title eq 'whatever'

answered Dec 26, 2022 at 10:23

martinm

22.1k4 gold badges45 silver badges72 bronze badges

Collectives™ on Stack Overflow

Microsoft Graph API Filter SharePoint List Items By CreatedBy User

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related