Category Archives: Functions

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

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

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

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

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

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/

Power Apps If and Switch functions

If and Switch are two closely related formulas. As they are fundamental to creating conditional behaviour, they are also fundamental to being successful with Power Apps. Basically, you need to learn them!

Roughly speaking you’ll use if in the following circumstances:-

  • There are 2 outcomes
  • The if condition is based on a number of factors such as if(ThisItem.Title = “Hello” && ThisItem.Value>10,Red,Blue)

Switch is helpful if you are just looking at 1 field but would like to do different things based on the value in the field.

In the example if the formula was placed on a button inside a gallery we could use the button to navigate to different screens. “Hello” takes us to the Hello Screen, and “World” navigates us to the World screen

Switch(ThisItem.Title,
"Hello",Navigate(ScreenHello),
"World",Navigate(ScreenWorld)
)

In the video below I demonstrate how to use If and Switch

You can head over to the Microsoft Docs to take a detailed look by clicking below.

Good luck – and keep Power Apping!