Answered

Unable to load a Sharepoint list

(0) Share

Report

Posted on by marpio

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,547 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @marpio ,

Have you tried removing the list from the data sources in Power Apps, saving and closing, then adding it back in?

Was this reply helpful? Yes No
marpio on at

Like (0)

Report
Copy link

Link copied!

I have already tried to open this list with a brand new PA application, and I have the same result... the problem is in the way PA approaches this list, or the list itself. But, as I've already said, the list in Sharepoint works perfectly (and it is in a production environment, so I cannot play so much with it)

Was this reply helpful? Yes No
Verified answer

marpio on at

Like (0)

Report
Copy link

Link copied!

After 3 days PowerApps "realized" that something was changed in Sharepoint. So lesson learnt: it may take up to several days before you have a reliable communication/integration between the PA and SP. So far you can just wonderwhy it this happening...

Was this reply helpful? Yes No