PATCH A SharePoint Yes/No Column In Power Apps

Goal

Change the Completed column (Number type) from No to Yes

Input

IT Helpdesk Tickets (SharePoint List)

ID	Date	Description	Completed
1	11/7/2020	Computer Not Turning On	No

Patch Function Code

Patch(
    'IT Helpdesk Tickets',
    LookUp('IT Helpdesk Tickets', ID=1),
    {
        Completed: true
    }
)

Output

IT Helpdesk Tickets (SharePoint List)

ID	Date	Description	Completed
1	11/7/2020	Computer Not Turning On	Yes

Scenario #1: Toggle

Patch a value found in a toggle to a Yes/No field.

Patch Function Code

Patch(
    'IT Helpdesk Tickets',
    LookUp('IT Helpdesk Tickets', ID=1),
    {
        Completed: Toggle_Completed.Value
    }
)

Scenario #2: Dropdown

Patch a value found in a dropdown to a Yes/No field.

Patch Function Code

Patch(
    'IT Helpdesk Tickets',
    LookUp('IT Helpdesk Tickets', ID=1),
    {
        Completed: If(
             Dropdown_Completed.Value="No", false,
             Dropdown_Completed.Value="Yes", true
        )
    }
)