Navigating the 12 Lookup Column Limitation in Microsoft Graph API for SharePoint List Items
Introduction:
When working with the Microsoft Graph REST API to retrieve data from SharePoint lists, it's essential to be aware of certain limitations. One such limitation involves the number of lookup columns that can be viewed in the API responses.
Limitation: Viewing Only 12 Lookup Columns:
The limitation in question involves the maximum number of lookup columns that can be included in the response when querying for site list items using the Microsoft Graph API. Currently, only the first 12 lookup columns are visible in the API response.
Implications and Workarounds:
If your SharePoint list includes more than 12 lookup columns, you may encounter limitations when trying to retrieve all related data using Microsoft Graph API. In such cases, you might need to use the COZYROC reusable script as a workaround to retrieve data for each list item separately using the endpoint here.
Stay informed about updates and changes to Microsoft Graph API by referring to the official Microsoft Graph documentation.Book a Presales Call
Related Articles
How to setup your client_id and client_secret values to connect with COZYROC Microsoft Dataverse Connector and Exchange Connector
This KB-Article explains how you can setup your own client_id and client_secret values instead of using default COZYROC app client id to connect with Microsoft Dataverse Connector and Exchange Connector. You can do all of your administrative tasks ...How to Add List Members using Dataverse Connector into Dynamic CRM
This idea to generate this KB-Article is to explain with an example how you can execute actions like AddListMemebersList, AddCampaignItem etc. There is a special Resource Action available in Rest Destination for create action that can be use to ...Where can I find the documentation for the Microsoft Graph Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Microsoft Graph Connection can be found at the following link. For many of the components you can ...Error Message: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Operations that exceed the list view threshold are allowed in the following time window defined by the administrator:
Action: While extracting data from list views using the SharePoint Source component, I am receiving the following error: Error Message: 'The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. ...How to Register your app on Azure Portal Quick Start
Registering your application establishes a trust relationship between your app and the Microsoft identity platform. The trust is unidirectional: your app trusts the Microsoft identity platform, and not the other way around. Follow the steps to create ...