Remove duplicates on gallery and display all values on a label

(0) Share

Report

Posted on by nagestiada

504

Hello guys,

I have a gallery on the left side but the problem is all of the records on sharepointlist are being showed but I only want to show the group or removing the duplicates by UserID column

UserID	Color
123	Red
456	Green
123	Yellow

so I want the gallery to show

UserID

123

456

and when I click the user ID 123

the label will show the Color Red;Yellow

I have this formula on my label but it only shows two ; but I want to show Color column

Concat(
Filter(
 MyList,
 'UserID' = Gallery1.Selected.'UserID'
).Color,";")

Any help would really be appreciated

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Main Gallery Item Property: GroupBy("DS",UniqueId,"DATA")
DATA is just name. You can give anything. Data means whatevers in the database except "UniqID"
Add sub gallery inside the main gallery:
Sub gallery item property: Thisitem.DATA
In my case. I have common scope value that shares different names
Also sorry for the confusion. Please look "TimeAsText=Scope" in my database. I renamed the column afterwards hence the name difference.
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks but how do I add a filter on the groupby?
Spoiler (Highlight to read)
Filter(MyList,Category= ComboBox2.Selected.Result,Email=User().Email,Confirmed="No")
Filter(MyList,Category= ComboBox2.Selected.Result,Email=User().Email,Confirmed="No")
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Think of the whole filter query as source to Group by
Group By(filterquery,uniq,data) like that
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it but when I select the subgallery nothing happens

Gallery2.Selected.ColumnName

but nothing happens 😞
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Where are you writing Gallery2.Selected.Columname.
There is no need.
Let me explain. When you groupby colum name in your case uniqueid. And give group name DATA as i suggested. DATA becomes table containing all the records except unique id. Because that's the colum you are grouping by.
Now when you add subgallery. It's not an individual gallery. But add it as you add label in main gallery.
You select that pencil icon on your main gallery. Go to gallery and insert.
So everyrow of your main gallery contains one sub gallery.
And that sub gallery has item property named "Thisitem.Data"
I know i sound confusing. Shane has an amazing video on it. I will share the link
https://youtu.be/MDhIjM08u-w