I am trying to configure a flow from Microsoft Forms to Power BI. I have this working ok, but when I add branching questions in Forms, I start receiving errors.
To explain further:
I essentially have a microsoft form containing a question with 3 options, A, B and C. If the user selects A, the branching rules open all the subsequent A questions, then hides all the subsequent B and C questions. Simialrly if B or C is selected.
I have a mixture of seperate Text and Numerical answers, however the flow always fails when one of the subsequent B questions is set as a 'Number' response in Power BI's dataset (see image below) and also one of the subsequent C questions set as a 'Number' response.
(Note there are no 'Number' format questions in the subsequent A questions. I also have the Historical Data Analysis setting 'on' as I require allot of answers to be stored for review)
A sample error is shown below:
Hi @SimpoFlow,
Could you please share your flow configuration about put the data into the Power BI dataset?
I noticed that the data from MS Form is the string, and you want to put it into the column Project Status which Type is Number. maybe you can the previous step convert the data of MS form into integer, then put it again.
There is the reference of int() function:
Please have a try, I hope it can help you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.