Power Platform Community Forum Thread Details

I am trying to create an automated spreadsheet that adds formulas to columns when I add a file to a folder.

so for the steps are as follows

convert worksheet to a table - this works

I am then running the following Excel script which fails with error

We were unable to run the script. Please try again.
Office JS error: Line 6: Range setFormulaLocal: The argument is invalid or missing or has an incorrect format.
clientRequestId: 1d113969-0826-4412-8af7-41f3b02f7ce2

Script

function main(workbook: ExcelScript.Workbook) {

let selectedSheet = workbook.getWorksheet("Page 1");

// Set range W1 on selectedSheet

selectedSheet.getRange("W1").setValue("Validate");

// Paste string at cell range W2 on selectedSheet

selectedSheet.getRange("W2").setFormulaLocal("=SUMPRODUCT(([@[Engineer In Date & Time By Agent]]<FILTER([Engineer Out Date &Time By Agent],[Engineer Name]=[@[Engineer Name]]))*([@[Engineer Out Date &Time By Agent]]>FILTER([Engineer In Date & Time By Agent],[Engineer Name]=[@[Engineer Name]])))>1");

}

the script works fine when I run it in excel online, but I am unable to get it to work inside Power Automate

Categories:

Building flows