cancel
Showing results for 
Search instead for 
Did you mean: 
frederikbisback

From Forms to PowerBI and the glue is Microsoft Flow

Intro

In the coming days I have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putting hands in the air is old school … No?

 

How-To? Creating a Microsoft Forms – Survey about Microsoft PowerShell (as an example)

So, let’s start to create a Forms in Office 365. It’s easy to create one.

More information about Microsoft Forms, can be found here:
https://support.office.com/en-us/forms?omkt=en-001

flow03-01.png

Now we will create a Flow that will be triggered when a Forms response has been submitted. The Flow will collect the information and will display the results live in Power BI.

How do we do this?

Step by Step, I will carefully explain what you need to do, so that you can build your own and blow away your boss. First we will open a blank MS Flow and add a trigger for Microsoft Forms. Search for Microsoft Forms and click icon as shown below in picture.

flow03-02.png

Select the trigger [When a new respond is submitted]

flow03-03.png

Select the Forms that you have just created, in this example we us the “Microsoft PowerShell”- Forms.

flow03-04.png

We can also rename the trigger to a more suitable name, using the three dots.

flow03-05

Select and click [Rename]

flow03-06.png

Add your next step in the Flow.

flow03-07.png 

Search for [Apply to each], this means that when multiple response are send at the same time we can collect the information of these responses.

flow03-08.png 

Select [Apply to each]

flow03-12.png

Dynamic content will be pop-up after selecting Apply to each, this will refer to previous steps into your MS Flow. In this example the dynamic content will reflect towards the “PowerShell Survey”. Select the option [List of response notifications]

 

In the next step we need to collect the information from the list. Click [Add an action]

flow03-10.png

Search for an action for Microsoft Forms

 flow03-11.png 

We need the details of the responses, so select [Get response details]

flow03-12.png 

Select for the following fields:

  • Form Id: The id of the Form (Example: Microsoft PowerShell)
  • Response Id: Get the Response Id in the dynamic content list of the PowerShell Survey.

flow03-13.png

Next step we will put the data in a data set of Power BI. Click [Add an action]. Search for data set and select [Add rows to a dataset]

flow03-14.png

But first before we continue we need to create a streaming data set in Power BI.

flow03-15.png

Click [Skip]

flow03-16.png 

Select [Streaming dataset]

flow03-17.png 

Select [API] and click [Next]. Give a name to the new data set and enter the questions from the PowerShell Survey.

flow03-18.png 

Click [Create]

flow03-19.png

Click [Done]. Check the data set in data sets

flow03-20.png 

Now we can proceed with the Flow and add the new created data set. Select the work space where the data set has been created and select the data set name. Select [RealTimeData] for the table.

flow03-22.png 

In the next step we will send a survey reply to the person, that has filled in the survey. Click [Add an action]
flow03-23.png Save the Flow.
When we go back to Power BI, that will display the necessary results.
flow03-24.png
This can be done by creating a report based on the created data set in Power BI.

flow03-25.png

Hope you enjoying creating Forms and Power BI reports.

Comments
About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/