web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Concatenate value from...

Power Apps

Unanswered

Concatenate value from same column

(0) Share

Report

Report

Posted on by Wilder16261626

16

Hi

I have below code that generate a table that look like below:

Sort(
 Filter(
 INCO_REQUESTS;
 Status = "Submitted for Action" And IsBlank(Email)
 );
 Submitted_Time;
 Ascending
 )

What i'm looking for is to be able to concatenate "First_name" column based on "Last_name" column.

So if we look at the table above, we have 2 time "Carlson". So both first name would get concatenated separated by a comma like below:

How can this be done?

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Wilder16261626 ,

Not easily, but the below should work

AddColumns( GroupBy( Sort( Filter( INCO_REQUESTS; Status = "Submitted for Action" && Email = Blank() ); Submitted_Time ); "LastName"; "Data" ); "FirstName"; If( CountRows(Data) > 1; With( { wFirst: Concat( Data; First_name & "," ) }; Left( wFirst; Len(wFirst) - 1 ); First(Data).First_name ) ); "Status" First(Data).Status )

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

Was this reply helpful? Yes No
Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks WarrenBelz
I will need to work it out a little, and will get back to you once working or if i have questions.

Was this reply helpful? Yes No
Wilder16261626 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WarrenBelz, I did not have the chance to make it work yet, but will let you know once i'm able to.

Was this reply helpful? Yes No

Join the conversation