Contents
I am tried to apply Filter on SharePoint List Lookup column using Microsoft graph API filter based on string value. But it didn’t filter. I am able to filter using Lookup-id. I have used below api to filter.
Can You filter by lookup value in graph API?
@ParthasarathyBalan, As per experience Graph API does not support to apply filter by lookup value. As a workaround you could consider the following solution to filter by lookup value (requires two requests). Hello @BharatKhunti. Can you give some examples of how to solve this problem?
How to filter OData in a lookup column?
As a LookUp field, ODATA needs to be told which sub-attribute you want filtered. The important thing here is that if you’re looking to filter by whatever populates “Value”, then you actually need to provide the “True name” of the field targeted in the “Get information from:” section of the LookUp column’s configuration.
Is it possible to filter a lookup column using a specific criteria?
If so, there is not much you can do here in the list to avoid the threshold limit…as an alternative you could try either to use search to create your view or some custom development Sep 06 2017 11:18 PM Sep 06 2017 11:18 PM Re: Is it possible to filter a lookup column using a specific criteria?
Here I am trying to filter data based on created date. At 1st I tried in Graph Explorer and it’s working. Now trying to implement same in Dell Boomi. This is resource path to pull all the items: sites/ {id}.sharepoint.com:/sites/ {id}:/lists/ {list_id}/items it’s working fine. Here is getting error. This is the error message:
There’s more details available about how to use the SharePoint REST API to retrieve fields on MSDN here: https://msdn.microsoft.com/en-us/library/office/dn600182.aspx To call the SharePoint REST API, you’ll need to know the URL for the SharePoint site/list, and get an access token for that SharePoint tenant as well.