Distinct Concatenated Label

[mglemser]

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!

[WarrenBelz · Accepted 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

[mglemser]

This worked - thank you!