Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Power Apps Cookbook
  • Table Of Contents Toc
Microsoft Power Apps Cookbook

Microsoft Power Apps Cookbook

By : Eickhel Mendoza
3.9 (7)
Buy this Book
close
close
Microsoft Power Apps Cookbook

Microsoft Power Apps Cookbook

3.9 (7)
By: Eickhel Mendoza
Buy this Book

Overview of this book

Microsoft Power Apps Cookbook is a complete resource filled with meticulously crafted recipes to help you build customized business apps that meet ever-changing enterprise demands. You will learn how to design modern apps with the low-code approach in a rapid application development environment by achieving enterprise-wide business agility.
Table of Contents (13 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Download the example code files
Icon
Download the color images
Icon
Conventions used
Icon
Get in touch
Icon
Reviews
1
Chapter 1: Building pixel-perfect solutions with Canvas Power Apps
Icon
Chapter 1: Building pixel-perfect solutions with Canvas Power Apps
Icon
Discovering best practices when building canvas apps
Icon
Creating an incident tracking solution – Setting up the data source
Icon
Creating an incident tracking solution – Building the user interface
Icon
Embedding an expense tracking list with SharePoint list Power Apps
Icon
Creating a Power App from existing data
Lock Free Chapter
2
Chapter 2: Building from data with model-driven apps
Icon
Chapter 2: Building from data with model-driven apps
Icon
Technical requirements
Icon
Exploring Dataverse
Icon
Building a help desk solution
Icon
Defining data structures
Icon
Building the model-driven app
Icon
Setting up business process logic
Icon
Designing dashboards to visualize data
Icon
Integrating canvas apps inside model-driven apps
3
Chapter 3: Choosing the right data source for your applications
chevron up
Icon
Chapter 3: Choosing the right data source for your applications
Icon
Technical requirements
Icon
Data sources and the licensing model
Icon
Reducing your application complexity by using Azure SQL database views
Icon
Choosing the right data source – real-world tests
Icon
Integrating on-premises data with the data source flexibility of canvas apps
Icon
Improving application speed and responsiveness by using static data
Icon
Consuming external data by using Dataflows
4
Chapter 4: Automating processes with Power Automate
Icon
Chapter 4: Automating processes with Power Automate
Icon
Technical requirements
Icon
The different types of flows
Icon
Creating a sales survey solution with Power Automate and Microsoft Forms
Icon
Building a file processing automation for SharePoint document libraries
Icon
Overcoming Power Apps delegation with Power Automate
Icon
Creating a modular solution with Power Automate
5
Chapter 5: Extending the Platform
Icon
Chapter 5: Extending the Platform
Icon
Technical requirements
Icon
User interface guidelines
Icon
Setting up your first canvas Power Apps component
Icon
Building a floating action button component
Icon
Creating a vertical navigation component
Icon
Developing template fields using components
Icon
Using the Power Apps component library
Icon
Expanding communications with custom connectors
6
Chapter 6: Improving User Experience
Icon
Chapter 6: Improving User Experience
Icon
Technical requirements
Icon
Enhancing application interfaces
Icon
Building a responsive password manager in Power Apps – setting up the Azure Key Vault service
Icon
Building a responsive password manager in Power Apps – designing an adaptive application
7
Chapter 7: Power Apps Everywhere
Icon
Chapter 7: Power Apps Everywhere
Icon
Technical requirements
Icon
Discovering Power Apps Mobile and the Windows desktop player
Icon
Leveraging modern browsers for Power Apps
Icon
Improving SharePoint document libraries with Power Apps
Icon
Embedding Power Apps in SharePoint pages
Icon
Making Power BI reports interactive with embedded Power Apps
Icon
Working with Power Apps in Microsoft Teams channels
Icon
Automating the integration of Power Apps inside Teams
Icon
Building apps with Dataverse for Teams
8
Chapter 8: Empowering your applications with no code Artificial Intelligence
Icon
Chapter 8: Empowering your applications with no code Artificial Intelligence
Icon
Technical requirements
Icon
Creating a customer success solution using sentiment analysis
Icon
Building a text recognition system using canvas apps
Icon
Using Power Automate to create an invoice classification system
9
Chapter 9: Discovering the Power Platform admin center
Icon
Chapter 9: Discovering the Power Platform admin center
Icon
Technical requirements
Icon
Managing Power Platform environments
Icon
Gathering Power Platform analytics
Icon
Synchronizing data using data integration
Icon
Managing connectors through data policies
10
Chapter 10: Tips, Tricks, and Troubleshooting
Icon
Chapter 10: Tips, Tricks, and Troubleshooting
Icon
Technical requirements
Icon
Sharing OneDrive data between tenants
Icon
Playing with vectors – SVGs in canvas apps
Icon
Transferring SharePoint List Power Apps from one site to another
Icon
Troubleshooting using the Power Apps canvas Monitor
Icon
Extending screen real estate using the canvas control
Icon
Handling image resources in components
Icon
Changing Azure SQL Server connections in Power Apps with ease
Icon
Renaming files in SharePoint document libraries
11
Chapter 11: Advanced Techniques with Power Apps Component Framework
Icon
Chapter 11: Advanced Techniques with Power Apps Component Framework
Icon
Technical requirements
Icon
Setting up your environments
Icon
Configuring Font Awesome
Icon
Creating the project
Icon
Building the application logic
Icon
Deploying the solution
Icon
Testing the component on a canvas app
12
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Reducing your application complexity by using Azure SQL database views

Performance is one of the main objectives of almost all data source engines. Database developers tweak the innards of their core systems to make them as efficient as possible while also adding new features for app makers. Knowing this, why not leverage the efficiency of these platforms?

That's the primary purpose of this recipe, to learn how to improve our apps' responsiveness and complexity by making the data sources work for us.

Getting ready

We will improve the application's complexity and performance when connected to an Azure SQL database to build our use case. The database needs five tables that will make up our data catalog. The scripts to create them and the base apps are available in our GitHub repository: https://github.com/PacktPublishing/Microsoft-Power-Apps-Cookbook/tree/master/Chapter03

If you don't have an Azure subscription, you can request a free version with credit...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Power Apps Cookbook
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon