Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Gallery List has Stopped Functioning - Error with Lookup Column Threshhold

(0) ShareShare
ReportReport
Posted on by 30

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. 

SamR_0-1629750847127.pngSamR_1-1629750877962.png

 

 

Categories:
  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    Re: Gallery List has Stopped Functioning - Error with Lookup Column Threshhold

    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.

  • SamR Profile Picture
    30 on at
    Re: Gallery List has Stopped Functioning - Error with Lookup Column Threshhold

    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. 

  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    Re: Gallery List has Stopped Functioning - Error with Lookup Column Threshhold

    Hi @SamR ,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard