I'm trying to run a simple script via powerautomate to delete rows in a table however it just times out. Strangely it did work once (I haven't changed anything). The number of rows to delete is about 700.
Error: We were unable to run the script. Please try again.
Office JS error: Line 4: Table deleteRowsAt: The request is aborted.
Here's the script:
function main(workbook: ExcelScript.Workbook) {
let myTable = workbook.getTable("All_Months");
let rowCount = myTable.getRowCount();
myTable.deleteRowsAt(0, rowCount);
}
Any help much appreciated!!