Combining the replies from two forms

Lara_Croft adding rows manually into the spreadsheet behind the form won't work and you can't fool Forms into looking at the entire spreadsheet. Also there is no counter that you can manually adjust.

But you can achieve what you want with a couple of simple flows in Power Automate, each of which will add a row into a table in the same spreadsheet in your One Drive (note: not the spreadsheet behind the form).

So first of all create your spreadsheet with a column for each question in the form. Format it as a table.

At its simplest the flow then just needs the "When a new response is submitted" trigger, followed by the first action which is "Get response details". Then finally you have an Excel action "Add a row into a table". When you select the file and the table the action will add the columns in from the spreadsheet and you select the relevant question from the dynamic content box on the right.

You do exactly the same for the second form, just selecting the different form for the trigger and the get response details action. Then whenever a form is submitted from either form it will add the response into the spreadsheet.

Rob
Los Gallardos
Microsoft Power Automate Community Super User