Episode 03

Changing choice columns to text

As a good practice for SharePoint lists we are changing the list template choice columns to text fields. Please find below adjustments needed due the change:

Filter by progress Combobox Items property:

Distinct(WorkProgressTracker, Progress)

Tasks Gallery

Filter(
    WorkProgressTracker,
    Progress = ComboBox1.Selected.Result Or IsEmpty(ComboBox1.SelectedItems) Or IsBlank(ComboBox1.Selected)
)

Kanban Work Items

ClearCollect(
    collWorkItems,
    AddColumns(
        RenameColumns(
            WorkProgressTracker,
            "ID",
            "id",
            "Title",
            "title",
            "Description",
            "description",
            "DueDate",
            "dueDate"
        ),
        "boardId",
        Switch(ThisRecord.Progress,"Not started", "1", "In progress", "2", "Completed", "3", "Blocked", "4"),
        "assignedTo",
        ThisRecord.'Assigned to'.DisplayName,
        "labels",
        Switch(ThisRecord.Priority, "Low", "1", "Medium", "2", "High", "3", "Critical", "4")
    )
);