Unanswered

Gallery List has Stopped Functioning - Error with Lookup Column Threshhold

(0) Share

Report

Posted on by SamR

Hello,

I expect my question is more of a lack of knowledge than any sort of technical issue. I have a Gallery that loads on the front page of my app that previously worked without issue. Over the weekend something seems to have changed and now the gallery no longer loads - stating the operation has failed stating "The number of lookup columns it contains exceeds the lookup column threshhold".

I am not sure what happened as I made no changes to my app in the past several days, and am not sure how to go about fixing it. Any advice on what may have happened or what I need to do?

Reference photos below. Thank you very much for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @SamR ,

How many columns of Lookup type do you have in your SharePoint list? Does this article apply?

Was this reply helpful? Yes No
SamR 30 on at

Like (0)

Report

Hi Warren,

I am honestly not sure - several in this case. Is the count based on the entirety of the the Sharepoint website or the specific list the the gallery is trying to access?

I did make NEW lists over the weekend that have their own lookup columns, but I did not expect any of them to affect previously existing lists/apps.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @SamR ,

It is per list - you might have a read of this blog of mine and reconsider the use of these columns.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No