Concat with Groupby

(1) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No