web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / The query cannot be co...
Power Apps
Answered

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by administrator

(0) ShareShare
ReportReport
Posted on by 17

I am creating powerapps form off Sharepoint List. In my list i have 34 columns. Out of them there are field types i am using:

 

Single Line of Text: 4

Multiple Line Of text: 1

Choice: 12

Person and Group: 12 (including Created By and Modified BY)

Date and Time: 2

Hyperlink or Picture: 2

 

Now when i am submitting value after i hit submit button on my powerapps which is executing following method:

 

SubmitForm(Form2);Refresh('Document Change Request');Navigate(Screen1,ScreenTransition.Fade)

 

I am receiving error:

"

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by administrator"

 

I dont know what is happening here. I dont have any lookup column here to start with and why am i getting this:

 

 

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    You have hit the limit on lookup fields (this includes people fields).

    You might check out this article on a potential to get around it.

    Also, review the responses in the other thread you posted this in - they are spot on.

  • schuess3 Profile Picture
    353 on at

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard