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
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?
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
10 |
User | Count |
---|---|
45 | |
29 | |
27 | |
23 | |
23 |