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!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
89 | |
57 | |
40 | |
39 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
52 | |
42 |