Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power Bi, Sharepoint, and Power Automate (Paperback)

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.

學習如何使用Power Apps、Power Automate、Power BI、SharePoint、Forms、Teams等工具自動化流程、視覺化數據並提高生產力。本書將幫助您構建完整的解決方案，通常涉及將數據存儲在SharePoint中，在Power Apps或Forms中創建前端應用程序，使用Power Automate添加額外功能，以及在Power BI中創建有效的報告和儀表板。

這本新版書籍大大擴展了對Power Apps、Power BI、Power Automate和Teams的關注，同時還包括了SharePoint和Microsoft Forms。它從編程的基礎知識開始，展示了如何在.NET、HTML/JavaScript、Power Apps獨立使用以及Power Apps和Power Automate結合的情況下構建一個簡單的電子郵件應用程序。然後介紹了如何將Power Apps連接到SharePoint，如何在Power Automate中創建審批流程，如何在Power BI中視覺化調查數據，以及如何使用多個Microsoft 365工具組合創建自己的調查解決方案。您將使用一個擴展示例，展示如何將Power Apps和SharePoint結合使用，創建自己的幫助票系統。

本書深入介紹了Power BI，包括如何處理JSON、XML和Yes/No數據，以及如何將學習數據可視化並用於檢測Excel文件之間的不一致性。您還將了解如何連接到Remedy和您將創建的幫助系統。在作者Jeffrey Rhodes的指導下，您將深入研究Power Apps集合，了解如何避免在處理較大數據集時出現的委派問題。在應用程序方面，您將創建一個培訓課程報名解決方案，只允許用戶選擇有空座位的課程。深入研究Teams，您將學習如何從Power Automate發送聊天、帖子和自適應卡片。最後，您將使用Power Automate將Forms附件保存到SharePoint，使用Power Platform和Teams創建自己的員工認可應用程序，添加或編輯每週狀態報告，並學習如何創建預訂和評分應用程序。

閱讀本書後，您將能夠使用Power Apps、Power Automate、Power BI、SharePoint、Forms和Teams構建強大的應用程序。

您將學到什麼：

- 使用Power Apps、Power Automate、SharePoint、Forms和/或Teams創建提高生產力的應用程序
- 使用Power BI轉換和視覺化數據，包括自定義列、度量和樞紐表
- 避免委派問題，解決複雜的Power Apps問題，如複雜列、過濾和ForAll循環
- 構建定期或觸發的Power Automate流程，以安排Teams會議、發送電子郵件、啟動審批等等

本書適合的讀者：

商業和應用程序開發人員。

Jeffrey Rhodes is a founder and Chief Technical Officer of Platte Canyon Multimedia Software Corporation, a leader in developing commercial e-learning software. He graduated at the top of his class at the Air Force Academy, where he earned a bachelor's degree in electrical engineering. Jeff received a master's degree in economics from the London School of Economics, which he attended under a British Marshall Scholarship. He is the author of Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More, Programming for e-Learning Developers: ToolBook, Flash, JavaScript, and Silverlight, VBTrain.Net: Creating Computer and Web Based Training with Visual Basic .NET. He also co-wrote The ToolBook Companion. He lives in Colorado Springs with his wife Sue and is the proud father of his sons Derek and Michael.

Jeffrey Rhodes是Platte Canyon Multimedia Software Corporation的創始人和首席技術官，該公司是開發商業電子學習軟件的領導者。他在空軍學院以優異成績畢業，獲得電氣工程學士學位。Jeff在倫敦政治經濟學院獲得經濟學碩士學位，並獲得英國馬歇爾獎學金資助。他是《Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More》、《Programming for e-Learning Developers: ToolBook, Flash, JavaScript, and Silverlight》、《VBTrain.Net: Creating Computer and Web Based Training with Visual Basic .NET》的作者。他還與他人合著了《The ToolBook Companion》。他與妻子Sue一起居住在科羅拉多斯普林斯，並為他的兒子Derek和Michael感到自豪。