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 ๐
User | Count |
---|---|
78 | |
55 | |
52 | |
42 | |
42 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |