Add rows to Sharepoint excel file

[GreenThrumbo]

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

current problems:

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

[beebul]

This Flow works for me saving the new submission as an item in an Excel that lives in a SharePoint doc library...

It's just based on this template: https://australia.flow.microsoft.com/en-us/galleries/public/templates/a8fe18d6de56498686db35d5cbde5a...

Bare in mind your Excel must have a table defined in the worksheet for this to work.

I think we need a little more info on your second problem. Screenshot?