Flow to get a rows in Excel and copy to another Excel

[ggrocott]

Hello,

I have this scenario and using a template flow (create a row in another spreadsheet, for a selected row).

I have two people updating their own spreadsheet and adding a new row each time they do an audit for a shop. The spreadsheet is stored on their One Drive. I want to merge the data in to a Master Spreadsheet stored in Teams, so that both guys can do some analysis on the combined data.

Everytime they update a new row, this flow never gets triggered and I can't seem to run a test trigger. 

Any suggestions?

Thanks

[efialttes]

@ggrocott 

Are you using this template?

Please note everytime they add new a row they need to explicitly select the added row and trigger the flow manually.

As far as I know, there are not triggers available for the Excel connector.

Hope this helps

[ggrocott]

So I tried this manually. I added on the Flow in to Excel and now have the button. When I click on a row as it explains, then click Flow. All it does is launch flow and i see the flows i have created. It doesnt then move the row to the Master spreadsheet.

[efialttes]

@ggrocott 

Have you inspected the results of the flow execution in "Run history"?

So, you click on "My Flows", select your Flow, and verify if it executed recently

If so, you can open it and verify step by step the partial execution results

Hope this helps

[v-zhos-msft]

Hi @ggrocott ,

As your said, you have use the  template flow (create a row in another spreadsheet for a selected row).

So you need trigger the flow in the excel file.

Please take a reference of 'Build and run flows from Excel':

https://docs.microsoft.com/en-us/business-applications-release-notes/april18/microsoft-flow/build-ru...

https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/

Hope it will help you.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ggrocott]

Just got round to testing again and now get this.

"To create a flow, save your spreadsheet on SharePoint or OneDrive for Business."

So even though the spreadsheet that I am building the Flow and initiating it is in OneDrive for Business, it still displays the error and not the new flow i created. All Very odd