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
Solved! Go to 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:
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
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:
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
User | Count |
---|---|
78 | |
55 | |
52 | |
42 | |
42 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |