Forum Discussion
Emmadukew
Sep 23, 2021Copper Contributor
Merge sets of forms responses.
I've got a form that I've copied so have a number of instances for it (using it with different departments). I'd like to use the output with each department but also in a single file. While I've be...
Emmadukew
Sep 23, 2021Copper Contributor
Would I then be able to generate separate reports / department, or would i have to do the same as did for the overall one, only in this case, download & divvy up the spreadsheet, rather than merging multiple ones.
RobElliott
Sep 23, 2021Silver Contributor
Emmadukew well you would only have the one form and one spreadsheet so so it could easily be filtered by department. I have to say that we rarely work with the spreadsheet behind the form but use a flow in Power Auotmate to save each response either to a row in a separate spreadsheet or, more usually, the flow saves each response to a SharePoint list. Fro there we can filter, export etc.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)