Import multiple Microsoft Forms to Power BI

[Anonymous]

Hello everyone,

I need some help to a problem. Every week i have a meeting with different subjects, at the end of every meeting i have to send a Microsoft Forms with different questions for the week subject. Is there any way to automate the process creating a folder in SharePoint and throwing the forms file every week, to analyze the data in PowerBI?

I thought about transposing the questions to line, so i can have a table like this:

+-----------------------+----+--------+---------+------------------+------------------+------------+----------+
| Form Name (file name) | ID |  Name  |  Email  |  Starting Time   |     End Time     |  Question  |  Answer  |
+-----------------------+----+--------+---------+------------------+------------------+------------+----------+
| Form 1                |  1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 1 | Answer 1 |
| Form 1                |  1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 2 | Answer 1 |
| Form 1                |  2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 1 | Answer 1 |
| Form 1                |  2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 2 | Answer 2 |
| Form 2                |  1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 3 | Answer 3 |
| Form 2                |  1 | Name 1 | Email 1 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 4 | Answer 4 |
| Form 2                |  2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 3 | Answer 3 |
| Form 2                |  2 | Name 2 | Email 2 | 4/27/22 15:24:10 | 4/27/22 15:24:10 | Question 4 | Answer 4 |
+-----------------------+----+--------+---------+------------------+------------------+------------+----------+

But i don't know if this is possible, can someone help me?

[bcdobbs]

Forma stores it's results in an excel file either in your one drive or if you associate with a team it stores it in associated sharepoint. If you go to view response and open the excel file it will show where it is stored.

You can connect direct to it from power bi.

If you do want to copy it have a look at Power Automate.

[Anonymous]

But i have one different forms per week, my problem is to deal with different answers and forms every week.

[bcdobbs · Accepted solution]

Sorry had missed that slightly. I think if careful you can make it work.

1) Find out where it's saving to.

2) Name forms with consistent start (will need it later)

3) Use files from sharepoint folder.

4) Combine but then transform and do an unpivot.

I'll try and mock something up and give better instructions later but principal should work.

[Anonymous]

I'll try to make something starting from your instructions. But i'll be very pleased if you can send me better instructions.