Learn how to use Power Apps Patch to update or insert into a SQL Server table or in this case, a SharePoint list. Brian also covers how to update into special data types like Choice and People Pickers
Pragmatic Works training: https://www.pragmaticworks.com
Update Statement: Patch('Assembly Work Orders', ThisItem, {'Text Status':"Complete", Status: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value:"Complete"}, Owner:{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & User().Email, DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" } }) Insert Done with the Defaults() command: Patch( 'Assembly Work Orders', Defaults('Assembly Work Orders'), { Title: dcTitle.Text, 'Work Order Number':Value(dcvWorkOrderNumber.Text), ProductImage: dcProductImage.Text, Status: ddStatus.Selected } )
