Unanswered

Scheduled Flow for deleting contents in table

(0) Share

Report

Posted on by dazler5540

Hello Community,

I want to learn how to delete the contents of a given table in excel in OneDrive using Power Automate Scheduled Flow. It must be triggered at a designated day and time. Please help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-xiaochen-msft on at

Like (1)

Report

Hi @dazler5540 ,

I made a sample for you.

Please make sure that Excel table has a primary column (In my screenshots, it's Col1.) because Power Automate doesn’t allow you to remove empty rows from an Excel file. The ‘Delete a row’ action needs an identifier of the specific row, and it can’t be empty.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Suggested answer

CU17101209-0 2 on at

Like (0)

Report
Just recently ran into this problem myself, and I don't like using the list all rows, delete row combination since it deletes rows one at a time and that can be super slow for tables of more than 100 rows.

The approach I used was using an Office Script. The script body is:

function main(workbook: ExcelScript.Workbook, tableName: string): string{ const tbl = workbook.getTable(tableName); if (!tbl){ let tbls = workbook.getTables(); let names = tbls.map(tbl => tbl.getName()).join(', '); return `[ERROR] No table found ${tableName}. Found tables:\n[${names}]`; } try { // This could be made more complicated for really large tables > 1 million rows to avoid timeout errors tbl.getRangeBetweenHeaderAndTotal().delete(ExcelScript.DeleteShiftDirection.up); return "Success" } catch(e){ return `[ERROR] Unable to delete table range. Received error:\n${e}`; } }

Then you simply make a power automate flow, using the "Run Script" action

In the above example I'm using a manual trigger, but that could super easily be changed to a scheduled trigger.

Was this reply helpful? Yes No