Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Assistance with 2000 record limit issues

Posted on 27 Nov 2024 22:58:14 by
Hello,
 
I'm running into the 2000 record limit issue with my gallery. I'm trying to follow Raza’s  method with the pagination, but my formula only pulls 2000 records, and my current source has 2002 items. I have pasted my "OnStart" formula, GalleryHidden, and Gallery2 Formula. Thanks!
 
 

OnStart Screen Formula

  

Set(popUpVis, true);

 

Set(varSortColumn, "ID");

 

Set(varSortDirection, SortOrder.Descending);

 

Set(varDelegationLimit, 500);

 

// Clear and collect data directly from your data source

 

ClearCollect(

 

    CollectionName,

 

        'Virtual Personnel Portal Ticket'    

 

);

  
 

GalleryHidden Formula 

  

Filter(

 

    CollectionName,

 

    // Section filtering

 

    If(

 

        Gallery1.Selected.Value = "All",

 

        true,

 

        'FSS Section' = Gallery1.Selected.Value

 

    ) &&

 

    // Ticket status filtering

 

    (

 

        IsBlank(ComboBox1.SelectedItems) ||

 

        'Ticket Status' in ComboBox1.SelectedItems

 

    ) &&

 

    // Additional section filtering

 

    (

 

        IsBlank(ComboBox1_1.SelectedItems) ||

 

        'FSS Section' = ComboBox1_1.Selected.Value

 

    ) &&

 

    // Technician filtering

 

    (

 

        IsBlank(ComboBox1_3.SelectedItems) ||

 

        Technician = ComboBox1_3.Selected.Value

 

    ) &&

 

    // Text search filtering

 

    (

 

        IsBlank(IDFilter_1.Text) ||

 

        StartsWith(Text(ThisRecord.ID), IDFilter_1.Text) || // Correctly converting ID

 

        StartsWith('Last Name', IDFilter_1.Text) ||

 

        StartsWith(Technician, IDFilter_1.Text) ||

 

        StartsWith(Issue_Text, IDFilter_1.Text) ||

 

        StartsWith('Customer Comment', IDFilter_1.Text)

 

    )

 

)

 

 

Gallery2 Formula 

  

If(

 

iconNext.DisplayMode = DisplayMode.Disabled,

 

// Handling last set of records

 

LastN(

 

FirstN(

 

GalTicketHidden.AllItems,

 

drpPaginationSize.Selected.Value * varPageNumber

 

),

 

drpPaginationSize.Selected.Value - (drpPaginationSize.Selected.Value * varPageNumber - CountRows(GalTicketHidden.AllItems))

 

),

 

LastN(

 

FirstN(

 

GalTicketHidden.AllItems,

 

drpPaginationSize.Selected.Value * varPageNumber

 

),

 

drpPaginationSize.Selected.Value

 

)

 

)


 
 
 
  • WarrenBelz Profile Picture
    WarrenBelz 143,137 on 28 Nov 2024 at 00:58:12
    Assistance with 2000 record limit issues
    Assuming you have your Data Row Limit set at 2,000, you can collect up to 4,000 items like this
    With(
       {
          _Asc,
          Sort(
             'Virtual Personnel Portal Ticket',
             ID
          ),
          _Desc,
          Sort(
             'Virtual Personnel Portal Ticket',
             ID,
             SortOrder.Descending
          )
       },
       ClearCollect(
          CollectionName
          _Asc,
          Filter(
             _Desc,
             !(ID in _Asc.ID)
          )
       )
    )
    
     
    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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard