Help in Format View with JSON

Question

Hi

I have a Sharepoint List with columns Date, People and seat count and created a Calendar View for for the list.

Under the Calendar view's View Event its listing the either people leader or number of days but i would like it to list people leader and seat count and display sum of seat count as well.

could someone help me with JSON code to generate this view. the code i tried is provided below but it doesn't seem to be working.

{

"select": [

"Title", 

"People Leader", 

"Seat Count", 

"Booking Date" 

],

"expand": [

"People Leader" 

],

"filter": "Booking Date eq '2023-02-16'",

"groupBy": [

{ 

  "field": "People Leader", 

  "aggregation": "sum", 

  "type": "number", 

  "alias": "TotalSeatsBooked" 

} 

]

}

Answer 1

Dear Bharathi N,

Greetings! Thank you for posting in Microsoft Community.

As per your description, you have a SharePoint list, you want to use JSON code to format Calendar View.

We'd love to help, considering that we mainly focus on general and build-in features in SharePoint Online, we may have limited resource about JSON code.

At the same time, considering that we have a dedicated channel Microsoft Q&A Community, for you to be assisted properly, we sincerely recommend you go to that community and post a new thread. You may use SharePoint tag and SharePoint Development tag when asking question there.

Members and engineers over there are proficient in the knowledge of coding and SharePoint customization queries. They will focus on the specific situation on your side and provide suggestions for you. You will get the most qualified pool of respondents. We are sure that our experts from that team can address your query effectively and accurately.

Thanks for your understanding and cooperation! We hope you keep safe and healthy.

Sincerely,

Tina | Microsoft Community Moderator