Pro Microsoft Power Platform : Solution Building for the Citizen Developer

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 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 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