Power Platform Community Forum Thread Details

Hi I am trying to return some data from an Excel file to my Power Flow, and for some reason it isn't returning data to my flow.

Office Script:

function main(workbook: ExcelScript.Workbook) {

let sheet = workbook.getWorksheet("Sheet1");

let range = sheet.getRange("A4");

let returnData = range.getValue();

return returnData;

};

The value in cell A4 is the word 'because'.

The value returned to my flow is:

{

"result": [

[

]

"logs": []

}

I'm stuck, can anyone help?

Categories:

Get excel cell values with Office Script, and return to Power Automate