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

Update Statement:

Patch('Assembly Work Orders', ThisItem, {'Text Status':"Complete",
Status:
Value:"Complete"},
Owner:{
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:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

[Steve.Outdoors]

Just what I need thank you was racking my brains on this one but you explanation was so easy to follow and understand

[mcrimpin]

Great video. This was a life saver with dealing with special types of data in SharePoint list. Thanks so much!!!

[anisamira]

Hi, I noticed that when you update the Status, it will automatically update in the SPL? How did you do that? Thank you.

[bernarat]

Great video! How do you patch if your people picker allows for multiple selection?

[lih]

Thanks so much!!! It was just what I, too, needed! How can I clear the value from the person field? (Owner)

[minvisusanpaul]

Hello, may i know how will i get data type of lookup.. Mine data sourcw is Microsoft dataverse table

[VerticalVictoryGarden]

Three years later and this video is still bringing it. Thanks for clearing up the record type fields. It’s easy once you’ve seen it done.

[janurbanek]

Hi Brian, Great video. Would you know how to patch choice column with multiple choice enabled? Lets say you assign things to departments and you want to be able to assign it to multiple departments?

[derekgray]

Fairly easy for me to follow for a beginner and never done any 'Patch' functions before in my forms. I do have a question though, as I want to patch update from the form control with the selected persons name from a people picker to update the SP list item 'Assetowner' (this is a people picker in the SP list), as this is form a form, am i still required to use the 'Thisitem' after the SP list name (Assets) or specify the actual choice column name, which is 'AssetOwner'?

[SoNonWoo]

I have a very similar app but it is formatted for a phone instead of a tablet. Because of the smaller form factor, I've elected to pass the data from a gallery to an edit form on another screen where I have run into a problem. It does not allow for "ThisItem". What do I do? The edit form auto-populates with Gallery.Selected.

[blazehawkins]

Thank you so much Brian! Your teaching style is phenomenal, and I learn so much. I might literally owe my job to your videos!

[claudeuu]

An amazing tutorial that saved me a ton of work, thank you Brian!

[saradehond]

You explain it so great!! Does the Patch within the gallery to the left also work for images? Like connection to an add image control?

[victorfarinella]

You really made possible an app that I worked all day to solve! Thank you so much!