Filter & Order my SharePoint list using index columns is raising error "Attempted operation is prohi

Iron Contributor

I have this GetItems action inside my Power automate flow:-

 
 

image.png

 

 

the SharePoint list contain around 140,000 items. and all the fields that are involved in the above Filter and OrderBY are already added to the lists indexes 4 months ago.

so why i am getting this error :-

 

 

image.png

 

 

Here are my fields types:-

 

- FY is a choice column

- Design Period is a choice colum

- DesignTypeOrder is a Number

- HealinesReferecne is a single line of text

- DientionOrder is a Number

- LangaugeOrder is a number

 

 

any advice? why i am getting threshold error on a query that include index columns?

0 Replies