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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

efialttes 14,756 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
ggrocott 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
v-zhos-msft on at

Like (0)

Report

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-run-flows-excel

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.

Was this reply helpful? Yes No
ggrocott 15 on at

Like (1)

Report

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

Was this reply helpful? Yes No