Power Fx Patch is easy – Day 7 updating multiple Items

Patch Forall Mutliple Items Power Fx

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 use a person field in Power Apps
How to get to the course content

If you’ve signed up for the course you can head directly to the video here.

https://www.powerplatformlearn.academy/courses/microsoft-power-apps-from-zero-to-hero/contents/6015778bd0f15

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/

Leave a Reply