cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Gallery not showing all items

Hi,

 

I know this has been asked before but the thread https://powerusers.microsoft.com/t5/General-Discussion/URGENT-Gallery-not-showing-all-items/m-p/4162... didn't answer the question.

 

I have a gallery with a filter on it. The gallery is not showing all the records.

 

New records in particualr are not showing. I know the record is created as I have checked the source sharepoint list.

 

I have tried without the filter - that doesn't work.

 

Can you help please?

 

If the list has more than 500 records would that be a possible cause?

 

Thanks

Phil

2 ACCEPTED SOLUTIONS

Accepted Solutions
Resolver I
Resolver I

Hello @Hepworthnot,

 

your suggestion about the limit record seems to be right.

 

You can do two things to bypass this:

  1. You could just increase the number of the data row limit. Go to File/App settings/Experimental features - there you could set the number.
  2. More preferable: put your data as raw input into a collection and save this collection. After this you could easily access and for example filter your data.

Code example for collecting and saving:

If(
  Connection.Connected,
  ClearCollect(localData, 'YourDataSource'),
  SaveData(localData, "saveLocalData");
  LoadData(localData, "saveLocalData", true)
)

This code checks for a available connection and retrieves the data. If no data is available it will load the already saved data from your cache.

 

Note: in the web browser you will get an error message trying to save a collection. You could easily ignore this, as it will work properly on your device. For just creating the collection ignore the rest and just do the ClearCollect.

View solution in original post

Hi @andrewichert,

 

thanks so much for your swift reply.

 

I have just used solution 1 and it worked perfectly.

 

Solution 2 looks more complicated but I see you say it is preferable. Why do you think it's a better solution? That may persuade me to do the extra work Smiley Happy

 

Cheers

Phil

View solution in original post

6 REPLIES 6
Resolver I
Resolver I

Hello @Hepworthnot,

 

your suggestion about the limit record seems to be right.

 

You can do two things to bypass this:

  1. You could just increase the number of the data row limit. Go to File/App settings/Experimental features - there you could set the number.
  2. More preferable: put your data as raw input into a collection and save this collection. After this you could easily access and for example filter your data.

Code example for collecting and saving:

If(
  Connection.Connected,
  ClearCollect(localData, 'YourDataSource'),
  SaveData(localData, "saveLocalData");
  LoadData(localData, "saveLocalData", true)
)

This code checks for a available connection and retrieves the data. If no data is available it will load the already saved data from your cache.

 

Note: in the web browser you will get an error message trying to save a collection. You could easily ignore this, as it will work properly on your device. For just creating the collection ignore the rest and just do the ClearCollect.

View solution in original post

Hi @andrewichert,

 

thanks so much for your swift reply.

 

I have just used solution 1 and it worked perfectly.

 

Solution 2 looks more complicated but I see you say it is preferable. Why do you think it's a better solution? That may persuade me to do the extra work Smiley Happy

 

Cheers

Phil

View solution in original post

Hi @Hepworthnot,

 

the second solution is preferable because of the limitations of what is delegable in PowerApps (see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview for reference).

 

I always try to collect my data in simple call without any filtering. Afterwards you could filter, sort etc on your collection and even save the result to a new collection as your device has already all the data it needs. You minimize the requests to the server and the result will be much faster as it depends on your device speed once the data is loaded.

 

As a benefit the above code saves the data to the local cache of your device. So you could enter all your data even if the internet connection isn't available.

Excellent, thank you @andrewichert.

I know you said it is much preferable to collect the data and then do the filtering, but when does it become a disadvantage to increase the data row limit? Right now I increased it from 500 to 2000. Will this drastically reduce the App performance?

Hi @nirvana_moksh, it really depends on the size of your data.

 

For example a table with with 40 columns but only 500 entries probably have a much higher impact on your loading speed than a table with 3 columns and 1500 entries. 

 

However it is possible to check your loading time for example with the Chrome Dev tools.The screenshot comes right from Chrome and displays the size, loading speed etc for the first 500 items of a test list.

 

I would recommend a loading time from up to 2 seconds for a once in a while load. But if you're trying to load the data on a screen a user will often visit I would definitely recommend to store the data in the cache.

 

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (2,979)