Concat with Groupby

(1) Share

Report

Posted on by JR-BejeweledOne

5,836 Super User 2025 Season 1

I have this setup in a gallery which provides the result in the image.

ClearCollect(
RequestIndex,
DropColumns(
AddColumns(

GroupBy(

Filter(AllRequests, RequestStatus = "Submitted" And AuthorManager = varUser),
"RequestNumber", "Submitter","Result"),
"Employees",
Concat(Result, Title & Char(10))

),
"Result"
)

)

What I would like to do is to have the concat to return not only the title but a combination of the Title and Approver columns, looking something like this, but am not sure how to add the approver piece into the equation. I tried a couple things and failed miserably 😬:

Hickok, Jane - Washington, George

Doe, John - Hancock, John

User, Jeremy - Gwinnett, Button

Categories:

General Questions

All responses (2)

Answers (1)

JR-BejeweledOne 5,836 Super User 2025 Season 1 on at

Like (1)

Report

Re: Concat with Groupby

I thought I had tried that already, not sure what I did that didn't work, but this worked! Thanks
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: Concat with Groupby

@JR-BejeweledOne

Assuming that Approver is a person column in your list...consider the following formula:

ClearCollect( RequestIndex, DropColumns( AddColumns( GroupBy( Filter(AllRequests, RequestStatus = "Submitted" && AuthorManager = varUser), "RequestNumber", "Submitter", "Result" ), "Employees", Concat(Result, Title & Approver.DisplayName & Char(10)) ), "Result" ) )

I hope this is helpful for you.