Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

Table of Contents
About the Author
About the Technical Reviewers
Acknowledgments
Introduction
Chapter 1: Programming in the Power Platform
	Core Programming Concepts
	.NET
	HTML/JavaScript
	Power Apps
	Power Automate/Power Apps
	Summary
Chapter 2: Updating a SharePoint List Using Power Apps
	SharePoint List
	Summary
Chapter 3: Creating an Approval Process with Power Automate
	Building the SharePoint List
	Creating the Power Automate Flow
	Testing the Flow
	Summary
Chapter 4: Creating a Survey Response Dashboard with Power BI
	SharePoint's Default Visualization
	Connecting to Our SharePoint Results
	Visualizing Our Data
	Summary
Chapter 5: Creating a Survey Solution with Forms, Power Automate, SharePoint, and Power BI
	Configuring the Form
	Adding the SharePoint List
	Creating the Power Automate Flow
	Visualize in Power BI
	Summary
Chapter 6: Power BI Challenges with JSON, XML, and  Yes/No Data
	JSON and HTML Data Formats
	Working with the Data in Power BI
	Visualizing the Data in Power BI
	Working with Yes/No Data
	Summary
Chapter 7: Power BI Case Study: Monitoring BMC Remedy Help Tickets
	A Remedy Dashboard
	Configuring the Power BI Data Source
	Summary
Chapter 8: Building a Help Ticketing System in PowerApps and SharePoint: New Ticket Form
	New Ticket Form
	Setting Up in Power Apps
	Writing Data Back to SharePoint
	Summary
Chapter 9: Continuing the Help Ticketing System: Technician Form
	Browse Screen
	Details Screen
	New/Edit Screen
	My Tickets Application
	Summary
Chapter 10: Using Power BI for the Help Ticketing System
	The Power BI Visualization
	Configuring Power BI
	Page-Level Filters
	Summary
Chapter 11: Overcoming Power Apps Delegation Issues with SharePoint and Excel Data Sources
	Demonstrating Delegation Issues with Excel
	Demonstrating Delegation Issues with SharePoint
	The Final Result
	Summary
Chapter 12: Creating a Class Sign-Up Solution in SharePoint and Power Apps
	The SharePoint Lists
	Creating the Power Apps Form
	The Home Screen
	The New Screen
	The Delete Screen
	Summary
Chapter 13: Working with SharePoint Lookup Columns in Power BI
	Connecting to Our Data Sources
	Visualizing Our Data
	Summary
Chapter 14: Visualizing Learning Management Data from SQL Server Using Power BI
	Report in Tracker.Net
	Connecting to and Transforming the Data
	Visualizing the Data
	Updating the Drill-Down Interactions
	Summary
Chapter 15: Dynamic Information in Power Apps and Sending an Adaptive Card to Teams Using Power Automate
	Configuration in SharePoint
	Creating the Status Application in Power Apps
	Posting to Teams from Power Automate
	Summary
Chapter 16: Dynamically Setting Object Properties in Power Apps Based on a SharePoint List
	SharePoint Lists
	Power Apps: Actions Screen
	Power Apps: Steps Screen
	Summary
Chapter 17: Uploading Files from Power Apps to SharePoint and Emailing Links using Power Automate
	Techniques for Uploading Files from Power Apps
	Saving and Emailing the Files from Power Automate
	Completing Power Apps Application
	Summary
Chapter 18: Using Power BI to Find Inconsistent Data Between Excel Spreadsheets
	A Microsoft Access Solution
	Configuring Our Data in Power BI
	Visualizing Our Data in Power BI
	Summary
Chapter 19: Linking Power BI to Microsoft Forms Responses and Showing the Most Current Submission
	How to Decide between Forms and Power Apps
	Sample Microsoft Form
	Getting the Path in OneDrive
	Configuring Our Data in Power BI
	Visualizing Our Data in Power BI
	Setting Up a Scheduled Refresh
	Summary
Chapter 20: Copying Microsoft Forms Attachments to a SharePoint List Item Using Power Automate
	Configuring the Form and List
	Setting Up the Flow in Power Automate
	Viewing our Results in SharePoint
	Summary
Chapter 21: Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint
	Configuring the SharePoint List
	Creating Our Application in Power Apps
	Setting Up the Flow in Power Automate
	Completing the Application in Power Apps
	Reporting on Employee Recognition in Power BI
	Summary
Chapter 22: Creating a Reservations Booking Solution in Power Apps, SharePoint, and Power Automate
	Configuring the SharePoint List
	Creating our Application in Power Apps
	Adding a Scheduled Flow in Power Automate
	Summary
Chapter 23: Using the Power Apps Form Control to Create a Weekly Priorities Status Report
	Designing the SharePoint List
	The Home Screen in Power Apps
	Adding a Power BI Dashboard
	Adding a Dashboard Screen in Power Apps
	Summary
Chapter 24: Creating a Scoring Application in Power Apps, SharePoint, and Power BI
	Setting Up the SharePoint List
	Building the Interface in Power Apps
	Adding a Power BI Dashboard
	Summary
	Conclusion
Index