Power Platform Community Forum Thread Details

Hi everyone, I'd like to know if there's a possible solution to this. I keep getting the error

Table getColumnByName: Timeout

on the Apply Filter step of the steps I recorded below. This is a 28 col x 16k+ row table and I'm unsure if it's the data volume that is causing the timeout. If so, what's a possible workaround to avoid the timeout? I need to filter the table because I need only the rows flagged TRUE (or if possible, just remove the ones flagged FALSE).

Code in question:

function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	// Add a new table at range A:AB on selectedSheet
	let newTable = workbook.addTable(workbook.getActiveWorksheet().getRange("A1").getSurroundingRegion(), true);
	// Set range S2 on selectedSheet
	selectedSheet.getRange("S2").setFormulaLocal("=IF(COUNTIFS([Order No], [@[Order No]]) > 1, \"More than one\", \"only one\")");
	// Sort on table: newTable column index: '1'
	newTable.getSort().apply([{ key: 1, ascending: false }]);
	// Apply checked items filter on table newTable column Step
	newTable.getColumnByName("Step").getFilter().applyValuesFilter(["TRUE"]);
	
	...
}

Categories:

General topics