Muutke küpsiste eelistusi

Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate Second Edition [Pehme köide]

4.00/5 (1 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 418 pages, kõrgus x laius: 254x178 mm, kaal: 824 g, 356 Illustrations, black and white; XVIII, 418 p. 356 illus., 1 Paperback / softback
  • Ilmumisaeg: 16-Nov-2022
  • Kirjastus: APress
  • ISBN-10: 148428822X
  • ISBN-13: 9781484288221
Teised raamatud teemal:
  • Pehme köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate Second EditionSuurem pilt
  • Formaat: Paperback / softback, 418 pages, kõrgus x laius: 254x178 mm, kaal: 824 g, 356 Illustrations, black and white; XVIII, 418 p. 356 illus., 1 Paperback / softback
  • Ilmumisaeg: 16-Nov-2022
  • Kirjastus: APress
  • ISBN-10: 148428822X
  • ISBN-13: 9781484288221
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484288221.html
Märksõnad:
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. Youll work with anextended 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. Youll also see how to connect to Remedy and to the help system you will have created. Under author Jeffrey Rhodess guidance, youll 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, youll learn how to send chats, posts, and "adaptive cards" from Power Automate. Rounding things out, youll 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.
About the Author xi
About the Technical Reviewers xiii
Acknowledgments xv
Introduction xvii
Chapter 1 Programming in the Power Platform
1(24)
Core Programming Concepts
1(1)
.NET
2(3)
HTML/JavaScript
5(4)
Power Apps
9(7)
Power Automate/Power Apps
16(7)
Summary
23(2)
Chapter 2 Updating a SharePoint List Using Power Apps
25(6)
SharePoint List
26(4)
Summary
30(1)
Chapter 3 Creating an Approval Process with Power Automate
31(20)
Building the SharePoint List
31(1)
Creating the Power Automate Flow
32(12)
Testing the Flow
44(5)
Summary
49(2)
Chapter 4 Creating a Survey Response Dashboard with Power BI
51(12)
SharePoint's Default Visualization
51(1)
Connecting to Our SharePoint Results
52(4)
Visualizing Our Data
56(6)
Summary
62(1)
Chapter 5 Creating a Survey Solution with Forms, Power Automate, SharePoint, and Power BI
63(8)
Configuring the Form
63(2)
Adding the SharePoint List
65(1)
Creating the Power Automate Flow
66(2)
Visualize in Power BI
68(2)
Summary
70(1)
Chapter 6 Power BI Challenges with JSON, XML, and Yes/No Data
71(18)
JSON and HTML Data Formats
71(2)
Working with the Data in Power BI
73(5)
Visualizing the Data in Power BI
78(2)
Working with Yes/No Data
80(8)
Summary
88(1)
Chapter 7 Power BI Case Study: Monitoring BMC Remedy Help Tickets
89(6)
A Remedy Dashboard
89(1)
Configuring the Power BI Data Source
90(3)
Summary
93(2)
Chapter 8 Building a Help Ticketing System in PowerApps and SharePoint: New Ticket Form
95(12)
New Ticket Form
95(1)
Setting Up in PowerApps
96(5)
Writing Data Back to SharePoint
101(5)
Summary
106(1)
Chapter 9 Continuing the Help Ticketing System: Technician Form
107(14)
Browse Screen
107(3)
Details Screen
110(1)
New/Edit Screen
111(6)
My Tickets Application
117(2)
Summary
119(2)
Chapter 10 Using Power BI for the Help Ticketing System
121(8)
The Power BI Visualization
121(1)
Configuring Power BI
122(3)
Page-Level Filters
125(3)
Summary
128(1)
Chapter 11 Overcoming Power Apps Delegation Issues with SharePoint and Excel Data Sources
129(24)
Demonstrating Delegation Issues with Excel
130(4)
Demonstrating Delegation Issues with SharePoint
134(16)
The Final Result
150(1)
Summary
151(2)
Chapter 12 Creating a Class Sign-Up Solution in SharePoint and Power Apps
153(18)
The SharePoint Lists
153(5)
Creating the PowerApps Form
158(1)
The Home Screen
158(3)
The New Screen
161(7)
The Delete Screen
168(2)
Summary
170(1)
Chapter 13 Working with SharePoint Lookup Columns in Power BI
171(12)
Connecting to Our Data Sources
171(6)
Visualizing Our Data
177(4)
Summary
181(2)
Chapter 14 Visualizing Learning Management Data from SQL Server Using Power BI
183(16)
Report in Tracker.Net
184(4)
Connecting to and Transforming the Data
188(5)
Visualizing the Data
193(3)
Updating the Drill-Down Interactions
196(2)
Summary
198(1)
Chapter 15 Dynamic Information in Power Apps and Sending an Adaptive Card to Teams Using Power Automate
199(18)
Configuration in SharePoint
200(3)
Creating the Status Application in PowerApps
203(4)
Posting to Teams from Power Automate
207(8)
Summary
215(2)
Chapter 16 Dynamically Setting Object Properties in Power Apps Based on a SharePoint List
217(14)
SharePoint Lists
217(2)
Power Apps: Actions Screen
219(5)
PowerApps: Steps Screen
224(5)
Summary
229(2)
Chapter 17 Uploading Files from Power Apps to SharePoint and Emailing Links using Power Automate
231(20)
Techniques for Uploading Files from PowerApps
231(4)
Saving and Emailing the Files from Power Automate
235(12)
Completing Power Apps Application
247(3)
Summary
250(1)
Chapter 18 Using Power BI to Find Inconsistent Data Between Excel Spreadsheets
251(14)
A Microsoft Access Solution
251(4)
Configuring Our Data in Power BI
255(6)
Visualizing Our Data in Power BI
261(3)
Summary
264(1)
Chapter 19 Linking Power BI to Microsoft Forms Responses and Showing the Most Current Submission
265(26)
How to Decide between Forms and PowerApps
265(1)
Sample Microsoft Form
266(2)
Getting the Path in OneDrive
268(3)
Configuring Our Data in Power BI
271(11)
Visualizing Our Data in Power BI
282(4)
Setting Up a Scheduled Refresh
286(4)
Summary
290(1)
Chapter 20 Copying Microsoft Forms Attachments to a SharePoint List Item Using Power Automate
291(20)
Configuring the Form and List
291(7)
Setting Up the Flow in Power Automate
298(10)
Viewing our Results in SharePoint
308(2)
Summary
310(1)
Chapter 21 Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint
311(32)
Configuring the SharePoint List
312(1)
Creating Our Application in PowerApps
313(7)
Setting Up the Flow in Power Automate
320(8)
Completing the Application in PowerApps
328(5)
Reporting on Employee Recognition in Power BI
333(9)
Summary
342(1)
Chapter 22 Creating a Reservations Booking Solution in Power Apps, SharePoint, and Power Automate
343(22)
Configuring the SharePoint List
343(1)
Creating our Application in PowerApps
344(8)
Adding a Scheduled Flow in Power Automate
352(11)
Summary
363(2)
Chapter 23 Using the Power Apps Form Control to Create a Weekly Priorities Status Report
365(26)
Designing the SharePoint List
365(2)
The Home Screen in PowerApps
367(15)
Adding a Power BI Dashboard
382(5)
Adding a Dashboard Screen in PowerApps
387(2)
Summary
389(2)
Chapter 24 Creating a Scoring Application in Power Apps, SharePoint, and Power BI
391(20)
Setting Up the SharePoint List
392(1)
Building the Interface in PowerApps
393(10)
Adding a Power BI Dashboard
403(7)
Summary
410(1)
Conclusion
410(1)
Index 411
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 masters 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.