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

Answered

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

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @geroagos,
Try using below formula -

Concat(Distinct(ThisItem.DATA,'EU Name'),Value, "; ")
geroagos 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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')
)
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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")

Join the conversation