Book Image

Learn Microsoft Power Apps - Second Edition

By : Matthew Weston, Elisa Bárcena Martín
4 (2)
Book Image

Learn Microsoft Power Apps - Second Edition

4 (2)
By: Matthew Weston, Elisa Bárcena Martín

Overview of this book

Microsoft Power Apps provides a modern approach to building low-code business applications for mobiles, tablets, browsers, and Microsoft Teams. The second edition of Learn Microsoft Power Apps will guide you in creating well designed and secure apps that transform old processes and workflows. Learn Microsoft Power Apps starts with an introduction to Power Apps to help you feel comfortable with the creation experience. Using screenshots from the latest UI, you will be guided through how to create an app, building your confidence to start developing further. This book will help you design, set up, and configure your first application by writing simple formulas. You'll learn about the different types of apps you can build in Power Apps and which one applies best to your requirements. In addition to this, you’ll learn how to identify the right data storage system for you, with new chapters covering how to integrate apps with SharePoint or Dataverse. As you advance, you’ll be able to use various controls, connectors, and data sources to create a powerful, interactive app. For example, this book will help you understand how Power Apps can use Microsoft Power Automate, Power BI, and Azure functionalities to improve your applications. Finally, you will be introduced to the emerging Power Apps Copilot tool, which uses artificial intelligence to accelerate the app building process. By the end of this Power Apps book, you’ll be ready to confidently develop lightweight business applications with minimal code.
Table of Contents (27 chapters)
24
Other Books You May Enjoy
25
Index
Appendix

Data source

One of the great things about Power Apps is that we can use a multitude of different data sources, but we have to be constantly aware of the advantages and disadvantages of each. Personally, I have a method of escalation for my various data sources which helps me to find the right tool for the job.

Excel

Excel is where I tend to start a lot of my developments, although realistically I never consider this as a data source for anything production. The risk of the file accidentally being deleted, the lack of control over each row, plus the issues of lack of simple data validation, carries far too much of a risk for me.

Where Excel does really play a part in my development, though, is for quick and easy modelling of my data structures. Using Excel, I plan out my various tables of data, along with any columns of data which could be included within the table. I don’t worry about relationships at this point, but having my data mapped out will help me to identify where they...