Use Power Automate to run a script

[Anonymous]

I have created a script in excel on-line to format a table and other minor configurations and when i run it works perfectly.

But

When i create a simple flow to run the script it fails every time 😞

The Excel workbook has 5 worksheet and i am only interested in one for this process

Script Name "CreateTableFourmat" below ..... the name of the sheet i need is "Open Incident Details"

function main(workbook: ExcelScript.Workbook) {

  let selectedSheet = workbook.getWorksheet("Open Incident Details");

  // Delete range 1:1 on open_Incident_Details

  selectedSheet.getRange("1:1").delete(ExcelScript.DeleteShiftDirection.up);

  // Create a table with format on range A1:AF9 on open_Incident_Details

  let table1 = workbook.addTable(selectedSheet.getRange("A1:AF9"), true);

  table1.setPredefinedTableStyle("TableStyleMedium2");

  // Rename table table1 to "TbIncident"

  table1.setName("TbIncident");

  // Set height of row(s) at range 2:9 on open_Incident_Details to 15

  selectedSheet.getRange("2:9").getFormat().setRowHeight(15);

===================================================

Error Details



Start time

Jun 28, 01:48 PM (

2 minutes ago2 min ago

)

Jun 28, 01:48 PM

Duration

00:00:04

Error

Action 'Run_script' failed

Error Details

We were unable to run the script. Please try again.
Workbook not found.
clientRequestId: 8d00f48b-50d9-4511-9987-b64d7ca1c54f

Documentation

Learn more about Excel Online (Business)/connectors/excelonlinebusiness/

Learn more about Excel Online (Business)

How to fix

To make this flow work, inspect the inputs to this action and ensure they would find the right resource.