Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Gallery List has Stopped Functioning - Error with Lookup Column Threshhold



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. 




Super User
Super User

Hi @SamR ,

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

Frequent Visitor

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. 

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.

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,698)