question

Spot on !!!
I have added delay in the power automate and the issue got resolved.

Can you guide on how to send power automate collection (two columns) to Excel using script and create a chart?

Thank You

Firstly, you will need to add a parameter to the main function to accept the incoming data in JSON format:

function main(workbook: ExcelScript.Workbook, data: string): string {
  let selectedSheet = workbook.getWorksheet("Sheet1");
  let items: Item[] = JSON.parse(data);
  let values = items.map(item => [item.Operations, item.Score]);
  values.unshift(["Operations", "Score"]);
  let newRange = selectedSheet.getRange("A1").getResizedRange(values.length - 1, 1);
  newRange.setValues(values);
  //get the current used range and lastRow
  let myUsedRange = selectedSheet.getUsedRange();
  let lastRow = myUsedRange.getAddress();
  let radarchart = selectedSheet.addChart(ExcelScript.ChartType.radarFilled, selectedSheet.getRange(lastRow));
  radarchart.getSeriesNameLevel[0]
  radarchart.getTitle().setText('Score by Section');
  radarchart.getAxes().getValueAxis().getFormat().getFont().setSize(1);
  radarchart.getDataLabels().setShowValue(true);
  let radarchartimage = radarchart.getImage();
  radarchart.delete();
  return radarchartimage;
}

interface Item {
  Operations: string;
  Score: string;
}

The code is mostly based on the code snippet you shared but with a few changes:

• I added a few lines to parse the input string into a two-dimensional string array then insert into the worksheet.
  

• I slightly adjusted a few lines in the chart generation code to make sure it returns the chart image with the updated chart formatting.
  

• I saw you returned [radarchartimage] in your original code. This is returning an array with a single item. Should it just return radarchartimage, which contains the base64-encoded image?

  
  

Then on the Power Automate side, you'll need to pass along the input JSON data from the PowerApps trigger into the Run script action. You may need to delete the existing Run script action and insert again to make sure it shows up the data input box.

Thank You
Is there any reference material for excel script?

Thanks