Power Platform Labs and Challenges

Pre-Day Workshop content – Microsoft Flow and PowerApps: Microsoft Power platform app in a day

Earlier this weekend, on 23rd Sept 2018, we ran a Pre-Day Power platform workshop at the Ignite event in Orlando. During this workshop, we provided attendees with an à la carte menu of options to choose from a range of introductory to intermediate labs and challenges. The workshop was attended by more than 150 attendees and we got a lot of encouraging feedback from the attendees:

“I was skeptical of having multiple ‘levels’ in the same session, but it worked out very well. Thanks!”

“opened up a huge world of possibilities.”

“This session was best of show so far for me. I learned a ton of info.”

We want to share the content out broadly and encourage everyone to reuse the content from the workshop for conducting workshops and trainings internally within your organization, community & user groups.

There are two types of contents linked from in the app, Labs & Challenges.

Labs: Each Lab contains step-by-step guidance with screenshots for users to follow along

Challenges: Each challenge describes a specific task to complete or problem to solve. Users won’t be provided detailed instructions for how to solve the problem, however most challenges have Solution Hints and / or links to important blogs, documentation articles or videos.

The content is structured in the following 6 scenarios:

Hands-on-Labs

App in a Day Lab

Dashboard in a Day Lab

Flow in a Day Lab

Challenges

Conference App Challenge

Photo App Challenge

SharePoint Challenges

Installing Instructions

Save a local copy of the lab contents: Downloadthe ChallengesApp.zip file for the lab from https://aka.ms/PowerPlatformChallenges. Save it to a local folder, such as C:\PowerPlatformChallenges. Extract the ZIP package. This package contains a PowerApp file (MSAPP file), an Excel file – ChallengesAppData.xlsx (which contains the static data used in this app) & soft copy of this document.Note: The data required for the app is already included in the app, you might need to use the ChallengesAppData.xlsx only to customize the labs & challenges that you want to share with your audience.

Task 2: Sign-in to PowerApps

Confirm that you are licensed to use PowerApps: Go to https://web.powerapps.com and sign-in with your business or school account. This is the same as your Office 365 or Dynamics 365 login.

Open PowerApps : Click on Open on the left navigation. Then click on Browse. Select the Challenges App.msapp file from the folder where you unzipped the contents of the zip file.

Content – Hands-on-Labs

App in a Day Lab

The App in a Day Lab is a beginner level lab for you to get hands on experience with Microsoft Business Application Platform technologies – PowerApps, Microsoft Flow, Power BI and Common Data Service for Apps. The lab includes step-by-step instructions for someone new to these technologies to build a device ordering solution in less than a day. If you haven’t done the App-in-a-Day lab yet, we recommend you to start with it first, which has been updated just before the Ignite event and an additional Power BI module has been added.

Technologies covered:

PowerApps: A software as a service application platform that enables power users in line of business roles to easily build and deploy custom business apps. There are dedicated modules to both canvas and Model-driven apps.

Common Data Service (CDS): Make it easier to bring your data together and quickly create powerful apps using a compliant and scalable data service and app platform that’s integrated into PowerApps.

Microsoft Flow: A business service for line of business specialists and IT pros to build automated workflows intuitively.

Power BI (new): Self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

Make sure to follow all the pre-requisite steps listed in Module 0 before starting the labs.

Additional Challenges in the App in a Day Lab scenario

In addition to the 5 modules for App in a Day, this scenario also contains a PowerApps Training app which use a PowerApps canvas app to train on various PowerApps canvas apps concepts and several other challenges that are related to the Device Ordering App. Feel free to check them out.

Dashboard in a Day Lab

The Dashboard in a Day Lab is a beginner level lab for you to get hands on experience with Power BI. The lab has two main sections:

Power BI Desktop: This section highlights the features available in Power BI Desktop and walks the user through the process of bringing in data from the data source, modeling and creating visualizations.

Power BI Service: This section highlights the features available in Power BI Service including the ability to publish the Power BI Desktop model to the web, creating and sharing dashboard and Power Q & A.

Flow in a Day Lab

The Flow in a Day Lab is a beginner level lab for you to get hands on experience with Microsoft Flow. The lab has 6 Labs & 5 Hackathon themes. The Labs contain step-by-step guidance for 6 different scenarios and the themes are like challenges which contain links to blogs or videos – but are not detailed out like the labs.

Lab 1. Building a time tracking flow

Lab 2. Approvals (Part 1) – Travel Approval

Lab 3. Flow Notifications and Conditions

Lab 4. Flow control, variables, expressions

Lab 5. Dynamically add a person’s manager as an approver (Approval Part 2)

Lab 6. Task overdue

Additional Challenges in the Flow in a Day Lab scenario

In addition to the 5 modules for App in a Day, this scenario also contains several other Flow challenges. Feel free to check them out.

Photo App Challenge

The Scenario The marketing managers at Contoso Inc. want a single location to manage image assets for marketing campaigns. They’ve created an app called “Photo Central” to store these images that can be uploaded and managed by members of the marketing team.

Conference App Challenge

The Conference app challenge revolves creating a Conference app to be used by employees for attending an internal conference. All the data for the app is to be stored in Common Data Service. Each of the challenge in the scenario involves the various steps that have to be done for building the app.

Content – Slide decks

The zip file also contains a “PowerPlatformPreDaySlides.zip” file containing a couple of slide decks that were presented during the Pre-Day Workshop. You may choose to reuse them for any internal workshops or trainings that you conduct.

PRE26_PowerPlatform_AppInADay.pptx : Presentation to walk through the agenda of the day and introduce the various lab and challenges options.

Power Platform Intro – Ignite 2018 Pre-Day.pptx: An introduction to the technologies that constitutes the Power Platform – PowerApps, Microsoft Flow, Power BI