So I know there are tons of tutorials about how to delete all rows in excel in Power Automate. I have been trying to follow those tutorials to the best of my ability:
However in following these tutorials I realized that a logical contradiction (which my core question). Lets call the Table - Variable A. All the tutorials I have seen use "List rows present in Table", (Variable B) then you take the value from one of the rows . However, what if the values or rows are not unique ? What I found is in practice is when they are not unique the "apply for each" loop will hit an error where there are not rows in the table anymore (all deleted), but there are still rows in the list. In other words an error occurs because Variable A (the table) is empty, but list of values (Variable B) is not.
When this error occurs instead of then saving the changes, I have found at my workplace that sharepoint immediately then undoes the power automate deletion step. So in practice no row are deleted. Now while it make make sense to make a unique row column, if feel like long term this is goes against my organization best practices.
So is there a better way in excel to delete all rows in excel using power automate?
Thank you for taking the time in advance to answer my question,
mlane
Share
Report
All responses (
Answers (
245
