cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerApp - List dosen't loading all date at once.

Hello!

 

When I open my app with sharepoint list all data does not loading at once. The rest of list is loading after scrolling the list.

 

As I was saw list display only about 100 rows and after scroll to the end the next 100 rows are showing.

 

I don't know what is the problem and where looking solution.

 

Please help!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: PowerApp - List dosen't loading all date at once.

I found solution!

 

Befor I used

SortByColumns(Filter(ListName;  StartsWith(Number_of_Record; TextSearchBox_1.Text) || StartsWith(Title_of_Record; TextSearchBox_1.Text))
; "Number_of_record"; If(SortDescending1; Descending; Ascending))

 

and in that was a problem and I don't know why (strange because syntax is correct).

 

But when I changed it to

 

SortByColumns(Filter(ListName;TextSearchBox_1.Text in Number_of_Record || TextSearchBox_1.Text in Title_of_Record); "Number_of_Record"; If(SortDescending1;Descending;Ascending))

 

suddenly all records is display!

 

 

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: PowerApp - List dosen't loading all date at once.

Give this blog post a read on PowerApps Performance. It might help you understand better what is going on. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted
Frequent Visitor

Re: PowerApp - List dosen't loading all date at once.

I found solution!

 

Befor I used

SortByColumns(Filter(ListName;  StartsWith(Number_of_Record; TextSearchBox_1.Text) || StartsWith(Title_of_Record; TextSearchBox_1.Text))
; "Number_of_record"; If(SortDescending1; Descending; Ascending))

 

and in that was a problem and I don't know why (strange because syntax is correct).

 

But when I changed it to

 

SortByColumns(Filter(ListName;TextSearchBox_1.Text in Number_of_Record || TextSearchBox_1.Text in Title_of_Record); "Number_of_Record"; If(SortDescending1;Descending;Ascending))

 

suddenly all records is display!

 

 

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,406)