web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Distinct and concatena...

Power Apps

Unanswered

Distinct and concatenate Formulas

(0) Share

Report

Report

Posted on by geroagos

14

I have a gallery with a textbox in which I'm trying to Concat values and delete the duplicated.

Concat is working fine, Need help to use distinct with the result:

Gallery Item property:

GroupBy(Table1,"EID","DATA")

Text box property:

Concat(ThisItem.DATA,'EU Name', ";")

Result:

Jhon;Jhon;Gabriel;Carl;Carlo

Required result:

Jhon;Gabriel;Carl

Table1= my DataSource

EID= The column I used to GroupBy

DATA= The column I created to unify the GroupBy values

EU NAME= A column with user names to display

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Hi @geroagos,
Try using below formula -

Concat(Distinct(ThisItem.DATA,'EU Name'),Value, "; ")

Was this reply helpful? Yes No
geroagos 14 on at

Like (0)

Report

Thank you! That works.
I would need also to assing a Filter (formula bellow) to the Gallery but I have the formula: "GroupBy(Table1,"EID","DATA")".
Is it possible to have both of them?

Filter(Table1,
(IsBlank(SearchBox.Text) || SearchBox.Text in EID)
&&
(IsBlank(SearchBox2.Text) || SearchBox2.Text in 'EU Name')
)

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Hi @geroagos ,
Yes, it is. Try using below -

GroupBy(Filter(Table1, (IsBlank(SearchBox.Text) || SearchBox.Text in EID) && (IsBlank(SearchBox2.Text) || SearchBox2.Text in 'EU Name') ),"EID","DATA")

Was this reply helpful? Yes No

Join the conversation