cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MB
Level: Powered On

Gallery not refreshing correctly

On an iPad, the Gallery has stopped showing all records.  Initially all records are shown (e.g. 309 rows), but if I edit one of the records, then SubmitForm, the Gallery then only shows the top 100 records and will no longer scroll past that limit as it did prior to editing an entry.  Works fine on the PC (running from the Web Designer) but not the iPad.

17 REPLIES 17
Community Support Team
Community Support Team

Re: Gallery not refreshing correctly

What data source you used here?

Would you please also share the formula used under the items property of the Gallery control?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MB
Level: Powered On

Re: Gallery not refreshing correctly

Data Source is a SharePoint List, and formula is:

 

Sort(Sort(Filter(CRM_RouteStores,AreaManagerDescription=AreaManagerSelection.Selected.Result, Title="Current"),BuyingGroup),CustomerName)

 

Gets all records, until such time as I edit one and SubmitForm, after that it only retrieves the Top 100.

 

Thanks

 

Mike

Power Apps Staff ShantanuP
Power Apps Staff

Re: Gallery not refreshing correctly

Does it show more data if you try to scroll down in the gallery on Ipad? Does it work correctly in browser if you open the app?

MB
Level: Powered On

Re: Gallery not refreshing correctly

No, on the iPad it initially shows all records if I scroll, but after I edit one the it only shows the top 100 and won't then scroll any further.  Tried using the iPad App, then re-tried via Safari to PowerApps OnLine.  Same result for both.

 

It does however work fine on a PC in a browser.

 

Power Apps Staff ShantanuP
Power Apps Staff

Re: Gallery not refreshing correctly

Can you try one more thing? Can you change the expression on gallery to bind to below expression.

Gallery.Items = FirstN(CRM_RouteStores, 300)?

 

Does it work correctly now? I am trying to isolate what could be the issue. 

MB
Level: Powered On

Re: Gallery not refreshing correctly

Yes, that does work correctly.  Can edit and will still show all records.

Power Apps Staff FilipK
Power Apps Staff

Re: Gallery not refreshing correctly

Do you use a Combo box inside the gallery?  There is a known issue with gallery scrolling if it has a combo box inside.

- not filipk@microsoft.com, please private message me if you can't share with everyone
MB
Level: Powered On

Re: Gallery not refreshing correctly

No I don’t.  There’s just a text field with the store name, and an icon used to go to the edit form.

netmarie
Level: Powered On

Re: Gallery not refreshing correctly

I am suddenly experiencing this issue as well (on a PC). It is very inconsistent but is happening with more than one user.  The selected set of data has 130 records.  Sometimes all of it will be displayed in the gallery and sometimes it is locked at 100 records.  Refreshing the browser and starting over helps most of the time but not all.  I just tried adding the FirstN( , 300) suggested in this post and that seems to help but don't want to keep that for good.  Is there another answer?  Here is the formula: 

SortByColumns(Filter('[dbo].[viewEmpDataSalEntries]',DeptCd=DT_currentDept.Selected.DeptCd),"LName",Ascending,"FName",Ascending)

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,046)