Flow connecting Online Excels

[Sanket_sk]

Hi All,

I am working on One drive for business using online Excel sheets. There are 20+ online excels with fixed columns, peoples updating these excels with 100+ rows on daily basis.

I have given them name like - Mumbai, Pune, Nagpur and so on.

Also i have created sheet called Maharashtra. 

On daily basis i am coping data from these different sheets ( Mumbai, Pune ...) and pasting in sheet Maharashtra , all these sheets are available on one drive in same folder.

I want to automate this function ...

Whenever any sheet is getting updated flow should copy data from these 20 sheets and paste in Maharashtra sheet.

Is it possible ?

If yes please guide with steps.

Sanket 7738414678

[v-yamao-msft · Accepted solution]

Hi @Sanket_sk ,

Do you want to get sheet Maharashtra updated when data from different sheets updated?

Flow doesn’t have On create/On updated/On deleted triggers for Excel online triggers. There is a similar request at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Triggers-for-Excel-Sheets/idi-p/78301?advanced=false&...

Please feel free vote the above idea, PGs will take hot ideas into consideration first.

For your scenario, I am afraid that you may need to use a Recurrence trigger on daily basis, then update all rows from one excel to another.

Best regards,

Mabel