I am building a flow where I need to refresh a spreadsheet daily and populate it with the latest data from the source (Planner, for context).
Here is the flow I have set up:
- List rows present in a table.
- Apply to each: Delete each row in the table.
- Once all rows are deleted, I populate the Excel sheet with new data.
However, the rows are not being deleted consistently. To handle this, I initialized a variable to check if the table is empty. If it's not empty, the flow continues to delete rows until it is.
Despite trying various conditions and configurations, the flow never works as expected. There was a time when it worked, but it has stopped functioning correctly for weeks now.
Here is the structure of my flow:
- Initialize a variable to check if the table is empty.
- List rows present in a table.
- Apply to each: [value from the table]
- Do until:
- List rows present in a table.
- Condition: If the body is null, set `IsTableEmpty` to true; otherwise, set it to false.
I would appreciate any insights or suggestions on how to ensure the rows are deleted before the flow proceeds to the next step. Thank you!
1. Set A variable to check if Table is empty
2. List row present in a table
3. Apply to each [value from the table]
4. Do until
1. List rows present in a table 2. Condition [if body is null, set IsTableEmpty to true otherwise, false]
|
|


Report
All responses (
Answers (