GroupBy Displayname in Gallery

[gchris7]

Hi All,

Im trying to Create an A gallery that will display some Data pulled from a Sharepoint list. I want the data to be grouped by the DisplayName of a persons Field in that list but it doesnt seem to work.

Im using the following formula:

GroupBy(MySharepointList,"MyUserField.Displayname","GroupByUsersDisplayName")

The grouping works properly when i use a simple text field from that same list.

Also is this possible to do it using a table in Powerapps or Gallery is the only way?

Thanks in advance!

[gchris7]

Anyone knows how this can be done?

[lesaltzm · Accepted solution]

Hi there!

Unfortunately we don't currently support nested relationships in GroupBy, i.e "Myuserfield.DisplayName".

To make this work, you need to add the field you want to groupby as it's own column.

Try:

GroupBy(AddColumns(MySharepointList, "UserDisplayName", MyUserField.DisplayName), "UserDisplayName", "GroupByUsersDisplayName")

Let me know if this works for you!

lesaltzm

[gchris7]

Thank you lesaltzm. It worked great!

Now im trying to add the jobtitle of these users but im getting errors again. I tried the bellow but nothing worked.

GroupByUsersDisplayName.MyUserField.JobTitle

GroupByUsersDisplayName.UserDisplayName.JobTitle

AddColumns(GroupByUsersDisplayName, "JobTitle", MyUserField.JobTitle)

Any ideas?

[gchris7]

Bumping this, incase someonw knows a solution for my second question