Power Fx Patch is easy – Day 7 updating multiple Items
Today’s learning on Patch is important as it relates to using a Patch statement to create multiple items. This is a MAJOR difference between Forms and Patch as Forms cannot perform this operation.
Structure for Patching to a Multiple items using Power Fx
The basic structure for patching multiple items is as follows – where CityXL is a data source within our app, and Cities is a table within Dataverse (Common Data Service). In this case the field names are completely aligned between the spreadsheet table field and the database fields, which is why they repeat themselves :-
ForAll(CityXL,
Patch(Cities,Defaults(Cities),{Name:City,Population:Population,Country:Country,Latitude:Latitude,Longitude:Longitude}))If you’d like the download then see below:-
How to get to the course content
If you’ve signed up for the course you can head directly to the video here.
Check out this post to confirm how to sign up for the course.
https://powerplatformlearn.com/2021/02/14/7-days-of-power-apps-patch/
Check out the other posts in this series
Patching to Person Fields
https://powerplatformlearn.com/2021/02/28/power-apps-patch-is-easy-day-6-person-fields/
Lookup and choice fields
https://powerplatformlearn.com/2021/02/24/7-days-of-power-apps-patch-day-5-lookup-and-choice-fields/
Date and time fields
https://powerplatformlearn.com/2021/02/19/7-days-of-power-apps-patch-day-4/
Power Automate and Yes/No fields
https://powerplatformlearn.com/2021/02/17/7-days-of-power-apps-patch-day-3/
Editing Items and working with Text and Numeric fields
https://powerplatformlearn.com/2021/02/16/7-days-of-power-apps-patch-day-2/
Introduction, JSON and Patching your first Item
https://powerplatformlearn.com/2021/02/16/7-days-of-power-apps-patch-day-1/