14 Comments

1. 

   William Young on January 6, 2021 at 1:53 pm

   This is great work Reza!
   I’ve created a version and am trying it out
   Thanks again for sharing such wonderful content

   • 

     Reza on January 12, 2021 at 2:41 am

     Thank you

2. 

   Christer Russberg on January 6, 2021 at 3:47 pm

   Hi Reza,
   I am trying to re-create this “Paginated PowerApps”.
   Most of it work but I have problem to get all info from my datasource.
   My source is a SharePoint list with about 200 records.

   I have added the designelement that you describe but I ony get 100 rows back in my hidden gallery.
   I am missing some part and I hope you can help me.
   Your add a filter to the hidden gallery in your video but this does not work for me.
   For the “Items” property I only have my SharePoint list reference.

   • 

     Reza on January 12, 2021 at 2:42 am

     Hi Christer,

     Are you getting any delegation warnings in your App?

     • 

       Christer Russberg on January 26, 2021 at 2:58 pm

       Hi,
       No I don’t get any delegation warnings-

3. 

   CZTop54 on January 9, 2021 at 4:04 pm

   This was super helpful and worked the very first time! I love it!

   I’d like to also add a Text input box so I can search on the string/text fields. Possible to provide some guidance on that?

   • 

     Reza on January 12, 2021 at 2:43 am

     Hi,

     Check https://youtu.be/5dSk5iOgT68

4. 

   Ramole on January 11, 2021 at 9:23 am

   Hi Reza
   How can i join with my groupBy formula i have on my gallery please
   Sort(
   AddColumns(
   GroupBy(
   AddColumns(
   Filter(
   MyChecks,
   (ControlComboBox_8.Selected.theStatus = “Show All” || Status.Value = ControlComboBox_8.Selected.theStatus) &&//&&(Toggle1.Value = true|| COD_x002d_Received=false=Toggle1.Value ) && // NEW ADDED FOR COD TO FILTER
   //OrderDate = Text(DatePicker1_1.SelectedDate,ShortDate) &&
   (IsBlank(SearchText_19.Text) || SearchText_19.Text in Check_x0020_Number || SearchText_19.Text in Invoice_x0020_Number || SearchText_19.Text in Text(ID) || SearchText_19.Text in Business_x0020_Name)
   ),
   “Companyvalue”,
   Business_x0020_Name
   ),
   “Companyvalue”,
   “NewGroup”
   ),
   “SumShippingFee”,
   Sum(
   NewGroup,
   amount
   ),
   “TotalCOD”,
   Sum(
   NewGroup,
   amount
   ),
   “Status”,
   First(
   Sort(
   NewGroup,
   Status.Value,
   Descending
   )
   ).Status.Value,
   “Email”,
   First(
   Sort(
   NewGroup,
   Emails,
   Descending
   )
   ).Emails,
   “ID”,
   First(
   Sort(
   NewGroup,
   ID,
   Descending
   )
   ).ID,
   “Phone”,
   LookUp(
   Customers,
   Title = Companyvalue
   ).’Business Phone’,
   “Address”,
   LookUp(
   Customers,
   Title = Companyvalue
   ).Address & ” – ” & LookUp(
   Customers,
   Title = Companyvalue
   ).City & LookUp(
   Customers,
   Title = Companyvalue
   ).’State/Province’ & ” – ” & LookUp(
   Customers,
   Title = Companyvalue
   ).’ZIP/Postal Code’,
   “Comments”,
   First(
   Sort(
   NewGroup,
   note,
   Descending
   )
   ).note,
   “Modified”,
   First(
   Sort(
   NewGroup,
   Modified,
   Descending
   )
   ).Modified,
   “CheckDuedate”,
   First(
   Sort(
   NewGroup,
   Date_x0020_due,
   Descending
   ).Date_x0020_due
   ),
   “OrderDatesFull”,
   First(
   Sort(
   NewGroup,
   Created,
   Descending
   )
   ).Created,
   “Pending Invoices”,
   CountRows(NewGroup),
   “Check Number”,
   First(
   Sort(
   NewGroup,
   Check_x0020_Number,
   Descending
   )
   ).Check_x0020_Number
   ),
   OrderDatesFull,
   Descending
   )

   With
   If(
   icoNext.DisplayMode = Disabled,
   // Handling last set of records
   LastN(
   FirstN(
   galHidden.AllItems,
   drpPaginationSize.Selected.Value * varPageNumber
   ),
   drpPaginationSize.Selected.Value – (drpPaginationSize.Selected.Value * varPageNumber – CountRows(galHidden.AllItems))
   ),
   LastN(
   FirstN(
   galHidden.AllItems,
   drpPaginationSize.Selected.Value * varPageNumber
   ),
   drpPaginationSize.Selected.Value
   )
   )

   Thanks

   • 

     Reza on January 12, 2021 at 2:45 am

     Hi Ramole,

     I would have to have access to your App and data source to check this one.
     I cannot solve it by looking at the formula.

5. 

   Mohammed Bilal M on January 17, 2021 at 1:39 am

   Hi Reza,

   Thanks for sharing an excellent Article! I have a list with more than 5000 items and i would like to load all items to GalleryHidden at App Start stage. Can you help me on this? Thanks in advance.

   • 

     Reza on January 18, 2021 at 1:47 am

     You should not be loading 5000 items. If your hidden gallery supports delegation, it will automatically handle optimized loading of items.
     To learn more about delegation – https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

6. 

   Christer Russberg on January 26, 2021 at 3:18 pm

   Hi,
   No I don’t get any delegation warnings.

   I use line below in my hidden gallery wherer “LargePersonList” is my SharePoint list.

   Filter(
   LargePersonList,
   StartsWith(
   Title,
   txtUserName.Text
   )
   )

7. 

   madi on January 31, 2021 at 10:51 pm

   hi reza
   I think you forgot the part of resetting it .

   • 

     Reza on March 7, 2021 at 6:12 pm

     It’s a part of the video. May be got edited out.