Power Platform Community Forum Thread Details

Hi I'm reading excel range data from an excel file with an Office Script:

function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getWorksheet("Test AM");
let range = sheet.getRange("A1:A7");
let returnData = range.getValues();
return returnData;
};
This is returning the values to my flow.

I want to write this data to a destination excel file, using the same flow, but I'm not sure how to write the data-writing office script.

I'm trying to include a data array, but it isn't working and intellisense is showing errors:

function main(workbook: ExcelScript.Workbook, data[]) {

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

let range = sheet.getRange("A1:A7");

range.setValues(data);

};

Categories:

Building flows

Community site session details

Write multiple excel cell values in a range with Office Script, using data from Power Automate

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates