Answered

Unable to GroupBy with Sharepoint List field set to Persons/Group

(0) Share

Report

Posted on by Community Power Pla...

Hi community,

Is there still an issue with the GroupBy if the field in Sharepoint is Person/Group? My script below won't work, even I know that it is correct, still getting the red underline. What could I possibly be missing here?

ProjectLead1 is a Persons/Group column in my Sharepoint list.

GroupBy(AddColumns(Project_Tracker, "LeadNames", ProjectLead1.DisplayName), "LeadNames", "ProjectGrouped")

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@Anonymous
The display name is a person field cannot be accessed directly using AddColumn so the solution is to use ForAll to build the table instead.

GroupBy( ForAll( Project_Tracker, {LeadNames: LeadNames, ProjectLead1: ProjectLead1.DisplayName} ), "LeadNames", "ProjectGrouped" )

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you @mdevaney, I fixed this one by changing my field in Sharepoint to Single selection only for this. Still your script is an alternative solution.

Was this reply helpful? Yes No