web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Concat with Groupby

Power Apps

Answered

Concat with Groupby

(1) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

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

Join the conversation