cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gazzo1967
Impactful Individual
Impactful Individual

Requested Operation Invalid: he query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator

Hi All
I am trying to build a calendar app with a booking form.
It was working fine until today and now i am receiving the following

 

The requested operation is invalid. Server Response: BA TAC Vent failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator. clientRequestId: 

 

my collection formula is this

 

ClearCollect(tvcal,'BA TAC Vent');
Set(_dateSelected, Today());
Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()),Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days));

Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth,1, Months), -1, Days));

Set(_minDate,DateAdd(_firstDayOfMonth,-(Weekday(_firstDayOfMonth) - 2 + 1),Days));

Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1),Days),40,Days))

 

 

the form had some lookups on it but i have deleted the form saved and restarted with the same error

I know about the 12 lookup limit but why would it all of a sudden give me a fault?


I have even rolled back to my build to the version from 24 hrs before

 

Is this because i am loading all my columns into my variable?
If so how do you filter by the columns that you want to use?



any help would be greatly received
Gary

1 ACCEPTED SOLUTION

Accepted Solutions
gazzo1967
Impactful Individual
Impactful Individual

Hi All
Just for other peoples information
My app is linked to a Sharepoint Calendar(List)
the reason for this 'error' is that i had 13 lookup fields 
the default limit is 12
Once i removed 4 fields it all worked fine 🙂


when using lookup fields ensure that you include Created by, Modified by (and Attendees if using calendar) in your lookup count.


Gary 🙂

View solution in original post

1 REPLY 1
gazzo1967
Impactful Individual
Impactful Individual

Hi All
Just for other peoples information
My app is linked to a Sharepoint Calendar(List)
the reason for this 'error' is that i had 13 lookup fields 
the default limit is 12
Once i removed 4 fields it all worked fine 🙂


when using lookup fields ensure that you include Created by, Modified by (and Attendees if using calendar) in your lookup count.


Gary 🙂

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,637)