We're trying to figure out how to add some custom JSON to a modern list view. The intent is to group list items by a column. Then suppress the group if it has only a single child item. What you're left with are groupings with 2 or more child items. We can't seem to get the syntax right. Also, the group in the list view settings keeps getting cleared to "None". We read somewhere it's possible when incorrect JSON is added it will clear out grouping settings for a list view, but we're usure. We're certain it keeps getting reset to none, but aren't certain of the cause. We thought something like the following might work, but it doesn't seem to:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"groupProps": {
"headerFormat": {
"elmType": "div",
"txtContent": "@currentField",
"style": {
"display": "=if(@group.count > 1, 'block', 'none')"
}
}
}
}
Another possible solution to this would be to use the list view filtering. However, we can't seem to get that working either. We tried the following to filter out list items that only had one instance of a value in the same column we're grouping by so that only items with two or more instances of the same value would be included in the view:
When a column: License Plate Number (Indexed) is equal to:
=COUNTIF([License Plate Number],[License Plate Number])>1
Also note that this list has about 7,000 items in it, but we're also including a date filter in the list view that should have it below the 5,000 threshold.
Thanks for any tips you can send our way ;)
