I have a mobile app where I was getting data from a SharePoint list. One day my app stopped working and I got the error message about too many lookup columns. Despite they were just 12, I have deleted 2 of them and now they are 10. I have refreshed connection, application etc etc, but still getting the same error.
Also I have tried to build another app and connect to the same list - but I am getting the same error.
When checking the data (in "items" of the gallery) I get the message "we didn't find any data"
and on the monitor I get this error:
"status": 400,
"message": "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.\r\nclientRequestId:
The list has only 10 lookup columns (or person fields)...
I have a copy of the list on another site, and I can connect to that one without problems.
The Sharepoint list works perfectly under sharepoint (forms, workflows, flows etc).
Any idea?
