How to ensure that my apps shows only one line despite having multiple lines in my excel

[Tioluwalope]

My data is in excel on onedrive for business. I have a table that has repeated items in a column and when I connect it to power apps the item is repeated. How can I ensure that the The item occurs only once on my app and also sum up the quantities for the item in my app in a single line?

[v-xiaochen-msft · Accepted solution]

Hi @Tioluwalope ,

According to your description, I've made a test for your reference:

1\ This is my excel table:

// Company column has duplicate values ‘A’,’B’,’C’.

2\ Add a gallery control and set its Items property to:

ForAll(Distinct(Table1,Company),{Number:CountRows(Filter(Table1,Company=Result)),Company:Result})

3\ The result is as follows:

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.