Hi,
We do have a Logic App to export Planner tasks into an Excel file (into sharepoint). This works well.
But before running the next export, we must delete all rows in the current Excel file or we will have duplicates entry.
I don't want to delete and create another Excel file because Logic App will fail even if the file has the same name...
So i added few steps in the Logic App to list Excel Rows and delete all of them if the Title column is Not Equal To blank.
This works well for all rows except for duplicates rows.
Yes... there is duplicates rows because in Planner, you could have more than 1 user assigned to a task so it create 1 row per user and all the other columns are identical...
So the question is how to delete all rows in the Excel file without replacing the Excel file ?
Here is my logic app steps
List Excel rows

Loop into excel file to delete all rows



