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.8/5
Over 25129 Reviews
Some very helpful tips, definitely things I can use in the future -Word Advanced Brisbane
Millie - Word Advanced, .
Very informative and engaging. Good teacher -Excel Intermediate Brisbane
Alisha - Excel Intermediate, .
was informative and well done -Excel Intermediate Brisbane
Sola - Excel Intermediate, .
thank you great course and facilitator was great -Excel Intermediate Brisbane
Luke - Excel Intermediate, .
very useful. -Excel Intermediate Brisbane
Jennifer - Excel Intermediate, .
Very clear and helpful. Good pace also. Well structured. -Excel Intermediate Brisbane
Aria - Excel Intermediate, .
This course was great. I knew very little about VBA prior to attending and Michael was clear and built knowledge so well that I feel confident attempting to apply this in real work situations. A highly recommended course. -Excel Macros/VBA 2 Day Parramatta
Mary - Excel Macros/VBA 2 Day, .
This course was amazing. Michael was such an engaging teacher and kept the class so informative and so easy to follow. We had a great time learning the content of this course and we loved the small class we were in. We could ask a lot of questions and enjoy the whole course at the same time. This was one of many courses I have attended with Nexacu and all the teachers are great. Michael is my favourite. 5 Stars from me from all perspectives !!! -Excel Macros/VBA 2 Day Parramatta
Jacqueline - Excel Macros/VBA 2 Day, .
Moved a bit quicker than the beginner but showed good examples of what you can do. I certainly need to go away and practice with some real data to apply what I have learned today. Many thanks -Power BI Intermediate Adelaide
Merrin - Power BI Intermediate, .
Thanks for the help! -Power BI Intermediate Adelaide
Bradley - Power BI Intermediate, .
Brilliant - learnt so much. Many thanks Jagg -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
was able to learn new formulas and functions that will help me in the future. -Power BI Intermediate Adelaide
Estelle - Power BI Intermediate, .
Learnt a lot on how to manipulate and clean up data. Learnt to better manage permissions to data. Learnt more on the date functions, though still don't know how to calculate current week/previous week comparisons. -Power BI Intermediate Melbourne
Kristina - Power BI Intermediate, .
Learnt many items with Power Query and DAX, along with row level security which is of particular interest with the types of personnel reports I will need to build. -Power BI Intermediate Melbourne
Kylie - Power BI Intermediate, .
Excellent content, great teacher. Thank you! -Excel Intermediate Melbourne
Linda - Excel Intermediate, .
Steven was incredibly helpful in training us. He took the time to understand our professional roles and relate what we were learning to our day to day tasks. He was patient and professional. Thank you! -Word Intermediate Brisbane
Alison - Word Intermediate, .
I have enjoyed it and learned many tips. -Word Intermediate Brisbane
Kristian - Word Intermediate, .
This was great! -Word Intermediate Brisbane
Courteney - Word Intermediate, .
Well-paced and very informative training. Trainer is very knowledgeable and helpful with any questions. -Power BI Intermediate Brisbane
Emily - Power BI Intermediate, .
Great course. Jason was very clear and easy to understand. Learnt a lot in one day. Thanks! -Power BI Intermediate Brisbane
Ben - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us