SharePoint List "Group By" displaying [object Object]

Question

SharePoint List "Group By" displaying [object Object]

Anonymous

Hello!

I have a SharePoint List shared with my team, which displays tasks, each of which have a person in the "Assigned To" and "Assigned By" column. The names are searchable based on people in our organization.

I group the list by Status and then Assigned To. My issue is that when I group by Assigned To, it displays "1 Item is [object Object]

Untitled

The columns themselves are displaying correctly: with the profile pictures and the display name. Multiple selections are not permitted for these fields. It is only in the Group By field were it displays "[object Object]" instead of the field name

Here is my format view code:

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",

"groupProps": {

"headerFormatter": {

"elmType": "div",

"style": {

"flex-direction": "row"

},

"children": [

{

"elmType": "div",

"attributes": {

"class": "=if(@group.fieldData == 'Complete', 'sp-css-backgroundColor-BgMintGreen',if(@group.fieldData == 'In Progress by Assignee', 'sp-css-backgroundColor-BgGold',if(@group.fieldData == 'Pending Action from Approver/Assigner', 'sp-css-backgroundColor-BgCoral','sp-field-borderAllRegular sp-field-borderAllSolid sp-css-borderColor-neutralSecondary')))"

},

"style": {

"display": "inline-flex",

"height": "25px",

"border-radius": "15px",

"padding-left": "8px",

"padding-top": "5px"

},

"children": [

{

"elmType": "span",

"attributes": {

"iconName": "=if(@group.fieldData == 'In Progress by Assignee', 'CirclePauseSolid', if(@group.fieldData == 'Complete', 'SkypeCircleCheck', 'ClipboardListQuestion',if(@group.fieldData == 'Pending Action from Approver/Assigner', 'Blocked','StatusCircleQuestionMark'))))"

},

"style": {

"padding-right": "6px",

"padding-top": "2px"

}

},

{

"elmType": "div",

"style": {

"display": "inline-flex",

"padding-right": "9px"

},

"children": [

{

"elmType": "div",

"style": {

"padding-left": "5px"

},

"attributes": {

"class": "ms-fontWeight-bold"

},

"txtContent": "=@group.count"

},

{

"elmType": "div",

"style": {

"padding-left": "5px"

},

"attributes": {

"class": "ms-fontWeight-normal"

},

"txtContent": "= if(@group.count!= 1,'Items are','Item is')"

},

{

"elmType": "div",

"txtContent": "=@group.fieldData",

"attributes": {

"title": "=@group.fieldData",

"class": "ms-fontWeight-bold"

},

"style": {

"padding-left": "5px"

}

]

}

]

}

]

}

Note: I have found these existing forums but the issue was slightly different and did not resolve my question:

1 answer

Your answer

Answer 1

Xuyan Ding - MSFT 7,601

Hi @Sarah Sims ,

You need to modify one line of your code to show two levels of grouping as follows.

"txtContent": "=if(@group.columnDisplayName == 'Modified By', 'Modified By', '@group.fieldData')"

Among them, I used the 'Modified By' column instead of your 'Assigned To' column for testing, you can replace it at any time.

User's image

==================Update

Display the specific name: You need to add the following code segment and modify the content in the above "txtContent".

{
                "elmType": "span",
                "txtContent": "=@group.fieldData.title",
                "attributes": {
                  "title": "=@group.fieldData.title",
                  "class": "ms-fontWeight-semibold"
                },
                "style": {
                  "padding-left": "5px"
                }
              },

"txtContent": "=if(@group.columnDisplayName == 'Modified By', '@group.filedData.title', '@group.fieldData')"

The result is displayed as follows:

User's image

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Anonymous

2023-01-23T15:59:13.8733333+00:00
Thank you so much for your help! I went to format current view and edited the code as you helpfully outlined in your response. Upon saving, the list still is not grouping by the name of the person for which the task is assigned. It does look different now as it at least does not say "[object Object]", but it should say "1 Item is Assigned to Sarah Sims", for example. Instead it says "1 Item is Assigned To".

Here is how it looks now:

The first grouping based on a helper column is correct. However, it then should group by which staff member the tasks are assigned to. I want it to say which staff member the 1 Item is Assigned To under "11 Items are In Progress by Assignee", as well as which staff member the 9 items are Assigned To, etc. for each sub group.

Here is the edited code :

Here are the relevant list settings as well:

Any ideas? Thank you!!! I've gotten the rest of the list where we want it to be and I originally had this part working fine. If I remember correctly, the second "Assigned To" grouping stopped functioning around when I change different lines of code in the Format View to conditionally format the first group "Status Summary" so that the Pending Action group header is red, the In Progress group header is yellow, and the Complete group header is green. That part of the code works fine, only the second grouping assigned to is not displaying properly.

Thanks again!
Anonymous

2023-01-23T16:14:43.15+00:00
Hi @Xuyan Ding - MSFT thank you so much for your help!

Your helpful instructions did remove the [object Object] text, but it did not replace [object Object] with the display name of the person in which the task(s) are assigned. Here is how it looks now:

The headers for the sub groupings above ('1 Item is Assigned To' and '9 Items are Assigned To') should include the display name of the person tagged in the Assigned To column. I.e., '1 Item is Assigned To Sarah Sims'

Here is the edited code:

Here are the relevant list settings as well:

This may or may not be useful, but: Finally, I wanted to note in case it is helpful that I believe my sub grouping header used to function properly until I successfully edited the Format View code to conditionally format the header of the parent grouping based on the status summary helper column. That part of the code functions great, making the "Pending Action from Approver/Assigner" group header red, the "In Progress by Assignee" group header yellow, and the "Complete" group header green. However, I believe that this is when suddenly the second grouping started displaying [object Object] and the Assigned To column values stopped showing the person's profile picture. The relevant code is in line 13 and 26.

Thank you so much and I look forward to seeing your guidance!!
Xuyan Ding - MSFT 7,601 Reputation points

2023-01-26T11:27:18.8866667+00:00

Dear @Sarah Sims ,

Sorry for the late reply, I was on vacation yesterday. Are you trying to display specific names on the second level? I have updated in answer, please check.
Xuyan Ding - MSFT 7,601 Reputation points

2023-02-02T02:15:26.4166667+00:00

Hi @Sarah Sims ,

I’m checking how the things are going on about this issue. Whether the answer helps you?

Is there any progress on this thread? Please feel free to let me know.
Xuyan Ding - MSFT 7,601 Reputation points

2023-02-08T02:29:28.13+00:00

Hi @Sarah Sims ,

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Share via

SharePoint List "Group By" displaying [object Object]

1 answer

Your answer