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

All responses (5)

Answers (0)

ggrocott 15 on at

Like (1)

Report

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

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
v-zhos-msft on at

Like (0)

Report

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

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.
efialttes 14,756 on at

Like (1)

Report

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

@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
ggrocott 15 on at

Like (0)

Report

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

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 14,756 on at

Like (0)

Report

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

@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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates