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 15837 Reviews
Training is really good. Topics selected were good and all questions were answered patiently. Will prefer this facilitator for the next sessions. -Power BI Intermediate Canberra
suz - Power BI Intermediate, .
Great course, great trainer learned alot -Analysis & Dashboards Brisbane
Karen - Analysis & Dashboards, .
Found it to be very informative. Now I need to go and put it into action. Jagg was an excellent trainer, just the right level of understanding of the differing skills in the room. -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
Thank you -Power BI Intermediate Canberra
Anon - Power BI Intermediate, .
Great -Power BI Intermediate Adelaide
David - Power BI Intermediate, .
Good trainer who made sure I understood everything and took the time to cover any queries I had. Very interactive which really helped my understanding. -Analysis & Dashboards Brisbane
Amy - Analysis & Dashboards, .
Thank you -Analysis & Dashboards Brisbane
LGC - Analysis & Dashboards, .
Excellent Trainer -Power BI Intermediate Canberra
Prakash - Power BI Intermediate, .
Thanks! -Power BI Intermediate Canberra
GP - Power BI Intermediate, .
Thanks. Good efficient course and engaging instructor! -Power BI Intermediate Canberra
Elise - Power BI Intermediate, .
Great knowledge of the trainer, who provided data insight and visualisation advice for various audience -Power BI Beginner Melbourne
Zoe - Power BI Beginner, .
Comprehensive and great for beginners -Power BI Beginner Melbourne
mlim - Power BI Beginner, .
clear teaching -Power BI Beginner Melbourne
Lay - Power BI Beginner, .
thanks John -Power BI Beginner Melbourne
dh - Power BI Beginner, .
John was great to work with. Really enjoyed his style and patience with us. Thanks John! -Power BI Beginner Melbourne
David - Power BI Beginner, .
Good pace and engagement. Answered questions well. Friendly and pleasant. -Power BI Beginner Melbourne
John - Power BI Beginner, .
A thorough overview of analysis and dashboards and the intrinsic possibilities -Analysis & Dashboards Melbourne
LUMART - Analysis & Dashboards, .
Tim was very clear and easy to understand and took the time to understand what we did for our jobs and tried to then give useful examples as to how we could use these tools in our work. -Analysis & Dashboards Melbourne
Nicola - Analysis & Dashboards, .
Very insightful session into Power BI, will definitely come back for another level so I could leverage the tool for the business -Power BI Beginner Melbourne
Tham - Power BI Beginner, .
Good course -Analysis & Dashboards Melbourne
Lauren - Analysis & Dashboards, .

Trusted by Business

Procured by Government

Map of Australia