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 ๐
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
80 | |
55 | |
55 | |
43 | |
40 |
User | Count |
---|---|
83 | |
81 | |
76 | |
65 | |
42 |