Creating Business Applications with Microsoft 365 : Techniques in Power Apps, Power BI, SharePoint, and Power Automate / by Jeffrey M. Rhodes.

Format:

Book

Author/Creator:

Rhodes, Jeffrey M., author.

Series:

Professional and Applied Computing.

Language:

English

Subjects (All):

Microsoft software.

Microsoft .NET Framework.

Compilers (Computer programs).

Computer networks.

Microsoft.

Compilers and Interpreters.

Computer Communication Networks.

Local Subjects:

Microsoft.

Compilers and Interpreters.

Computer Communication Networks.

Physical Description:

1 online resource (424 pages)

Edition:

2nd ed. 2022.

Place of Publication:

2022.

Berkeley, CA : Apress : Imprint: Apress, 2022.

Summary:

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 extendedexample 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. You will: 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.

Contents:

Chapter 1. Programming in the Power Platform

Chapter 2. Updating a SharePoint List Using Power Apps

Chapter 3. Creating an Approval Process with Power Automate

Chapter 4. Creating a Survey Response Dashboard with Microsoft Power BI

Chapter 5. Creating a Survey Solution with Forms, Power Automate, SharePoint, and Power BI

Chapter 6. Power BI Challenges with JSON, XML, and Yes/No Data

Chapter 7. Power BI Case Study: Monitoring BMC Remedy Help Tickets

Chapter 8. Building a Help Ticketing System in Power Apps and SharePoint – New Ticket Form

Chapter 9. Continuing the Help Ticketing System – Technician Form

Chapter 10. Using Power BI for the Help Ticketing System

Chapter 11. Overcoming Power Apps Delegation Issues with SharePoint & Excel Data Sources

Chapter 12. Creating a Class Sign-Up Solution in SharePoint and Power Apps. – Chapter 13. 13 - Working with SharePoint Lookup Columns in Power BI

Chapter 14. Visualizing Learning Management Data from SQL Server usingPower BI

Chapter 15. Dynamic Information in Power Apps and Sending an Adaptive Card to Teams using Power Automate

Chapter 16. Dynamically Setting Object Properties in Power Apps Based on a SharePoint List

Chapter 17. Uploading Files from Power Apps to SharePoint and Emailing Links using Power Automate

Chapter 18. Using Power BI to Find Inconsistent Data Between Excel Spreadsheets

Chapter 19. 19 - Linking Power BI to Microsoft Forms Responses and Showing the Most Current Submission

Chapter 20. Copying Microsoft Forms Attachments to a SharePoint List Item using Power Automate

Chapter 21. Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint

Chapter 22. Creating a Reservations Booking Solution in Power Apps, SharePoint, and Power Automate

Chapter 23, Using the Power Apps Form Control to Create a Weekly Priorities Status Report

Chapter 24. Creating a Scoring Application in Power Apps and SharePoint.

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

1-4842-8823-8

OCLC:

1351202523