Concat with condition

Like (0) Share

Report

Posted on 16 Jan 2023 11:52:42 by Ami K

15,665 Super User 2024 Season 1

Hi everyone,

@WarrenBelz provided a solution to the following post.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Combine-multiple-rows-into-a-single-row-based-on-a-common-field/td-p/1892025

I was wondering if I could take this further and apply a condition to the concat statement?

In the example below, I want to combine multiple rows into a single row based on a common identifier (Role ID) and where the Active column equals “Yes”

Best regards,

Ami

Categories:

General Questions

All responses (2)

Answers (0)

Ami K 15,665 Super User 2024 Season 1 on 16 Jan 2023 at 21:05:07

Like (0)

Report
Re: Concat with condition

Thanks for the solution @Drrickryp.

Long shot, but is there a way to do this without filtering the source table? There could be a scenario in future where I need to concat an additional column from the same table, but without filtering on active.

ClearCollect( col_ConcatEmployees, AddColumns( GroupBy( People_Data, "cr37a_role_id_display", "Data" ), "Assigned Employees", Concat( Data, new_employeename, ", " ), "People_RecordID", Text( Concat( Data, new_people_dataid, ", " ) ) ) );
Drrickryp Super User 2024 Season 1 on 16 Jan 2023 at 14:04:40

Like (1)

Report

Re: Concat with condition

@Amik

With({_items: Filter( People_Data_Table, Active ='Yes')},

AddColumns(
GroupBy(
_items,
"Role ID",
"Data"
),
"Role",
First(Data).Role,
"Assigned Employees",
Concat(
Data,
Name,
","
)
)

)