October Sale - 20% of all courses - Book Today

Excel spreadsheet

Build an app in 5 minutes with PowerApps

April 17, 2019

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 23467 Reviews
Course was very informative and well presented. -Excel Advanced Perth
Carmel - Excel Advanced, .
Domenic is an excellent trainer. Explained well and very thorough. -Excel Advanced Perth
Amanda - Excel Advanced, .
Learned a lot today. -Project Beginner Brisbane
Julius - Project Beginner, .
Stuart made the training reflect actual use of Microsoft Project in the field -Project Beginner Brisbane
Keith - Project Beginner, .
Good session, the content started off very basic which was good even though I have used MS Project to create a few schedules before. This allowed me to learn basic things I did not know and how to set up schedule times properly which I have always struggled with. Stuart was friendly, knowledgeable and patient. -Project Beginner Brisbane
Katrina - Project Beginner, .
Great course and Stuart is a great teacher. Easy to follow and feel like I have developed a basic understanding on how to use Microsoft Project even though my laptop died twice haha. Thank you -Project Beginner Brisbane
Kellsey - Project Beginner, .
Stuart did a good job and i look forward to doing the intermediate course -Project Beginner Brisbane
Richard - Project Beginner, .
Great course, thanks Stuart, I learned a lot not knowing much about project. -Project Beginner Brisbane
Kris - Project Beginner, .
Thanks Stuart-great to learn more about Project! -Project Beginner Perth
Brett - Project Beginner, .
Was good to learn so new tips and tricks. -Project Beginner Brisbane
Tanya - Project Beginner, .
A lot of useful information -Project Beginner Brisbane
Paul - Project Beginner, .
Great beginners course, easy to follow and understand. Very useful information that I can use in my day-to-day work. -Excel Beginner Canberra
Bridgette - Excel Beginner, .
Great to get a few new handy shortcuts and learnt a lot on using new functions and macros. Well paced based on students capabilities. -Excel Advanced Melbourne
Kathryn - Excel Advanced, .
Great course, helpful that John focused on the issues we were most interested in and went quickly over the things we only needed refreshers on. -Excel Advanced Melbourne
Will - Excel Advanced, .
Michael is extremely professional, knowledgeable and I would definitely come back for further training. The pace is perfect and he is always looking out if someone is struggling or behind. -Excel Intermediate Sydney
Lien - Excel Intermediate, .
Great overview and explanations -Excel Intermediate Sydney
Cinzia - Excel Intermediate, .
Very Informative and well delivered -Excel Intermediate Sydney
Taryn - Excel Intermediate, .
good course, very useful -Excel Intermediate Sydney
ANQI - Excel Intermediate, .
Excellent - very well paced and excellent content -Excel Intermediate Sydney
Josh - Excel Intermediate, .
Very good content and clear instructions from Michael. -Excel Intermediate Sydney
Kristen - Excel Intermediate, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us