Book Image

Learn Microsoft PowerApps

By : Matthew Weston
Book Image

Learn Microsoft PowerApps

By: Matthew Weston

Overview of this book

Microsoft PowerApps provides a modern approach to building business applications for mobile, tablet, and browser. Learn Microsoft PowerApps will guide you in creating powerful and productive apps that will add value to your organization by helping you transform old and inefficient processes and workflows. Starting with an introduction to PowerApps, this book will help you set up and configure your first application. You’ll explore a variety of built-in templates and understand the key difference between types of applications such as canvas and model-driven apps, which are used to create apps for specific business scenarios. In addition to this, you’ll learn how to generate and integrate apps directly with SharePoint, and gain an understanding of PowerApps key components such as connectors and formulas. As you advance, you’ll be able to use various controls and data sources, including technologies such as GPS, and combine them to create an iterative app. Finally, the book will help you understand how PowerApps can use several Microsoft Power Automate and Azure functionalities to improve your applications. By the end of this PowerApps book, you’ll be ready to confidently develop lightweight business applications with minimal code.
Table of Contents (25 chapters)
Free Chapter
1
Section 1: Getting Started with PowerApps
6
Section 2: Developing Your PowerApp
11
Section 3: Extending the Capabilities of Your PowerApp
18
Section 4: Working with Model-Driven Apps
21
Section 5: Governing PowerApps

Lab 7

In this lab, we are going to establish a connection to a data source that isn't local to our PowerApp. For simplicity, the data source will be an Excel spreadsheet that will need to be stored within cloud storage such as OneDrive.

Activity 1: Preparing the data source

Before we use a connector, the first thing that we need to do is prepare a data source. To demonstrate this, we will use Microsoft Excel and store the data source within OneDrive. Let's get started:

  1. Create an Excel workbook and save it to OneDrive as Assets.xlsx.
  2. Right-click the tab at the bottom of the screen named Sheet1:
  1. Select Rename and change the name of the tab to Categories:

  1. On the Categories tab, add some data, as follows:
  1. Ensure that you have a cell containing data selected, for example, the Category cell, and select Format as Table from the Styles group in the ribbon. Select any formatting you like:
  1. Select the cell range that corresponds to your data, leave My table has headers ticked...