- \n
- \u201cI was skeptical of having multiple ‘levels’\u00a0 in the same session, but it worked out very well. Thanks!\u201d<\/li>\n
- \u201copened up a huge world of possibilities.\u201d<\/li>\n
- \u201cThis session was best of show so far for me. I learned a ton of info.\u201d<\/li>\n<\/ul>\n
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.<\/p>\n
Download Link: https:\/\/aka.ms\/PowerPlatformChallenges<\/a><\/strong><\/p>\n
If you haven\u2019t done the App-in-a-Day<\/strong> 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.<\/p>\n
Power Platform Labs and Challenges<\/h2>\n
The Labs and Challenges are packaged in a PowerApp (canvas app)<\/a> that contains links to several Labs and Challenges to learn more about the Power Platform<\/a>, which includes PowerApps,<\/a> Power BI<\/a>, Microsoft Flow<\/a> & Common Data Service for Apps<\/a>.<\/p>\n
There are two types of contents linked from in the app, Labs & Challenges.<\/p>\n
Labs:<\/b> Each Lab contains step-by-step guidance with screenshots for users to follow along<\/p>\n
Challenges: <\/b>Each challenge describes a specific task to complete or problem to solve. Users won\u2019t be provided detailed instructions for how to solve the problem, however most challenges have Solution Hints<\/b> and \/ or links<\/b> to important blogs, documentation articles or videos.<\/p>\n
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/98fd28f2-6e4f-45f2-8d45-8e849c724f7b.png\" "\\"image\\"")
<\/a><\/p>\nThe content is structured in the following 6 scenarios:<\/p>\n
Hands-on-Labs<\/b><\/p>\n
- \n
- App in a Day Lab<\/li>\n
- Dashboard in a Day Lab<\/li>\n
- Flow in a Day Lab<\/li>\n<\/ul>\n
Challenges<\/b><\/p>\n
- \n
- Conference App Challenge<\/li>\n
- Photo App Challenge<\/li>\n
- SharePoint Challenges<\/li>\n<\/ul>\n
Installing Instructions<\/h2>\n
Task 1: Download the Lab Files \u2013 https:\/\/aka.ms\/PowerPlatformChallenges<\/a><\/h6>\n
- \n
- Save a local copy of the lab contents: <\/b>Download <\/b>the ChallengesApp.zip<\/b> file for the lab from https:\/\/aka.ms\/PowerPlatformChallenges<\/a><\/b>. 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 \u2013 ChallengesAppData.xlsx (which contains the static data used in this app) & soft copy of this document.
\nNote: <\/strong>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.<\/li>\n<\/ol>\nTask 2: Sign-in to PowerApps<\/h6>\n
- \n
- Confirm that you are licensed to use PowerApps: <\/b>Go to https:\/\/web.powerapps.com<\/a> and sign-in with your business or school account. This is the same as your Office 365 or Dynamics 365 login.<\/li>\n<\/ol>\n
Task 3: Open the PowerApps app<\/h6>\n
- \n
- Open PowerApps Studio: <\/b>When logged in on https:\/\/web.powerapps.com<\/a>, click on Apps<\/b>. Then click on Create an app<\/b>. PowerApps Studio (https:\/\/create.powerapps.com<\/a>) will open up in a new Tab. See screenshot below.<\/li>\n<\/ol>\n
![\"image\"](\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/031c442e-641b-4107-bd4e-e6953a9b5f9e.png\" "\\"image\\"")
<\/a><\/p><\/blockquote>\n- \n
- Open PowerApps : <\/b>Click on Open<\/b> on the left navigation. Then click on Browse<\/b>. Select the Challenges App.msapp<\/b> file from the folder where you unzipped the contents of the zip file.<\/li>\n<\/ol>\n
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/d3ab3baa-3970-41ee-8a5b-1d36163d3c07.png\" "\\"image\\"")
<\/a><\/p><\/blockquote>\nContent – Hands-on-Labs<\/h2>\n
App in a Day Lab<\/h3>\n
The App in a Day Lab<\/b> is a beginner level lab for you to get hands on experience with Microsoft Business Application Platform<\/a> technologies \u2013 PowerApps<\/a>, Microsoft Flow<\/a>, Power BI<\/a> and Common Data Service for Apps<\/a>. 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\u2019t done the App-in-a-Day<\/strong> 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.<\/p>\n
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/42b218d7-901d-4677-ba2f-8c2ab6cfc707.png\" "\\"image\\"")
<\/a><\/p>\nTechnologies covered:<\/p>\n
- \n
- PowerApps<\/b>: 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.<\/li>\n
- Common Data Service<\/b> (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\u2019s integrated into PowerApps.<\/li>\n
- Microsoft Flow<\/b>: A business service for line of business specialists and IT pros to build automated workflows intuitively.<\/li>\n
- Power BI (new)<\/b>: 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.<\/li>\n<\/ul>\n
Make sure to follow all the pre-requisite steps listed in Module 0 before starting the labs.<\/p>\n
Additional Challenges in the App in a Day Lab scenario<\/h3>\n
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.<\/p>\n
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/e8d1fddd-e0f8-4085-9268-4af9a83b0367.png\" "\\"image\\"")
<\/a><\/p>\nDashboard in a Day Lab<\/h3>\n
The Dashboard in a Day Lab<\/b> is a beginner level lab for you to get hands on experience with Power BI<\/a>. The lab has two main sections:<\/p>\n
- \n
- Power BI Desktop<\/b>: 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.<\/li>\n
- Power BI Service<\/b>: 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.<\/li>\n<\/ul>\n
![\"DashboardInADay\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/d169c2b7-91f4-4edb-8eef-a4de5847e82f.png\" "\\"DashboardInADay\\"")
<\/a><\/h3>\nFlow in a Day Lab<\/h3>\n
The Flow in a Day Lab<\/b> is a beginner level lab for you to get hands on experience with Microsoft Flow<\/a>. 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.<\/p>\n
- \n
- Lab 1. Building a time tracking flow<\/li>\n
- Lab 2. Approvals (Part 1) – Travel Approval<\/li>\n
- Lab 3. Flow Notifications and Conditions<\/li>\n
- Lab 4. Flow control, variables, expressions<\/li>\n
- Lab 5. Dynamically add a person\u2019s manager as an approver (Approval Part 2)<\/li>\n
- Lab 6. Task overdue<\/li>\n<\/ul>\n
![\"TimeTrackingFlow\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/ee06e7ee-e8ec-4690-b8d3-9da30d8dab63.png\" "\\"TimeTrackingFlow\\"")
<\/a><\/h3>\nAdditional Challenges in the Flow in a Day Lab scenario<\/h3>\n
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.<\/p>\n
Content-Challenges<\/h2>\n
SharePoint Challenges<\/h3>\n
This scenario contains 10 challenges for SharePoint & Microsoft Flow & 5 challenges for SharePoint & PowerApps, which includes integration scenarios between PowerApps, Microsoft Flow & SharePoint.<\/p>\n
![\"SendEmailToManagerWhenDeleted\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/9e74d96b-e27a-44bc-9047-6ca41ff5a378.png\" "\\"SendEmailToManagerWhenDeleted\\"")
<\/a><\/p>\nPhoto App Challenge<\/h3>\n
The Photo app challenge revolves around a fictitious Photo Central app.<\/p>\n
The Scenario<\/b> The marketing managers at Contoso Inc. want a single location to manage image assets for marketing campaigns. They\u2019ve created an app called \u201cPhoto Central\u201d to store these images that can be uploaded and managed by members of the marketing team.<\/p>\n
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/ee6aac5d-f921-4445-aef2-eaa6f0b61d0b.png\" "\\"image\\"")
<\/a><\/p>\nConference App Challenge<\/h3>\n
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.<\/p>\n
- Power BI Service<\/b>: 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.<\/li>\n<\/ul>\n
- Common Data Service<\/b> (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\u2019s integrated into PowerApps.<\/li>\n
- PowerApps<\/b>: 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.<\/li>\n
- Open PowerApps : <\/b>Click on Open<\/b> on the left navigation. Then click on Browse<\/b>. Select the Challenges App.msapp<\/b> file from the folder where you unzipped the contents of the zip file.<\/li>\n<\/ol>\n
- Open PowerApps Studio: <\/b>When logged in on https:\/\/web.powerapps.com<\/a>, click on Apps<\/b>. Then click on Create an app<\/b>. PowerApps Studio (https:\/\/create.powerapps.com<\/a>) will open up in a new Tab. See screenshot below.<\/li>\n<\/ol>\n
- Confirm that you are licensed to use PowerApps: <\/b>Go to https:\/\/web.powerapps.com<\/a> and sign-in with your business or school account. This is the same as your Office 365 or Dynamics 365 login.<\/li>\n<\/ol>\n
- Save a local copy of the lab contents: <\/b>Download <\/b>the ChallengesApp.zip<\/b> file for the lab from https:\/\/aka.ms\/PowerPlatformChallenges<\/a><\/b>. 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 \u2013 ChallengesAppData.xlsx (which contains the static data used in this app) & soft copy of this document.
![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1326ab0b-f5e4-4298-898c-285fc1412989.png\" "\\"image\\"")
<\/a><\/p>\n![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/c422928c-dbbd-4212-9ac1-a6a2f46de74c.png\" "\\"image\\"")
<\/a><\/p><\/blockquote>\n![\"image\"](\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/a7a7d296-781a-4b71-9c7a-5d4e0dfcfe47.png\" "\\"image\\"")
<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"