Settings

Organize work flow in a visual board

Let's create a new screen for having the Kanban board. Name the new screen as "Kanban Screen".

To make our kanban work properly we need to configure 3 properties:

1. The Board Data Set

2. The Items (Options)

3. The labels

Creating the Board

Your board can be created adpting to your process. We can change features like title, icons and colors of the board. In the snippert below you will find the formula for creating a 4 colum board ("Not Started", "In Progress", "Completed", "Blocked").

Properties

Attribute	Type	Description
id	String	The unique identifier for the board
title	String	The name of the board which is presented at the top
color	String	The color of the text for the title
backgroundColor	String	The background color of the board
icon	String	The icon which is presented next to the title at the top.
enableAdd	Boolean	Determines whether the board supports the option to add new work items to its

Formula Snippet

Your board should be looking like this:

Custom the board to meet your needs

Collecting the items

Usually the data in your board will come from some datasource (e.g. SharePoint, Dataverse, etc.). In our example we are going to get the data from the SharePoint list created on Episode 01. See in the table below the expected JSON schema:

Properties

Attribute	Type	Description
id	string	The unique identifier for the Work Item
title	string	The Title of the Work Item that appears on the card
description	string	The description of the Work Item that appears on the card
AssignedTo	string	The text which will represent who the Work Item is assigned to
labels	string	The tags which are associated with this Work Item
dueDate	Date	The due date of the work item
icon	string	Defines the icon to represent the work item
iconColor	string	Defines the color of the Work Item icon
color	string	Sets the color of the outside border of the card
order	Number	Defines the position of the Work Item on the board

Formula Snippet

Table Changes

Once you create the collection to hold work items your kanban should be looking like this

Notice that we are using the formula RenameColumns() to make the columns match the expected schema.

The Switch() statement is being used to translate the status (progress column) of the task into an id. The same is happening for the labels. Check the next session to undestand how labels work.

Creating Labels

You can use multiple labels to enhance the visual identification of your kanban card. Colors and icons can be used as you you want.

In the following snippet we are creating one label for each priority status

Properties

Attribute	Type	Description
id	string	The unique identifier for label
title	string	The name of the label
color	string	The color of the text for the title
backgroundColor	string	The background color of the label
icon	string	The icon for the label

Formula Snippet