You’re offline. This is a read only version of the page.
Announcements
Hello PowerApps Community,
I have a similar Dataset as below which I am trying to show in my PowerApp
| ID | Category | Name |
1 | Category A | Sample name 1 |
| 2 | Category A | Sample name 2 |
| 3 | Category A | Sample name 3 |
| 4 | Category B | Sample name 4 |
| 5 | Category B | Sample name 5 |
| 6 | Category C | Sample name 6 |
| 7 | Category C | Sample name 7 |
| 8 | Category C | Sample name 8 |
| 9 | Category C | Sample name 9 |
From the above source table I only want to show each category only once with the highest ID for that category, and also the corresponding name. For example see the below table.
| ID | Category | Name |
| 3 | Category A | Sample name 3 |
| 5 | Category B | Sample name 5 |
| 9 | Category C | Sample name 9 |
I appreciate if anyone can help. Thanks in Advance
Hi @SriKandimalla ,
I did a demo for you.
1\ This is my list .
2\ Add a gallery control and set its Items property to:
Share
Report
All responses (
Answers (
Filter(ForAll(Distinct(LIST154,Category),First(Sort(Filter(LIST154,Category=Result),ID,Descending))),!IsBlank(ID))
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.
796
