All courses available in-class or via remote login

PowerApps enables users to build business-centric apps incredibly easily. Users can streamline business tasks and make their work more efficient.  The program allows users to build their own web-based apps and mobile apps, which can be also used within other Microsoft programs.

Today we're going to look at the basics of PowerApps, and go through how to build a basic app using our own dataset.

Getting Started with PowerApps

For this example, let’s say we want to make an app to show which employee is delivering certain workshops to high school students and when.

First, make your spreadsheet of data in Excel, and make sure you format your data as a table.



Now we’re going to put this data into PowerApps, which will do all the hard work for us and turn our data into an easy-to-use application.

Open up PowerApps, and click on ‘Start from data’, so we can use the dataset we've just made in Excel.



Next we’re going to select our data source, which in this case has been automatically saved into OneDrive.  Click ‘Phone layout’ under the 'OneDrive for Business' option.



Select ‘Workshop Delivery Dates’,  which is the dataset we've just made in Excel, then select your formatted table, probably called 'Table 1', and click 'Connect'.



Now PowerApps will start working its magic and start building your basic app from the ground up.

Tip:  If for some reason your app shows up as blank after PowerApps processes your data, it could be because you have your Excel file still open.  Close Excel and refresh PowerApps, and then your data should show up.

So here is our brand new app!



To preview our working application so far, hit the play button in the top right-hand corner.  Here you can take a closer look at your data, edit and sort it, and add in new data.  The search function is also handy – in this case, if we had a long list of employees and we wanted to find who is presenting which workshop, we can simply type in the employee's name in the search bar of the app to find their details.

Formatting Your PowerApp

Now let’s change a few things to make the app a bit more functional.  For instance, we can change the name of our data from 'Table 1' to ‘Workshop Presentations’ by simply double-clicking and typing in the text field.



Next we can change the order of the data categories, such as the employee name, workshop topic, location and date.

First, click ‘BrowseGallery1’ to the left of the screen.  On the right-hand side, click edit under the ‘Fields’ category.  Here we can rearrange our data categories using the drop-down menus.  In this example, we want to display the workshop date rather than the location.



Next we can change the way our data is sorted in the app.  In this example, let’s change it so our data is sorted by the workshop date, instead of by the alphabetical order of employee names.  Click 'BrowseGallery1' again, and then change where it says ‘Employee’ in the data source/function bar (as seen in the above image), and write in ‘Date’ to match this data category.



Now the data in our app is sorted in order of when workshops are due to be delivered by each employee.  Try clicking the play button again in the top right-hand corner to preview our brand new, reorganised app.

Stay tuned for our next blog where we will talk about how to publish and share an app made in PowerApps.

If you're interested in learning more about PowerApps and how to best use it to benefit your work and business, you can check out our courses here!

 

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 26910 Reviews
Good session. Keen to learn more as I already knew some stuff. -MS Teams Brisbane
Karin - MS Teams, .
Very informative Would be good to have a booklet to review what was learnt in the course Steven to follow up on Power BI booklet for Melina Berthaux -MS Teams Brisbane
Melina - MS Teams, .
Good course, the afternoon was more relevant for me. The morning was more of a referesher -MS Teams Brisbane
Colin - MS Teams, .
happy with outcome. -MS Teams Brisbane
Wayne - MS Teams, .
Course was presented at a good pace and kept us interested. Steven was a good trainer and kept the group included and ensured we all kept up. -MS Teams Brisbane
Tammy - MS Teams, .
Presenter was clear and concise and knowledgeable -MS Teams Brisbane
Kevin - MS Teams, .
Good training with a knowledgeable trainer. -MS Teams Brisbane
Emma - MS Teams, .
Another great session, thanks to Jason for taking us through more functions of Power BI. I feel much more equipped to use the program for my work now. -Power BI Intermediate Brisbane
Bek - Power BI Intermediate, .
Good refresher -Excel Intermediate Brisbane
Shani - Excel Intermediate, .
Great class - I picked up some really good tricks and methods. -Excel Intermediate Brisbane
Melinda - Excel Intermediate, .
learnt a lot from Stuart, looking forward to the advance course -Excel Intermediate Brisbane
Andrea - Excel Intermediate, .
Great course, learned heaps! Good pace. Easy to follow online. -Power BI Intermediate Brisbane
Ashleigh - Power BI Intermediate, .
Found that the Intermediate course was great as a refresher but I did learn some great tips. -Excel Intermediate Brisbane
Suzanne - Excel Intermediate, .
Great building on the beginner course and some amazing things possible. Jason as always is excellent!!! Friendly, responsive to questions. Good resources to link into as well. Thanks very much -Power BI Intermediate Brisbane
Clea - Power BI Intermediate, .
This course was very good for me I learned a lot in the class today -Excel Beginner Sydney
Debra - Excel Beginner, .
I really enjoyed learning from Michael and will definately use what I have been taught. An excellent and approachable way to learn Excel. Thank you! -Excel Beginner Sydney
Marcia - Excel Beginner, .
Michael was very attentive and helpful. He kept pace and time for the course but was always happy to assist anyone needing help. The course itself was a great refresher and I am looking forward to returning for an Intermediate Excel course to further my skills. -Excel Beginner Sydney
George - Excel Beginner, .
Michael was very helpful and made it fun. -Excel Beginner Sydney
Melissa - Excel Beginner, .
I found this course informative and easy to understand -Excel Intermediate Melbourne
James - Excel Intermediate, .
Great course, thanks -Excel Intermediate Melbourne
Jake - Excel Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Nexacu offices Australia

Follow us