web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate SharePoint exceeds the...

Power Automate

Unanswered

SharePoint exceeds the list view threshold even result is less than 5000 items

(1) Share

Report

Report

Posted on by VeGETzX

367

Hi expert,

I'm facing error when trying to filter item from my SharePoint list using Send an HTTP request to SharePoint action

My list have ~6500 items and contains many column, for example:

- PeriodStartInt

- PeriodEndInt

- CompanyCodeTxt

All of these column are indexed column

This my GET request query

_api/web/lists(guid'mylistguid')/items?$filter=(PeriodStartInt le 202407 and PeriodEndInt ge 202407) and CompanyCodeTxt eq 'ABC'

And this is error output

I've export all the data into Excel to double check, I can confirm that the expected result with this filter criteria should be just ~50 items.

Thank you in advance.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

sandeepstw 312 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @VeGETzX ,

To resolve the error when filtering items from your SharePoint list using the "Send an HTTP request to SharePoint" action, use these steps -

Query Syntax -
_api/web/lists(guid'mylistguid')/items?$filter=(PeriodStartInt le 202407) and (PeriodEndInt ge 202407) and (CompanyCodeTxt eq 'ABC')

If there is any SharePoint might be threshold limits despite indexing in that case you can use pasination
_api/web/lists(guid'mylistguid')/items?$filter=(PeriodStartInt le 202407) and (PeriodEndInt ge 202407) and (CompanyCodeTxt eq 'ABC')&$top=100

Thanks,

Sandeep Mishra

Was this reply helpful? Yes No

Join the conversation