Abstract
An exciting new feature of Office 365 is Microsoft Forms. While not yet as powerful as InfoPath, Forms makes it very easy to create forms and surveys. In this example, we will create a survey for our help desk in Forms (similar to what we did with a built-in SharePoint survey in the last chapter). Since we can’t currently use Forms as a data source for Power BI, we will use Flow to copy each survey response to a SharePoint list. We then use this SharePoint list as our Power BI data source.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
The availability of Microsoft Forms may depend on your Office 365 version. When I first created this chapter, Forms was not available in my personal version of Office 365 Professional but was part of our Office 365 Education at the Air Force Academy. When I checked back later, it had been added to Office 365 Professional as well.
- 2.
This has the added benefit of keeping a permanent record of the response. If someone deleted a survey response, the record of the response is still in SharePoint.
- 3.
Be sure to use Multiple lines of text if more than 255 characters are possible, such as for a multiple response question like those shown in the next chapter.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jeffrey M. Rhodes
About this chapter
Cite this chapter
Rhodes, J.M. (2019). Creating a Survey Solution with Microsoft Forms, Flow, SharePoint, and Power BI. In: Creating Business Applications with Office 365. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5331-1_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5331-1_11
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5330-4
Online ISBN: 978-1-4842-5331-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)