Swiss Innovation Academy
Teaching Service Design 2 min read

How to format Microsoft Lists for a course schedule so that it doesn't suck?

In short: with custom JSON code, that you can ask an LLM to help you write, you can adapt how the details of a session in your course look like.

An illustration showing a default Microsoft List layout and one with custom JSON code that has call outs, sections and columns

Microsoft List can be a nice way to add a course schedule or program in the Teams channel of your course. That's how we are playing with it at the Master Service Design of the HSLU these days.

The problem: the default layout sucks

The lists and calendar look okay, but when a learner opens a specific day to see the details, the default layout just isn't optimized. It's all in one column and has little emotion.

The solution: JSON code

The hacky nature of Microsoft tools make it so that weirdly you can add custom JSON code to adapt how the header, body and footer of an open list element looks like.

A screenshot showing the JSON code panel that changes the layout of the header of a Microsoft List element.

You can learn how to write that JSON code yourself, or you can just ask once any AI tool to write that code for you by sharing to it the official Microsoft documentation.

The before and after

Here's how a day in the schedule looks like when open without the custom code:

A screenshot showing the default layout

And here is how it looks like with the custom code:

A screenshot showing the updated layout with a call out box, sections and columns

Fun things you can create

The JSON code for the header has a rule that looks if the course material field has data in it, and if it has it shows then a call-out with what learners should do with this material

As this text is basically each time the same, it's a nice way to show that text quickly.

A more basic thing, but nice in terms of layout, is that you can create sections where the fields in this section are then displayed in columns.

The limitations I discovered

As always with these types of hacky things it's limited in strange ways:

  • The header can have rich styling, but people can't select the text in the header
  • The body can't have rich styling
  • You can't hide elements like the attached documents or the comments
written and sketched by hand

This article was written on a refurbished Remarkable II tablet with a type folio cover. The illustration was made drawn by hand on the same tablet.