cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Resolver I
Resolver I

Re: Gallery not showing all items

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

Highlighted
Helper I
Helper I

Re: Gallery not showing all items

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
Highlighted
Resolver I
Resolver I

Re: Gallery not showing all items

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

Highlighted
Helper I
Helper I

Re: Gallery not showing all items

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

Highlighted
Resolver I
Resolver I

Re: Gallery not showing all items

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.

Highlighted
Helper I
Helper I

Re: Gallery not showing all items

Excellent, thank you @andrewichert.

Highlighted
Helper II
Helper II

Re: Gallery not showing all items

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?

Highlighted
Resolver I
Resolver I

Re: Gallery not showing all items

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

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 (7,645)