Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Add rows to Sharepoint excel file

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

Advocate III
Advocate III

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:

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?



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,929)