Forum Discussion
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...
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.
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)