© 2019

Creating Business Applications with Office 365

Techniques in SharePoint, PowerApps, Power BI, and More


Table of contents

  1. Front Matter
    Pages i-xviii
  2. Jeffrey M. Rhodes
    Pages 5-10
  3. Jeffrey M. Rhodes
    Pages 11-20
  4. Jeffrey M. Rhodes
    Pages 21-28
  5. Jeffrey M. Rhodes
    Pages 29-39
  6. Jeffrey M. Rhodes
    Pages 41-54
  7. Jeffrey M. Rhodes
    Pages 55-75
  8. Jeffrey M. Rhodes
    Pages 77-84
  9. Jeffrey M. Rhodes
    Pages 85-87
  10. Jeffrey M. Rhodes
    Pages 105-115
  11. Jeffrey M. Rhodes
    Pages 123-132
  12. Jeffrey M. Rhodes
    Pages 159-164

About this book


Take your Office 365 and SharePoint projects to a higher level by using PowerApps, Flow, Power BI, JavaScript/jQuery jQuery UI widgets, Cascading Style Sheets (CSS), and more. This book will help you create easier solutions to client-side problems and applications. Additionally, you will be able to effectively visualize your data with Power BI.

This book starts with configuration of SharePoint and Office 365 followed by your first example of PowerApps. You will lay the foundation for a help ticket application and see how to update a SharePoint list with PowerApps. You then will work with the jQuery open source library and learn how to use the developer tools within your browser. This allows you to customize data displays in SharePoint. 

Next, you will add jQuery UI widgets such as buttons and dialogs to SharePoint, learning how to configure and manipulate them via JavaScript. You will use these new skills to convert a normal SharePoint announcement into a visually compelling page of network alerts. You also will use JavaScript and styles to hugely improve native SharePoint calendars by color-coding them by category or location. To prevent overlapping events in calendars, you will work with SharePoint's web services and JavaScript. You will use similar concepts to make appealing accordion SharePoint pages. 

You then will explore Microsoft Forms, Flow, and Power BI, including building surveys in both Forms and SharePoint and using Power BI to show results over the last week, month, quarter, and year. Using advanced Power BI you will see how to deal with JSON, XML, and Yes/No data. Next, you will look at how to display Office documents as well as interact with them via JavaScript. 

Switching back to PowerApps, you will build the final help ticketing system before using Power BI to see how to visualize the ticket information. After a quick detour on using iFrames in SharePoint, you will jump into building a power routing application using InfoPath and SharePoint Designer. You will even call SharePoint’s web services from Designer to customize email notifications. You end the InfoPath set of chapters with a highly useful application for signing up for and managing attendance for training and other classes. Finally, you will add Google Analytics to track SharePoint usage.

You will:

  • Build powerful applications with PowerApps
  • Extend SharePoint’s capabilities using JavaScript 
  • Create surveys with SharePoint and Microsoft Forms, copy the results to SharePoint using Flow, and visualize the data with Power BI
  • Employ advanced Power BI techniques to include custom columns, pivoting, and dealing with JSON, XML, and Yes/No data
  • Use InfoPath and SharePoint workflows to create routing systems, schedule classes, and other advanced tasks


Sharepoint Microsoft Flow Office 365 Power BI JavaScript Microsoft Forms jQuery

Authors and affiliations

  1. 1.ColoradoUSA

About the authors

Jeffrey Rhodes is the Academic Chief Technical Officer at the United States Air Force Academy. Prior to that, he was Senior IT Specialist in charge of SharePoint, Remedy, and other key systems at the Academy. Jeff was the 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 Programming for e-Learning Developers: ToolBook, Flash, JavaScript, and Silverlight, VBTrain.Net: Creating Computer and Web Based Training with Visual Basic .NET and The ToolBook Companion. He lives in Colorado Springs with his wife Sue and is the proud father of his sons Derek and Michael.

Bibliographic information

Industry Sectors
Chemical Manufacturing
IT & Software
Consumer Packaged Goods
Finance, Business & Banking
Energy, Utilities & Environment