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

Collection in table view is repeating rows

Hi

 

I have created an app that loads data from a sql database into a collection, then displays this data using a textinput filter in a table for the user to pick a customer from.  This all works fine but once  a customer is picked and the user navigates to the next screen all the data is repeated in the table until the data is re-loaded.  The user will need to go through the app process at least 5 times per day without reloading data (i.e. when they have a connection) so would end up with the rows repeated 5 times.  There are no Loaddata functions in this sequence - can anybody help or explain this?

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
JRaasumaa
Level 10

Re: Collection in table view is repeating rows

Are you using ClearCollect to fill the collection after the data has changed or just Collect?

 

If you are using just collect it will append to the existing collection which will show duplicates potentially.

View solution in original post

2 REPLIES 2
JRaasumaa
Level 10

Re: Collection in table view is repeating rows

Are you using ClearCollect to fill the collection after the data has changed or just Collect?

 

If you are using just collect it will append to the existing collection which will show duplicates potentially.

View solution in original post

Sos
Level: Powered On

Re: Collection in table view is repeating rows

Hi  I am doing a clearcollect when connected otherwise it uses loaddata - which i think was part of the issue as the load data appends the data. However even when this button is not used and  just use navigate function - the data duplicates i have put a count on each page showing the number of rows in table and it doubles each time the user selects a custromer from the table.

 

It is very strange 

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 308 members 5,505 guests
Please welcome our newest community members: