Previously Excel Consulting

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!

 

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18890 Reviews
WELL SPOKEN -Excel Advanced Perth
RENAE - Excel Advanced, .
Course was very easy to follow and well paced. Steven was excellent at explaining everything and answering questions etc. -SharePoint Site Owner Brisbane
Louise - SharePoint Site Owner, .
Thank you for a very engaging training course Steven. Much appreciate all you knowledge and sharing you experience. -SharePoint Site Owner Brisbane
Ruth - SharePoint Site Owner, .
Great course highly recommended. -SharePoint Site Owner Brisbane
Andrew - SharePoint Site Owner, .
Great Course. Need better Coffee! :) -SharePoint Site Owner Brisbane
Rod - SharePoint Site Owner, .
Michael has offered a comprehensive training session with some real life suggestions. He was easy to understand and always happy to help. -SharePoint Site Owner Sydney
Claudio - SharePoint Site Owner, .
I thought the course was very informative. So much information and such little time. Could easily be a 3 day course. Thankyou Michael! -SharePoint Site Owner Sydney
Ben - SharePoint Site Owner, .
Very informative and interactive -SharePoint Site Owner Sydney
Arlene - SharePoint Site Owner, .
Great course with real life applications in mind. Course Instructor was clear and easy to understand while working at a pace which was comfortable. -Excel Macros/VBA 2 Day Brisbane
MIchael - Excel Macros/VBA 2 Day, .
Great energy by the instructor Ken. Material is great and up to date. Learned lots of new thing, tips, tricks. I would be interested if there will be any advanced training in the near future. -Power Apps Intermediate Melbourne
Ray - Power Apps Intermediate, .
John was a great instructor, the course was easy to understand and follow. John was also a entertaining instructor. I also learnt skills that i believe i can use straight away into my day to day job and enhance my projects. -Excel Macros/VBA 2 Day Melbourne
Katie - Excel Macros/VBA 2 Day, .
John is great! -Excel Macros/VBA 2 Day Melbourne
Peter - Excel Macros/VBA 2 Day, .
Great cousre -Project Advanced Canberra
matt - Project Advanced, .
Great course -Project Advanced Canberra
VI - Project Advanced, .
Greg was very knowledgeable in the course work, and answered all questions with various options relevant to my feild. Would recommend course to others. -Project Advanced Canberra
Brendan - Project Advanced, .
Danny was excellent. He was clear and thorough in his explanation. The course was very beneficial to our group. -Excel Advanced Sydney
Tanya - Excel Advanced, .
Thank you for guiding us through difficult concepts and customizing the course to our needs. We had a great time and really found the course to be very beneficial. Danny is an excellent trainer. -Excel Advanced Sydney
Marieke - Excel Advanced, .
lot of information -Excel Intermediate Perth
Heather - Excel Intermediate, .
excellent course, easy to understand and having the book to take home is useful in practice -Excel Intermediate Perth
Julie - Excel Intermediate, .
great teaching -Excel Intermediate Perth
Lisa - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia