Using Power Apps Patch to Insert and Update (with People Pickers and Choice columns)

Published: 13 January 2021
on channel: Pragmatic Works

49,345

335

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]

Watch video Using Power Apps Patch to Insert and Update (with People Pickers and Choice columns) online without registration, duration hours minute second in high quality. This video was added by user Pragmatic Works 13 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 49,34 once and liked it 33 people.