Forum Discussion

Pelikano's avatar
Pelikano
Copper Contributor
Oct 21, 2021

How to insert bulk response into forms excel

I have a form active in my organization whose results are dynamically tracked in an Excel. Now I have an Excel of a department with results that I want to add so that the 500+ employees don't have to fill in the form. But when I add the results lines in the Excel, the report of the form does not see them. How can I include these results in the Excel so that they count against the report?

excel
microsoft forms

2 Replies

Sort By
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Oct 23, 2021

    Pelikano you can't as far as I am aware, you'll need to export the responses in Forms, merge them with the the 500+ other items and then do reporting in Excel or Power Bi.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • Pelikano's avatar
      Pelikano
      Copper Contributor
      Oct 27, 2021

      Hi RobElliott thank you for your reply. I hoped there was a possibility to refresh the report.

Resources