Book Image

Microsoft Power Apps Cookbook

By : Eickhel Mendoza
Book Image

Microsoft Power Apps Cookbook

By: Eickhel Mendoza

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)

Changing Azure SQL Server connections in Power Apps with ease

Building a Power App using the Azure SQL connector is a great approach when creating a complex solution to solve a business need. This data source provides many advantages, such as the following:

  • Views, which can help transfer the data joining and transformation processes to the database engine
  • Stored procedures, which consist of a series of code routines that execute at the database level that can help with data processing and validation tasks
  • Scalability, as you can improve the database engine's performance on-demand or by setting a set of rules

These are just some examples of the instant capabilities your application gets when using this data source.

When building complex solutions, it's a good practice to use environments such as development, testing, and production. These environments help developers iterate application versions without affecting end users in their daily tasks when...