PATCH A SharePoint Yes/No Column In Power Apps

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-yes-no-column-in-power-apps/. Author: Matthew Devaney.

PATCH A SharePoint Yes/No Column In Power Apps Goal

Change the Completed column (Number type) from No to Yes Input IT Helpdesk Ticket s (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 } ) Code language: JavaScript ( javascript ) Output IT Helpdesk Ticket s (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 } ) Code language: JavaScript ( javascript ) 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 ) } ) Code language: JavaScript ( javascript ) Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up