Book Image

Microsoft Power Apps Cookbook, 2e - Second Edition

By : Eickhel Mendoza
3 (1)
Book Image

Microsoft Power Apps Cookbook, 2e - Second Edition

3 (1)
By: Eickhel Mendoza

Overview of this book

Power Apps is a low-code platform owned by Microsoft. With this platform, you can create solutions to solve your business needs while integrating with other components of the Power Platform, such as Microsoft Power Automate, Microsoft Power BI, and others. This book is a handy solution guide to meet many organizational requirements. Microsoft Power Apps Cookbook, Second Edition, takes a pragmatic approach where every business scenario is presented in a quick, practical, and action-oriented recipe. You will be able to use these instant solutions in your development environment and customize your business apps to meet challenging business needs. This will help you handle real-world scenarios and experiences to give you a head start in your Power Apps projects. You will discover various aspects of Power Apps, from building canvas apps, designing model-driven solutions, extending apps with custom connectors, and integrating apps with other platforms, to the pro-developer side including Power Apps Component Framework and creating website experiences for external users with Power Pages. By the end of this Microsoft Power Apps book, you will have gained experience in developing applications using the Power Apps platform and all its features.
Table of Contents (15 chapters)
13
Other Books You May Enjoy
14
Index

Changing Azure SQL Server connections in Power Apps with ease

Building an 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 your application’s instant capabilities 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-user’s daily...