Share via

Help in Format View with JSON

N, Bharathi 0 Reputation points
2023-02-17T10:51:45.5033333+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 displayed. 

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" 

    } 

  ] 

} 

i have very limited knolodge in development or coding, any help is highly appreciated.

Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,986 Reputation points Microsoft External Staff
    2023-02-21T10:02:52.2933333+00:00

    Per my test, there are no JSON codes and options to list people leader and seat count in the View Events of calendar view.


    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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.