SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
Can I check, I have two columns: category and questions.
I want to group all the questions that are related to the category as a group. Can I know how?
Category A Questions 1, 2 3
Category B Questions 4, 5, 6
What is the JSON Schema code as I am using view format in SharePoint site.
This is not possible using JSON view formatting as you cannot get the values from another rows/list items in JSON code.
You can only access the column values from the same list item/row like [$AnotherColumnFromSameRow].
Where AnotherColumnFromSameRow is internal name another column from same list item/row.
You could probably use Flow to generate a new list containing the information as you need but it wouldn't be easy.
