in short:
Look at this Blog post here as a starting point:
- https://powerautomate.microsoft.com/en-us/blog/building-scratch-forms-responses/
For each response item there is here an example to add rows in an Excel workbook instead of SharePoint: - https://learn.microsoft.com/en-us/power-automate/forms/popular-scenarios#add-form-responses-to-an-excel-worksheet
or take the shortcut and use this Power Automate template flow:
https://emea.flow.microsoft.com/en-us/galleries/public/templates/2be590104bdd11e78896d10a96d3fac3/record-form-responses-in-sharepoint/
long:
You might start with noting down your requirements first in order to figure out if the way you try to tackle it down will be fine mid-term.
Just some thoughts:
- anonymous / internet access required for FORMS replies
- Forms questionnaire ownership
- Power Automate Flow ownership
- attachment upload function optional required
- user lookup
- input validation
- any kind of notification / acknowledgement back to the responder needed
- aso
depending on a few of the above answers Forms might not be a sufficient fit for your demand.