MS Forms results in Sharepoint website

Question

MS Forms results in Sharepoint website

Anonymous

Hi,

Can I embed results from MS Forms survey in Sharepoint website? I know I can display summary of responses but I want to embed live detailed results which normally I can download in Excel. I want my team to have access to these results but don't want to give them full permission to the Forms itself so that they do not accidently mess with it.

I tried Power Automate but had no luck with this.

thanks,

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

3 additional answers

Answer 1

Hi Ewa,

Thank you for querying in this forum.

According to your description, you want to embed the forms result as a live result on a SharePoint website. The forms result is that you can download from Excel via form Responses tab>click "Open in Excel".

May I know if my understanding of the scenario is consistent with yours?

If yes, I have tested to embed a form's response related Excel workbook in SharePoint site page from my side. I can see the workbook with live result by refreshing the SharePoint page.

When the users in your organization access the SharePoint site page, they need to refresh the page to get the forms result updated.

Here are the detailed steps. If you are willing, you may have a try.

1.Firsly, to get live form result(dynamic result) in Excel workbook, you can create a form from Excel for the web app > create a new workbook > click Insert > Forms > click "+ New Form".

For reference: Create a form with Microsoft Forms - Excel for the web

2.The new Excel workbook is saved in your OneDrive for business, when you get response of the form, you can go to your OneDrive and look for your workbook.

When you find your workbook, select it and click Copy link to get sharing link.

Note: Per my test, only Anyone with the link this link type can be successfully embedded to SharePoint page. (You may try Anyone with the link can view)

Then you need to add &action=embedview&wdbipreview=true to the end of the sharing link.

3.Go to your SharePoint site, create a page and add Embed web part.

For reference: Add content to your page using the Embed web part (microsoft.com)

4.Put iframe code to the Website address or embed code box. Below is an example.

Note: If you meet the error message as below, you will need to Allow or restrict the ability to embed content on SharePoint pages, add your OneDrive for business URL:

yourtenant-my.sharepoint.com to the list of the sites that are allowed to embed on SharePoint pages.

5.Then publish the page. You will get the workbook embedded on the SharePoint page as below. Refresh the page will show updated result.

If above is not want you want or my understanding of the scenario is not consistent with yours, feel free to post back and let me know. I will continue trying best to help you.

Thanks for your patience and understanding. Hope you have a safe and happy new year!

Best regards,

Tina

Answer 2

Hi Ewa,

Thank you for posting back and sharing more detailed information about your requirement.

I understand you don't want to create a new form. You want to embed the existing form's results on SharePoint page and display dynamic result.

If your form was created from OneDrive for business or Excel for the web, then the related Excel workbook which has response will have dynamic response.

But if your form was created from Forms for the web app, the response in Excel workbook is not dynamic. It's expected behavior.

If the Excel workbook of the 'existing "live" Form' that you mentioned is saved in OneDrive for business and have dynamic result, then you may try to start from Step 2 of my initial reply and test again.

The method I shared in initial reply requires the workbook has dynamic result and the workbook needs to be saved in OneDrive, then when we embed the workbook to SharePoint page, it shows dynamic result. Very sorry that I didn't mention that in initial reply.

If your existing form was created from Forms for the web app, I'm afraid there is no build-in feature in SharePoint which can meet your requirement. Very sorry about it.

For workaround, you may try to use Microsoft power automate flow to copy the new response along with other response of the form and paste them to a SharePoint list, then embed the list as List web part to SharePoint page.

If you want to learn more about this method, considering we have a dedicated channel Microsoft Power Automate Community where engineers and members in that community are proficient in the knowledge of flow, I sincerely recommend you post a new question in that community, and they will also focus on your specific situation and provide specific suggestions.

Many thanks for your patience and understanding. Hope you are keeping safe and well.

Best regards,

Tina

Answer 3

Hi Tina,

thank you for answering my question. I can see that the way you went around it is much easier and I didn't know that it is possible to link Forms to Excel document in One Drive.

When I follow your steps, Excel seems to "create" separate form in MS Forms. What if I already have an existing "live" Form which I use in my organisation? I cannot see option which would enable me to use existing Forms in that Excel file. I wouldn't want really to recreate the Form once again, so I wanted to use the Excel file with the responses from MS Forms which I already have.

Many thanks,

Ewa

Answer 4

Anonymous

Hi Ewa,

Did you receive the reply? Feel free to share any update with us when you have time.

Hope you are keeping safe and well.

Best regards,

Tina

0 comments

Share via

MS Forms results in Sharepoint website

3 additional answers