
Announcements
I have this Get All Items where i define the threshold to be 100,00 as follow:-
now on runtime >> i will get this error , any advice how to fix this error?
The attempted operation is prohibited because it exceeds the list view threshold.
now if we change the order of the Filter Query to be :-
FY eq '<<>>' and Design_x0020_period eq '<<>>'
instead of :-
Design_x0020_period eq '<<>>' and FY eq '<<>>'
the error will be gone.. so what is the reason? could this be that the first query FY eq '<<>>' return a lot of items? unlike the Design_x0020_period which will return small number of items?