web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to ensure that my ...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation