How to insert bulk response into forms excel

Copper Contributor

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?

2 Replies

@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)

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