Forum Discussion

kompas_ua's avatar
kompas_ua
Advocate I
10 years ago

Get data from SharePoint Online Lists: Lookup columns threshold

Hello Everyone,   When I try to get data from SharePoint Online list I receive the error:   DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Serve...
Need Help
Zwakele's avatar
Zwakele
Frequent Visitor
9 years ago

Hi 

 

Did you find a solution for this?

 

kompas_ua's avatar
kompas_ua
Advocate I
9 years ago

First workaround I’ve found is a OData query.

 

The strategy is to split the wide list. Try to create a several queries from a list, and then merge it into one wide table (joined by ID column). In this case you should create OData query manually for each chunk of the list.

For example:

 

let

Source1 = OData.Feed("https://###.sharepoint.com/teams/Projects/_api/web/lists/GetByTitle('Project List')/items()/?$select=Id,Title,Market/Id,Market/Title&$expand=Market")

in

Source1