Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Learn Microsoft PowerApps
Learn Microsoft PowerApps

Learn Microsoft PowerApps: Build customized business applications without writing any code

eBook
$9.99 $47.99
Paperback
$59.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Learn Microsoft PowerApps

Introducing PowerApps

In this chapter, we will look at some of the basic concepts of PowerApps at a high level, and look at where we can access the various aspects that add depth to our PowerApps. We will also look at some of the out of the box apps that are provided by PowerApps, in order to give you some good examples of what is easily achievable.

We will also look at the licensing around PowerApps so that you understand how they are charged for, as well as the levels of functionality available with each type of license. This is so you can plan for any specific licenses which you may need during the development of your apps.

Finally, we will look at the development environment, specifically the PowerApps portal and the studio, as part of the learning process is just finding out where information and components are located.

In this chapter, we will cover the following topics...

Technical requirements

In order to follow this and all the subsequent chapters in this book, you will need to have access to Microsoft PowerApps. As we will be exploring both standard and premium features, I would recommend that you sign up for a PowerApps Community Plan at https://powerapps.microsoft.com/en-us/communityplan/.

Understanding PowerApps

PowerApps is an ever-growing part of the Microsoft Office 365 ecosystem, where developers and business users alike are empowered to create apps. In the past, for this to be achieved with SharePoint, you would have to use products such as InfoPath, where you could combine custom logic with a number of visual components to extend the user experience:

Figure 1.1: InfoPath as an editing application

PowerApps are created using visual tools that are provided through the browser and remove the dependency on needing additional applications to be installed on the desktop. However, this also builds into the Microsoft vision of mobility, where a user can work on their app anywhere in the world, at any time, from any device.

PowerApps aren't written with code; instead, they are created with formulas, similar to Microsoft Excel, a tool that the majority of the modern workforce are familiar with. For example, if we wanted to combine or concatenate strings in Excel, we...

Understanding PowerApps licensing

There are a number of options available when it comes to licensing PowerApps. Like all of Microsoft's products, there are differing levels of license available, which will govern what functionality you can use or what connectors you have available to you. As of 1st October 2019, PowerApps licensing has undergone quite a radical change, and the following sections will explain what the key licensing aspects are.

Seeded apps

PowerApps is not included with the home versions of Office 365; however, it is included with most of the business licenses and all of the enterprise licenses. This means that the majority of Office 365 users will have the ability to create and use PowerApps to enhance, extend, and customize their Office applications. This is now what is known as seeded apps; that is, they are a part of the Office 365 and Dynamics 365 licenses.

Since they are a part of the Office 365 and Dynamics 365 packages, they do not cost you or your organization...

Understanding the types of apps

When creating a PowerApp, there are two distinct types of app, both of which have very different applications. Before you start creating apps, you should have a clear understanding of what these two types are and what benefits they bring. This will allow you to make the right selection and therefore create a great app that will add value to your organization. Both types of app are designed to be codeless and therefore within the realm of the ability of IT professionals and power users; however, developers can add a lot of value by developing code and calling it in various ways.

The two types of app are as follows:

  • Canvas apps
  • Model-driven apps

Both apps allow you to easily build apps and share access to the CDS:

Figure 1.6: Logical hierarchy for the types of app

Understanding what the different types of app are will help you to make the correct decision when you are developing. Let's start by looking at canvas apps.

Canvas apps

Canvas apps are the...

The start screen

To start your PowerApps journey, we need to navigate to the start screen. Office 365 has shown that Microsoft is being much more consistent in terms of its user experience development throughout the whole ecosystem. Therefore, like other applications, PowerApps is either available from the Office 365 portal page (portal.office.com) or from the app launcher, which is located at the top left corner of the Office 365 portal, as shown in the following screenshot:

Figure 1.9: The Office 365 home page

Regardless of the navigation approach you take, you will find yourself on the PowerApps welcome screen, which will provide you with a wealth of options so that you can start developing.

The Home screen

The home screen is the first page that you will be presented with and provides you with a number of navigation options, including the ability to create new apps, open recent apps, and any apps that have been developed by someone else and shared with you:

Figure 1.10: The PowerApps...

What are templates?

Microsoft provides an expanding gallery of templates that you can use to get your PowerApps journey started. Each template is more than just a scaffold of an app they are fully functional PowerApps that integrate with various aspects of your Office 365 tenancy to provide immediate functionality. In this section, we will look at two of my favorite apps, but it is recommended that you review the functionality that's contained in the others as there are lessons that can be drawn from all of them.

Leave request app

The leave request app is a good example of a generated PowerApp that can quickly add value to organizations that don't rely on an already established system so that you can manage leave requests. It creates a number of screens that show you how you can use various controls and methods of navigation to achieve quite a common business use case.

This PowerApp creates two connections: one to Outlook in order to save and retrieve leave information...

Using PowerApps Studio

PowerApps Studio is your primary developer tool for creating, updating, testing, and deploying canvas apps. In this section, we will explore PowerApps Studio, which is where you will take your app ideas from their conception and deliver them. It is important that you know your way around the studio so that your development time is spent creating the app rather than looking for options and controls. Understanding your development environment will vastly improve your development experience and will also allow you to greatly expand the functionality that's available within your app.

By the end of this section, you will know about the key areas of the PowerApps Studio, including the primary menu area and the formula bar. You will also learn how to view your screens, use the canvas, and find and review the properties of your PowerApp.

PowerApps Studio is completely browser-driven and is supported by all modern browsers, unlike other developer tools. Everything you...

Summary

In this chapter, we looked at the various types of apps that can be created using Microsoft PowerApps and the differences between the canvas apps and the model-driven apps. We explored the ways in which we can get started, whether that's by using a blank app or by using one of the excellent templates that are provided by PowerApps.

As we explored the left-hand side menu, we came across connectors, data models in the form of entities, and Microsoft Power Automate, which is our business logic platform. We can combine all of these to create a powerful app without having to write any code.

We also looked at the key elements of PowerApps Studio, which is the key development tool on your PowerApps journey. We looked at various menus and how they can be used to apply basic styling and configuration to our app and components. We investigated the insert menu and the types of controls that can be added through those menus, which range from screens to media controls.

Then, we looked...

Questions

  1. What are the two types of apps that we can build?
  2. What is the name of the underlying database?
  3. What is used to bridge PowerApps and Flow to other systems?
  4. What technology can be used to access on-premises data sources?
  5. Which type of app gives you full control over the layout of your components?
  6. What can be used to control the potential values of a data field?
  7. Who do I need to share the app with to make my app an org app?
  8. If I want to use the data gateway, which license do I need to buy?
  9. Which submenu should I use to insert a pen input control?
  10. What two views can we use on the screens list?
  11. Which menu should I select if I want to create a connection to Flow?
  12. Where would I go to check my data sources?
  13. What would I use to create conditional logic for a control?
Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Create apps with rich user experiences without paying for costly developers
  • Improve productivity with business process automation using Microsoft Power Automate
  • Build enterprise-grade apps with MS PowerApps’ built-in storage space, Common Data Service

Description

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.

Who is this book for?

This book is ideal for business analysts, IT professionals, and both developers and non-developers alike. If you want to meet business needs by creating high productivity apps, this book is for you. Don’t worry if you have no experience or knowledge of PowerApps, this book simplifies PowerApps for beginners.

What you will learn

  • Design an app by simply dragging and dropping elements onto your canvas
  • Understand how to store images within PowerApps
  • Explore the use of GPS and how you can use GPS data in PowerApps
  • Get to grips with using barcodes and QR codes in your apps
  • Share your applications with the help of Microsoft Teams and SharePoint
  • Use connectors to share data between your app and Microsoft's app ecosystem
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Nov 29, 2019
Length: 560 pages
Edition : 1st
Language : English
ISBN-13 : 9781789805826
Category :
Languages :
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Publication date : Nov 29, 2019
Length: 560 pages
Edition : 1st
Language : English
ISBN-13 : 9781789805826
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 183.97
Microsoft Power Apps Cookbook
$44.99
Microsoft Power Platform Enterprise Architecture
$78.99
Learn Microsoft PowerApps
$59.99
Total $ 183.97 Stars icon
Banner background image

Table of Contents

24 Chapters
Section 1: Getting Started with PowerApps Chevron down icon Chevron up icon
Introducing PowerApps Chevron down icon Chevron up icon
Creating Your First Canvas PowerApp Chevron down icon Chevron up icon
Creating Apps from SharePoint Chevron down icon Chevron up icon
Publishing and Leveraging PowerApps Chevron down icon Chevron up icon
Section 2: Developing Your PowerApp Chevron down icon Chevron up icon
Exploring Controls Chevron down icon Chevron up icon
Exploring Formulas Chevron down icon Chevron up icon
Working with Data Chevron down icon Chevron up icon
Introducing Connectors Chevron down icon Chevron up icon
Section 3: Extending the Capabilities of Your PowerApp Chevron down icon Chevron up icon
Using GPS in PowerApps Chevron down icon Chevron up icon
Working with Images and Barcodes Chevron down icon Chevron up icon
Securing Your PowerApps Chevron down icon Chevron up icon
Working Offline Chevron down icon Chevron up icon
Using Power Automate with PowerApps Chevron down icon Chevron up icon
Using Azure with PowerApps Chevron down icon Chevron up icon
Section 4: Working with Model-Driven Apps Chevron down icon Chevron up icon
Introducing Model-Driven Apps Chevron down icon Chevron up icon
Creating Model-Driven Apps Chevron down icon Chevron up icon
Section 5: Governing PowerApps Chevron down icon Chevron up icon
Exploring Environments within Our Tenancy Chevron down icon Chevron up icon
Assessments Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Half star icon Empty star icon Empty star icon 2.6
(12 Ratings)
5 star 25%
4 star 16.7%
3 star 0%
2 star 8.3%
1 star 50%
Filter icon Filter
Top Reviews

Filter reviews by




Leslie Anne Lighton Dec 18, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great training guide.
Amazon Verified review Amazon
Paul Beck Feb 21, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The book is nicely broken up, extremely easy to follow. If you are new to Power App development I highly recommend "Microsoft PowerApps". The book also has come more advanced topics, so periodically I'm finding it useful to use it as a reference. Great book - highly recommend
Amazon Verified review Amazon
Heath K. Groves Jan 12, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Like all modern technologies there must be an element of refinement and maturity over time. This has certainly happened to the power platforms. Once the new platforms stabilise then experts and serious authors cam finally create the default training manuals for the rest of us… and I’m pleased to say that this really is the number one training manual for Power Apps.For novice and expert alike, it does a great job of taking you through the whole world of Power Apps from licensing all the way to complex, automated scenarios.Whilst it must be a said a little experience in O365 layout and navigation helps – this is not to be unexpected and shouldn’t be a negative due to Power Apps being part of the O365 Exo System.If you are looking to get into power apps or develop your power apps into advanced scenarios, then this is a must for you…This is the first “go to” Power Apps book that I have seen and by far the most comprehensive.
Amazon Verified review Amazon
treesa Jun 05, 2020
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Much respect for the breadth of material covered, but the labs did not seem thoroughly vetted. Had to jury rig in some spots which is a good exercise in itself and overcome some incomplete explanations. That said my only real disappointment was the all too brief exploration of integrations with Azure Functions and Azure Automation.
Amazon Verified review Amazon
Antoine K. Mar 19, 2020
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This was a great book to get you started and show you the basics!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela