Pro Microsoft Power Platform: Solution Building for the Citizen Developer

✍ Scribed by Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana

• Publisher: Apress
• Year: 2020
• Tongue: English
• Leaves: 400
• Edition: 1st ed.
• Category: Library

✦ Synopsis

Become a self-sufficient citizen developer by learning the tools within the Microsoft Power Platform and how they can be used together to drive change and multiply your productivity. Learn about PowerApps for building applications, Power Automate for automating business processes across those applications, and Power BI for analyzing results and communicating business intelligence through compelling visuals. By understanding the purpose and capabilities of these tools, you will be able to enhance your organization’s visibility into key areas and make informed business decisions in a timely matter.
This book is divided into four parts and begins in Part I by showing you how to build applications through PowerApps. You will learn about screens and controls, application sharing and administration, and how to make your applications accessible from mobile devices such as phones and tablets. Part II is about creating workflows using Power Automate that implement business logic across your applications. Part III brings in dashboards and data analysis, showing you how to connect to a data source, cleanse the data from that source, and drive decision making through interactive reports and storytelling. Part IV brings together all the pieces by showing the integrations that are possible when all three tools are combined into a single solution.

What You Will Learn

• Understand the need for the citizen developer in today’s business environment
• Organize and plan the building of line-of-business applications with PowerApps solutions
• Replace wasteful paper processes with automated applications built in PowerApps
• Automate workflows across processes with Power Automate
• Communicate analytical results through visualizations and storytelling
• Integrate PowerApps, Power Automate, and Power BI into solutions that multiply productivity

Who This Book Is For
Power users and analysts with strong Excel skills who need a more comprehensive set of tools that can better help them accomplish their vision on projects, those familiar with one of the Power Platform tools who wish to learn how all three can fit together, and those who are seen as as “rogue IT” problem solvers who get things done when others have tried but failed

✦ Table of Contents

Front Matter ....Pages i-xxiii
Front Matter ....Pages 1-1
Introduction to Power Apps (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 3-9
Building Your First Power App (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 11-16
Exploring Power Apps Screens and Controls (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 17-27
Working with Power Apps Expressions (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 29-40
Leveraging Variables and Collections (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 41-46
Securing and Sharing Apps (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 47-51
Managing Power Apps (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 53-60
Common Data Services and Model-Driven Apps (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 61-70
Front Matter ....Pages 71-71
Introduction to Power Automate (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 73-78
Building Your First Flow (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 79-93
Exploring Different Trigger Types (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 95-109
Working with Flow Expressions (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 111-125
Building Conditional Flows (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 127-141
Designing Approval Flows (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 143-158
Administering Power Automate (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 159-170
Front Matter ....Pages 171-171
Introduction to Power BI (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 173-189
Connecting to Data (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 191-210
Defining Data Cleansing Business Rules with the Power Query Editor (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 211-229
Data Model Design (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 231-244
Extending Your Data Model with DAX Calculations (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 245-257
Report Writing Basics (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 259-277
Designing Interactive Reports (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 279-289
Data Storytelling with Power BI (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 291-305
Sharing Power BI Solutions (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 307-319
Administering Power BI (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 321-330
Front Matter ....Pages 331-331
Power Platform Integration in Power Apps (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 333-342
Power Platform Integration in Power Automate (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 343-355
Power Platform Integration in Power BI (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 357-364
Designing a Fully Integrated Power Platform Solution (Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana)....Pages 365-388
Back Matter ....Pages 389-396

✦ Subjects

Computer Science; Microsoft and .NET