Hi @Valerio,
Do you want to overwrite the data within a Excel table using Microsoft Flow?
How do you insert data into the existing Excel table?
Overwriting the data within the Excel table is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
In addition, you could consider take a try to delete all data within the Excel table firstly, then insert new data into the existing Excel table. I have made a test on my side and please take a try with the following workaround:
My Original Data within my existing Excel table as below:
Please take a try with the following workaround:
- Add a proper trigger, here I use Flow Button trigger.
- Add a "Get rows" action, specify File Name and Table Name.
- Add a "Apply to each", input parameter set to output of "Get rows" action.
- Within "Apply to each" action, add a "Delete row" action, specify File Name and Table Name. Row id field set to Row id dynamic content of "Get rows" action.
- Under "Apply to each", add a "Get items" action, specify Site Address and List Name.
- Add a "Apply to each 2", input parameter set to output of "Get items" action.
- Within "Apply to each 2" action, add a "Insert row" action, specify File Name and Table Name.
Image reference:
The flow works successfully as below:
Best regards,
Kris
