Скачать или смотреть Using Power Apps Patch to Insert and Update (with People Pickers and Choice columns)

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
}
)

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:
👉 On-Demand Learning Courses FREE Trial: https://www.pragmaticworkstraining.co...

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:
✔️Twitter:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.works  
✔️LinkedIn:   / pragmaticworks  
✔️YouTube:    / pragmaticworks  

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 413-1911
Email: [email protected]