I have created a Microsoft Form that has many questions with multiple choice. I have created a Flow to connect Form to Power BI. But My multiple choice responses are as one response, but I want them as separate responses within Power BI.
Hi @DaleD ,
Please refer to screenshot below to create the flow:
The schema in the Parse JSON as below:
{
"type": "array",
"items": {
"type": "string"
}
}
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have modified my flow according to your suggestion, but still get undesired results:
Here is my new flow:
Here are the results:
Hi @JudithL I have not resolved this. I have watched many videos and have asked this same question in different ways trying to get this resolved. This would be very powerful.
@DaleD Ok thanks for the update Dale! I'll keep trying too and let you know if I get anywhere 🙂
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
37 | |
34 | |
33 | |
30 |
User | Count |
---|---|
46 | |
36 | |
33 | |
25 | |
24 |