Share via

Help in Format View with JSON

Anonymous
2023-02-16T19:58:51+00:00

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" 

} 

]

}

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-02-16T23:51:20+00:00

    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

    Was this answer helpful?

    0 comments No comments