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

[gazzo1967]

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

[gazzo1967 · Accepted solution]

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 🙂