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 :-


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.


Check out this post to confirm how to sign up for the course.


Check out the other posts in this series

Patching to Person Fields


Lookup and choice fields


Date and time fields


Power Automate and Yes/No fields


Editing Items and working with Text and Numeric fields


Introduction, JSON and Patching your first Item


Leave a Reply