book

Microsoft Power Apps Cookbook - Second Edition

Name: Microsoft Power Apps Cookbook - Second Edition
Author: Eickhel Mendoza
ISBN: 9781803238029

by Eickhel Mendoza

August 2022

Intermediate to advanced

414 pages

9h 32m

English

Packt Publishing

Read now

Unlock full access

Preface
Who this book is forWhat this book coversTo get the most out of this bookGet in touch
Building Pixel-Perfect Solutions with Canvas Apps
Discovering best practices when building canvas appsVariable namingControl usageCoding methodologyCreating an incident tracking solution – setting up the data sourceGetting readySharePoint Online performance considerationsHow to do it…How it works…Creating an incident tracking solution – building the user interfaceGetting readyHow to do it…How it works…Embedding an expense tracking list with SharePoint list Power AppsGetting readyHow to do it…How it works…There’s more…Creating a canvas app from existing dataGetting readyHow to do it…How it works…There’s more…
Building from Data with Model-Driven Apps
Technical requirementsLicensing requirementsExploring DataverseConfiguring the environmentGetting readyHow to do it…How it works…Building a Power Platform solutionGetting readyHow to do it…How it works…Defining data structuresGetting readyTicketTicket operationProjectAccountHow to do it…How it works…There’s more…Building the model-driven appGetting readyHow to do it…How it works…Setting up business process logicGetting readyHow to do it…How it works…Designing dashboards to visualize dataHow to do it…How it works…There’s more…Integrating canvas apps inside model-driven appsHow to do it…How it works…Improving model-driven apps with custom pagesGetting readyHow to do it…How it works…There’s more…
Choosing the Right Data Source for Your Applications
Technical requirementsData sources and the licensing modelPower Apps/Power Automate for Microsoft 365Reducing your application complexity by using Azure SQL database viewsGetting readyHow to do it…Provisioning the data sourceHow it works…There’s more…Choosing the right data source – real-world testsGetting readyHow to do it…How it works…There’s more…Integrating on-premises data with the data source flexibility of canvas appsGetting readyHow to do it…How it works…Improving application speed and responsiveness by using static dataGetting readyHow to do it…How it works…Consuming external data by using DataflowsGetting readyHow to do it…How it works…There’s more…
Automating Processes with Power Automate
Technical requirementsThe different types of flowsAutomated cloud flowInstant cloud flowScheduled cloud flowBusiness process flowDesktop flowCreating a sales survey solution with Power Automate and Microsoft FormsGetting readyHow to do it…How it works…Building a file processing automation for SharePoint document librariesGetting readyHow to do it…How it works…Overcoming Power Apps delegation with Power AutomateGetting readyHow to do it…How it works…There’s more…Creating a modular solution with Power AutomateGetting readyHow to do it…How it works…There’s more…Automating applications using desktop flowsGetting readyHow to do it…How it works…There’s more…Integrating Google Forms with Dataverse using cloud flowsGetting readyHow to do it…How it works…There’s more…
Extending the Platform
Technical requirementsUser interface guidelinesSetting up your first canvas app componentGetting readyHow to do it…How it works...There’s moreBuilding a floating action button componentHow to do it...How it works...There’s more…Creating a vertical navigation componentHow to do it...How it works...Developing template fields using componentsHow to do it...How it works...Using the Power Apps component libraryGetting readyHow to do it...How it works...Expanding communications with custom connectorsGetting readyHow to do it...How it works...There’s more…Integrating map capabilities into canvas appsGetting readyHow to do it...How it works...There’s more…Extending canvas solutions using Mixed RealityGetting readyHow to do it…How it works...There’s more…
Improving User Experience
Technical requirementsEnhancing the design of our application interfacesGetting readyHow to do it…Improving the Browse screenRefining the Detail screenFinishing touches for the Edit screenHow it works…There’s more…Building a responsive password manager in Power Apps – setting up the Azure Key Vault serviceGetting readyHow to do it…How it works…Building a responsive password manager in Power Apps – designing an adaptive applicationGetting readyHow to do it…How it works…
Power Apps Everywhere
Technical requirementsDiscovering applications through the Pin to Home feature on mobile devicesHow to do it…How it works…There’s more…Google PlayApple’s App StoreLeveraging modern browsers for Power AppsGetting readyHow to do it…Microsoft EdgeGoogle ChromeOn both browsersHow it works…There’s more…Improving SharePoint document libraries with Power AppsGetting readyHow to do it…How it works…There’s more…Embedding Power Apps in SharePoint pagesGetting readyHow to do it…How it works…There’s more…Making Power BI reports interactive with embedded Power AppsGetting readyHow to do it…Provisioning the data sourceInstalling and configuring Power BI DesktopBuilding the Power AppHow it works…Working with Power Apps in Microsoft Teams channelsGetting readyHow to do it…Building the canvas appMicrosoft Teams integrationHow it works…There’s more…Automating the integration of Power Apps inside TeamsGetting readyHow to do it…Importing the demo appConfiguring Microsoft Teams policiesBuilding a secure app registrationAutomatic deployment of TeamsHow it works…Building apps with Dataverse for TeamsGetting readyHow to do it…How it works…There’s more…
Empowering Your Applications with No Code Artificial Intelligence
Technical requirementsCreating a customer success solution using sentiment analysisGetting readyHow to do it…Creating the SharePoint listBuilding the canvas appHow it works…Building a text recognition system using canvas appsGetting readyHow to do it…Creating the solutionDefining the tableBuilding the appHow it works…There’s more…Using Power Automate to create an invoice classification systemGetting readyHow to do it…Configuring the modelCreating the SharePoint document libraryBuilding the cloud flowHow it works…There’s more…
Discovering the Power Platform Admin Center
Technical requirementsManaging Power Platform environmentsHow to do it…Creating an environment without a databaseCreating an environment with a databaseHow it works…Gathering Power Platform analyticsGetting readyHow to do it…Power Platform admin centerPower Apps maker portalSharePoint list Power AppsPower AutomateHow it works…There’s more…Handling connectors through data policiesGetting readyHow to do it…How it works…There’s more…

Tips, Tricks, and Troubleshooting
Technical requirementsSharing OneDrive data between tenantsGetting readyHow to do it…Uploading the dataBuilding the cloud flow to get Excel dataBuilding the cloud flow to communicate with Power AppsBuilding the appHow it works…Playing with vectors – SVG in canvas appsHow to do it…How it works…There’s more…Transferring SharePoint list apps from one site to anotherGetting readyHow to do it…Building and customizing the list on the source siteExporting the appConfiguring the destination siteTransforming the exported packageImporting the new packageHow it works…Troubleshooting using the Power Apps canvas MonitorGetting readyHow to do it…Provisioning the SharePoint listBuilding the appHow it works…There’s more…Extending screen real estate using the canvas controlGetting readyHow to do it…How it works…Changing Azure SQL Server connections in Power Apps with easeGetting readyPowerShellAzure SQL databasesHow to do it…Creating the environmentsBuilding the appExporting the appTransforming the exported packageHow it works…There’s more...Renaming files in SharePoint document librariesGetting readyHow to do it…Creating the SharePoint document libraryBuilding the cloud flowConfiguring the document libraryHow it works…
Advanced Techniques with Power Apps Component Framework
Technical requirementsSetting up your environmentsGetting readyHow to do it…Node.js/npmMicrosoft Power Platform CLIEditor – VS CodeEditor – Visual Studio 2017 or laterConfiguring the Power Platform environmentHow it works…There’s more…Configuring Font AwesomeHow to do it…How it works…Creating the projectGetting readyHow to do it…How it works…Building the application logicHow to do it…How it works…Deploying the solutionHow to do it…Building the solutionDeploying to the environmentHow it works…Testing the component on a canvas appHow to do it…How it works…There’s more…
Reaching Beyond the Organization with Power Pages
Technical requirementsSetting up Power PagesGetting readyHow to do it…How it works…There’s more…Extending the Dataverse solutionGetting readyHow to do it…How it works…Building the help desk interfaceGetting readyHow to do it…How it works…Configuring user access and securityGetting readyHow to do it…Setting up permissionsSecuring page accessHow it works…There’s more…Automating record attributesGetting readyHow to do it…How it works…There’s more…Adding custom fonts to the portalGetting readyHow to do it…Preparing the local version of the portalUsing preinstalled fontsUsing fonts from Google Fonts’ repositoryHow it works…There’s more…
Other Books You May Enjoy
Index

Overview

Microsoft Power Apps Cookbook, Second Edition, is your ultimate guide to unlocking the full potential of Microsoft's low-code platform for building custom business applications. From practical recipes that solve real-world challenges to advanced techniques, this book empowers you with tools to streamline processes and elevate your organization's productivity.

What this Book will help me do

Master the skills to design and implement canvas and model-driven apps to fit your business requirements.
Utilize Microsoft Dataverse effectively as the data backbone for your applications.
Automate business workflows dynamically using Power Automate and robotic process automation techniques.
Expand your application's capabilities with AI Builder and mixed reality integrations for innovative solutions.
Harness the Power Apps Component Framework to build powerful, customized extensions to meet enterprise-grade needs.

Author(s)

Eickhel Mendoza is a seasoned professional in low-code application development, specializing in the Microsoft Power Platform. With extensive experience in helping organizations implement effective solutions and improve productivity, Eickhel brings a pragmatic, hands-on approach to technical writing. His deep understanding of Power Apps and user-centric teaching style make this book an invaluable resource for developers and citizen creators alike.

Who is it for?

This book is designed for information workers, IT professionals, and citizen developers aiming to build custom applications tailored to their organizational needs. It is equally beneficial for traditional application developers interested in leveraging a rapid application development platform. A basic understanding of the Microsoft Power Platform ecosystem is recommended to make the most out of this book.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781803238029

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills