I currently have a flow in mind that i intend to automate but i am stuck and im not sure if this is a limitation of power automate or not.
Trigger: When a new response is submitted on microsoft forms
What I hope for the flow to achieve: 1) Append forms results onto an excel template on sharepoint
2) Save the excel template as a new file on sharepoint so the new file contains the results for one form entry only
1) I am unable to add rows to a file on sharepoint, and only can do so on the excel file on my desktop. so my progress is currently stuck at the initial stage. 2) I cant just import the table onto sharepoint as the excel template i have contains some layout (somewhat like an order form) that i want to retain