Tag Archives: Power Apps

1999 students building awesome apps

1999 Students www.powerplatformlearn.academy

Today is a day for Pride. I feel proud today as the course I have laboured on for almost 12 months has nearly 2000 students.

I’m proud that I even started a Power Apps course on a platform that means a great deal to me, I mean, like what right do I even have to teach people? I’m proud of the fact that I spent 6 weeks considering the structure before recording a single video and then started creating a course that stretches out to 250+ lessons, and then gave it away for free.

My amazing and committed students

Most of all though I am proud of the all the students that have decided that they want to take the time to learn their craft properly.

I’m thankful too!

As well as that I am thankful to every person that has signed up for the course and to those that have provided me with counsel to make it the best that it can be.

I’m also thankful to my wife and family for putting up with me making my recordings and turning off the boiler so that the sound wasn’t disturbed (and then wondering why there was no hot water)

a romantic setting in the bathroom
Motivation

I started out with a simple idea, that I might be able to create something of use to someone, some individual person who wanted to do more for themselves and their organisation.
I still believe that if it is worth a single person travelling through the course, then it is worth 10,000 following the same path.

Students Young and Old(er)

This is very much the beginning for so many people, from those that start aged 6 using http://www.PowerApps4Kids.com through to those that are 60 and beyond. This is Paul Burns talking to Dona Sarkar at Ignite 2021 about his app he created to help him to write again after a stroke – the sky really is the limit.

Pride http://www.powerplatformlearn.com

Here’s a link to the interview. https://youtu.be/Bha8qs4wB_8?t=35802

I cannot wait to see what you, what we will all build over the months and years to come.

If you’d like to come and join us click on the link below

Good luck everyone,

Keep Power Apping

Rebuilding the 3 Screen Power App with ease from Blank in 45 minutes

Rebuilding the 3 screen Power App

You can rebuild a 3 Screen Power App in about 3 minutes with 1 click. But how would you build it from scratch? I this video we take a simple spreadsheet, upload it to sharepoint and build out the app from scratch. It’s easy, but not as easy as you think 🙂


Like this sort of thing? Head over to http://www.powerplatformlearn.academy

Power Fx Patch is easy – Day 8 alternatives to patch and series close

Alternatives to Power Fx Patch

Today’s learning on Patch is to demonstrate that sometimes we don’t have to use Patch at all, and that Forms can be created in a way that gives the control of positioning the objects, but “performance” of submitting of forms

This is the last day in the series on Patch, so I’ve provided links to all the sessions down below.

An Alternative to Patch

The technique is relatively straightforward to execute.

  • Create all your controls, text inputs etc and place them wherever you wish onto the canvas
  • Create a form tied to your data source
  • Connect the outputs of your controls on your canvas to your form inputs so that the default is the value in your forms
  • Create a button on your canvas
  • In the OnSelect of the button use the following formula
NewForm(Form1);SubmitForm(Form1)

You can now hide the form.

There are some points to note from this technique:-

  • You would need to put a little more effort into your “on canvas” controls to ensure that if you had a gallery their defaults would be correctly set. This is no different to what would be the case with the experience when patching
  • Troubleshooting submission issues is easier than with Patch
  • You have more options around controlling the behaviour of the input s
How to get to the course content

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/

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

Check out the other posts in this series

Patching to Multiple Records


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

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/

live build : make a mars rover Power app using dataverse for Teams : 17th March 6pm

Mars Rover Perseverence

The Mars Rover “Perseverence” landed on Mars on 18th February 2021 and in the live session coming up we’re going to use Power Platform tech to create a slideshow of images to music.

Build from Blank

We going to build an app from blank which will allow us to create a cool slideshow to music, all about the Mars Rover.  
If you have teams you can do all the things we cover whilst we are together
During the session we will
– Create a Team
– Create a data table
– Create a Power App
– Create a Cloud Flow
– Populate a table using audiene submissions in Microsoft Forms

Registration

When : 17 March 2021 Wednesday, 5:55 PM GMT

Register for the site here
https://powerplatformlearn.newzenler.com/register

Then book a spot here

https://powerplatformlearn.newzenler.com/live-class/mars-rover-app/register

Hope to see you there,

Rory Neary MVP MCT ACA

Twitter: @azurerory
LinkedIn – leave a message if you would like to connect: https://www.linkedin.com/in/roryneary/  

https://www.powerplatformlearn.academy

Power Apps Patch is easy – Day 6 Person fields

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

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/

« Older Entries