Tag Archives: JSON

Power Fx Patch is easy – Day 7 updating multiple Items

Posted on by Leave a comment
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:-

CitiesDownload
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/

Power Apps Patch is easy – Day 6 Person fields

Posted on by One comment

Today’s learning on Patch is important as it relates to Person fields which are more similar than you might think. They are highly relevant to Patching to Sharepoint lists as they help us to maintain the ties to related lists.

Structure for Patching to a Person Field

The basic structure for patching to a person field is as follows – where cmbOwner is a combo box where a user is selected:-

Patch(
    List, 
    Defaults(List),
    {
      Title: "New Title Value",  
      Person: {
            Claims: cmbOwner.Selected.Claims,
            Department: cmbOwner.Selected.Department,
            DisplayName: cmbOwner.Selected.DisplayName,
            Email: cmbOwner.Selected.Email,
            JobTitle: cmbOwner.Selected.JobTitle,
            Picture: cmbOwner.Selected.Picture
        }
   }
)
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/6015776063330

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

7 Days of Power Apps Patch – Day 5 Lookup and Choice fields

Posted on by One comment

Today’s learning on Patch is important as it relates to Lookup and Choice fields which are more similar than you might think. They are highly relevant to Patching to Sharepoint lists as they help us to maintain the ties to related lists.

How to Patch to PowerApps Lookup and Choice fields

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

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

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/

In other news I’ve been getting back into looking at Urban Sketching – this isn’t one of mine, but maybe one day I’ll get back to it. You can head here for more content like this https://www.facebook.com/groups/urbansketchers/

Check out the other posts in this series


https://powerplatformlearn.com/2021/02/19/7-days-of-power-apps-patch-day-4/
https://powerplatformlearn.com/2021/02/17/7-days-of-power-apps-patch-day-3/
https://powerplatformlearn.com/2021/02/16/7-days-of-power-apps-patch-day-2/
https://powerplatformlearn.com/2021/02/16/7-days-of-power-apps-patch-day-1/

7 Days of Power Apps Patch – Day 4

Posted on by Leave a comment

Today’s learning on Patch is really great – super simple – we will be using it to cover the using Patch to create Date and Time fields entries

This is a picture of some daffodils – spring is thankfully coming in the UK at the end of a long COVID lockdown. Looking forward to 2021!

Image result for spring budsuk daffodils

You can head directly to the first video here.

https://powerplatformlearn.newzenler.com/courses/microsoft-power-apps-from-zero-to-hero/contents/60157720e7f96

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/

7 Days of Power Apps Patch – Day 3

Posted on by Leave a comment

Today’s learning on Patch is really great – super simple – we will be using it to cover the following:

  • Power Apps Pro Tip – Getting JSON from your Cloud Flows
  • Working with Yes/No fields

And this is a picture my dog. He’s not called Patch he’s called Kylo.

You can head directly to the first video here.

https://powerplatformlearn.newzenler.com/courses/microsoft-power-apps-from-zero-to-hero/contents/6015733ee8d56

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/

7 Days of Power Apps Patch – Day 2

Posted on by Leave a comment

My goodness! we’re now over 1700 students strong, and this means that we’ll be able to have some super community events in the future.

Today we will be using PowerApps Patch to cover the following:

  • Editing items
  • Working with text and numeric fields

You can head directly to the first video here.

https://powerplatformlearn.newzenler.com/courses/microsoft-power-apps-from-zero-to-hero/contents/601571d1ef2ac

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/

7 Days of Power Apps Patch – Day 1

Posted on by One comment

Wow – this has come around sooner than expected. I set a target of 1687 students in my last post (Original post below) and we’re there!

Today we will be covering the following:

  • Introduction to Power Apps Patch
  • JSON and how it works
  • How to create your first item

You can head directly to the first video here.

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

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/