Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate, 2nd Edition
- Length: 436 pages
- Edition: 2
- Language: English
- Publisher: Apress
- Publication Date: 2022-11-30
- ISBN-10: 148428822X
- ISBN-13: 9781484288221
- Sales Rank: #436841 (See Top 100 Books)
Learn how to automate processes, visualize your data, and improve productivity using Power Apps, Power Automate, Power BI, SharePoint, Forms, Teams, and more. This book will help you build complete solutions that often involve storing data in SharePoint, creating a front-end application in Power Apps or Forms, adding additional functionality with Power Automate, and effective reports and dashboards in Power BI.
This new edition greatly expands the focus on Power Apps, Power BI, Power Automate, and Teams, along with SharePoint and Microsoft Forms. It starts with the basics of programming and shows how to build a simple email application in .NET, HTML/JavaScript, Power Apps on its own, and Power Apps and Power Automate in combination. It then covers how to connect Power Apps to SharePoint, create an approval process in Power Automate, visualize surveys in Power BI, and create your own survey solution with the combination of a number of Microsoft 365 tools. You’ll work with an extended example that shows how to use Power Apps and SharePoint together to create your own help ticketing system.
This book offers a deep dive into Power BI, including working with JSON, XML, and Yes/No data, as well as visualizing learning data and using it to detect inconsistencies between Excel files. You’ll also see how to connect to Remedy and to the help system you will have created. Under author Jeffrey Rhodes’s guidance, you’ll delve into the Power Apps collection to learn how to avoid dreaded “delegation” issues with larger data sets. Back on applications, you will create a training class sign-up solution to only allow users to choose classes with available seats. Digging deeper into Teams, you’ll learn how to send chats, posts, and “adaptive cards” from Power Automate. Rounding things out, you’ll save Forms attachments to SharePoint with Power Automate, create your own “Employee Recognition” app with all of the Power Platform and Teams, add or edit weekly status reports, and learn how to create reservation and scoring applications.
After reading the book, you will be able to build powerful applications using Power Apps, Power Automate, Power BI, SharePoint, Forms, and Teams.
What You Will Learn
- Create productivity-enhancing applications with Power Apps, Power Automate, SharePoint, Forms, and/or Teams
- Transform and visualize data with Power BI to include custom columns, measures, and pivots
- Avoid delegation issues and tackle complicated Power Apps issues like complex columns, filtering, and ForAll loops
- Build scheduled or triggered Power Automate flows to schedule Teams Meetings, send emails, launch approvals, and much more
Who This Book Is For
Business and application developers.
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
Untitled
Untitled
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
IndexDonate to keep this site alive
How to download source code?
1. Go to: https://github.com/Apress
2. In the Find a repository… box, search the book title: Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate, 2nd Edition, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.
