Creating a Survey Solution with Microsoft Forms, Flow, SharePoint, and Power BI
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.