Power Platform Community Forum Thread Details

Hi,

I had a flow working perfectly, converting csv to xlsx but since last Thursday it stopped working.

The flow uses the following script (taken from Power GI youtube tutorial: https://www.youtube.com/watch?v=2TIolfmtWQM) that no longer works:

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

let selectedSheet = workbook.getActiveWorksheet();

const alllines = linecsv;

let counter = 1;

for (let line of alllines) {

if (line.includes(",")) {

let items = line.split(",");

// Set range A1:B2 on selectedSheet

selectedSheet.getRange("A" + counter + ":B" + counter).setValues([[items[0], items[1]]]);

counter++;

}

// Add a new table at range A1:B2 on selectedSheet

workbook.addTable(selectedSheet.getRange("A1:B" + counter), true).setName("hoja1");

}

It runs, but it does not return anything other than a table with no data. It seems part of this code does not work since latest microsoft change on Thursday, whtever it was.

Thank you,

Categories:

Using flows

Community site session details

Script to convert csv to xlsx stopped working

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