From Forms to PowerBI and the glue is Microsoft Flow
frederikbisback
222
Share
ReportIntro
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 |
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.
Select the trigger [When a new respond is submitted]
Select the Forms that you have just created, in this example we us the “Microsoft PowerShell”- Forms.
We can also rename the trigger to a more suitable name, using the three dots.
Select and click [Rename]
Add your next step in the Flow.
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.
Select [Apply to each]
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]
Search for an action for Microsoft Forms
We need the details of the responses, so select [Get response details]
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.
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]
But first before we continue we need to create a streaming data set in Power BI.
Click [Skip]
Select [Streaming dataset]
Select [API] and click [Next]. Give a name to the new data set and enter the questions from the PowerShell Survey.
Click [Create]
Click [Done]. Check the data set in data sets
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.
In the next step we will send a survey reply to the person, that has filled in the survey. Click [Add an action] Save the Flow.
When we go back to Power BI, that will display the necessary results.
This can be done by creating a report based on the created data set in Power BI.
Hope you enjoying creating Forms and Power BI reports.
Comments
-
-
From Forms to PowerBI and the glue is Microsoft Flow
This is absolutely brilliant. However, I have followed it step by step and I keep getting the following error:
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/resourceData/responseId']' is of type 'Integer'. The result must be a valid array.I cant for the life of me work out how to change this?
-
-
From Forms to PowerBI and the glue is Microsoft Flow
@mcguija
Instead of clicking 'Get data' in the bottom left corner, go to your target workspace and click 'Create. This will call the dropdown where you have the option to select a Streaming dataset.Once your streaming dataset is created, view your list of datasets and click to edit the streaming dataset you have created. If you scroll to the bottom of the window, there is an option to turn on Historic Data Analysis which I believe pulls through Forms responses prior to the Power BI link you are creating. Your dataset then becomes a Hybrid dataset.
I saw the same the first time I tried to follow the instructions. I loaded all of my dynamic content labels into the field and proceeded as per the instructions. At first run, my flow failed, when I went to edit my flow, the fields were then visible and I reorganised as per the instructions above.
NOTE: The next time I came to follow this process, I saw the payload field momentarily, but before I could do anything it was replaced with my designated fields. Don't know what the difference was this time.Please give Kudos if useful.
-
-
From Forms to PowerBI and the glue is Microsoft Flow
-
From Forms to PowerBI and the glue is Microsoft Flow
Hi,
I'm trying to follow this, i hope its still valid.
One step where you "Get Data" and you say to "skip" the skip but does not exist on my screen. Can you advise?
-
From Forms to PowerBI and the glue is Microsoft Flow
Hello,
Thanks for the great article. I have a question related to streaming dataset.
I read on another website that data is not saved for more than a few hours meaning I can't save the feedbacks on MS Forms for longer?
Also, I can't modify the streaming data set for example I need to change the format of the time zone. This is only possible in MS Flow. Is there any way to link streaming Dataset to just normal data set?
Thanks so much
Ahmed
*This post is locked for comments