web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Concat and distinct

Power Apps

Answered

Concat and distinct

(0) Share

Report

Report

Posted on by PapithaSekar1

100

I have nested gallery and I am trying to concat the value from nested gallery and displaying it in Parent gallery.

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

Below are the formulas.

Parent Gallery Item property:

GroupBy(SortByColumns(Filter('datasource1',Uke = Value(Ti_SumWeekNum.Text) ),"bk_timex"),"bk_date","GroupedbyVactype" )

Nestedgallery item property:

ThisItem.GroupedbyVactype

Text box default property:

Concat(ThisItem.GroupedbyVactype,Concatenate(Vaksinetype,","))

Result:

Moderna,Moderna,Moderna,Pfizer

Required result:

Moderna,Pfizer

Can someone help me to achieve this

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PapithaSekar1,

Based on the issue that you mentioned, do you want to display distinct values in the Text box?

Could you please tell me that how you configure your nested gallery, does this duplicated value display in the Parent Gallery?

I have a test on my side, pleas take a try as below.

Concat( Distinct( Split( Concat( ThisItem.GroupedbyVactype, Concatenate( Vaksinetype, "," ) ), "," ), Result ), Result, "," )

Regards,

Qi

Was this reply helpful? Yes No
PapithaSekar1 100 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I worked

Was this reply helpful? Yes No
Neethu 8 on at

Like
a
(0)

Report
Copy link

Link copied!

In my gallery I have a field ThisItem.HType which contains values seperated by comma like a,b,a,b,c,b,c,a. I created a variable "harddup" and set it as the default of a textbox. But I want to take only the distinct values from this and show the distinct values(a,b,c) in the textbox . Could you please help me get this done

Was this reply helpful? Yes No

Join the conversation