Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Bypass limitation delegation in sharepoint list count items

(0) ShareShare
ReportReport
Posted on by 375
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?
 
 
  • Sormick Profile Picture
    Sormick 375 on at
    Bypass limitation delegation in sharepoint list count items
    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?
  • Sormick Profile Picture
    Sormick 375 on at
    Bypass limitation delegation in sharepoint list count items
    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?
     
     
  • Sormick Profile Picture
    Sormick 375 on at
    Bypass limitation delegation in sharepoint list count items
    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.
     
  • Sormick Profile Picture
    Sormick 375 on at
    Bypass limitation delegation in sharepoint list count items
    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.
     
    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.
  • scalca Profile Picture
    scalca 239 on at
    Bypass limitation delegation in sharepoint list count items
    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.
     
  • WarrenBelz Profile Picture
    WarrenBelz 145,475 on at
    Bypass limitation delegation in sharepoint list count items
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard