Hi everyone,
I am having difficulty showing distinct values in a label within a GroupBy gallery.
The Gallery Item code is: GroupBy(Table13,"CO Number","CO State","Change Owner Name","DATA"
The code I have for the label is: Concat(ThisItem.DATA,'Affected Item Name',";")
Since Affected Item Name may show multiple times for each Change Order, it is showing duplicates in the label. Does anyone know how I can concat distinct within a label on a gallery using the GroupBy function?
Thanks in advance!
Solved! Go to Solution.
Hi @mglemser ,
Try this
Concat(
Distinct(
ThisItem.DATA,
'Affected Item Name'
),
Result &
";"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @mglemser ,
Try this
Concat(
Distinct(
ThisItem.DATA,
'Affected Item Name'
),
Result &
";"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
This worked - thank you!
User | Count |
---|---|
257 | |
127 | |
104 | |
49 | |
49 |