Bypass limitation delegation in sharepoint list count items

(0) Share

Report

Posted on by Sormick

566

Hello,

I have created this formula below which count rows on my sharepoint list:

CountRows(Filter(Archiving;TextInput2.Text in Titre))

I have at least 50 000 item rows on my sharepoint list. I need to bypass 2000 rows limitation.

Maybe with an automate flow? or another filtering formula that bypasses the delegation limitation?

Any suggestion?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi Sormick

I will not go the big collection route as 50k is just too much - you could try Power Automate (this video is a good start), but expect this to take quite some time returning that amount of data. This however is Delegable providing the rows returned are under 2,000.
With( { _Data: Filter( Archiving; StartsWith( Titre; TextInput2.Text ) ) }; CountRows(_Data) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
scalca 254 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'd recommend to use a flow to get what you want

it's easy and fast

with the flow you can use the SharePoint api where you can use /itemcount function on the list (Send HTTP Request to SharePoint)
return this number to the app and display the value
currently it is not possible to directly call SharePoint API within PowerApps directly.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Thank you for your reply.

I followed this video below which seems to be the best way to search on my sharepoint list which contains more than 10 000 rows.

Search SharePoint In Power Apps With No Delegation Warning

I get an error on the "Get elements" on this code:

Substringof('@{triggerBody()['text']}',Titre)

or

Substringof('SearchTerm',Titre)

I get this message error on this code:

"The action to "get elements" failed . Substringof is not supported or his use is incorrect"

What is going wrong here?

Please note that i'm using a french version of the power automate.

Maybe the Substringof is only for english version?

Please help me.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Please find here below a screenshot of my function which has an error. . The "Titre" at the end of this function is the name of my column name of my sharepoint list.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Hello,

This function: Substringof, exists for the flow: "Get sharepoint items'"

But i get an error on this function:

What i need to rectify on this function?

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Sorry because in contrary what i said on my previous post the substringof function is not available on my flow. Maybe should i use another function like contains function?

Coudl you help me please?

Was this reply helpful? Yes No