web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Scheduled Flow for del...

Power Automate

Suggested Answer

Scheduled Flow for deleting contents in table

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!
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

Join the conversation