Pass multiple Excel cell values to Power Automate

Question

I'm transferring an Excel cell value from SharePoint to Power Automate using Office Scripts. I can figure out how to send the values of several cells, but it only seems to work for one cell. This is my most recent Office Script, which retrieves the value from cell B3. When I use Power Automate to call this, I can access the B3 value by referring to the "result" dynamic content from the Run Script action.

Additionally, I must provide Power Automate with the values from cells B4, B5, B11, B12, and B44. How can I go about doing that?

Answer 1

If you have certain data that you wish to return, such as the customer name, you can create an object with properties for each of those values. The values would then be returned to Power Automate as that object. The script would appear as follows:

function main(workbook: ExcelScript.Workbook): SelectedValuesToReturn {
    // Get the current worksheet.
    let selectedSheet = workbook.getWorksheet("Sheet1");
    //values of range
    let customerNameValue= selectedSheet.getRange("B3").getValue().toString();
    let b4Value = selectedSheet.getRange("B4").getValue().toString();
    let b5Value = selectedSheet.getRange("B5").getValue().toString();
    let b11Value = selectedSheet.getRange("B11").getValue().toString();
    let b12Value = selectedSheet.getRange("B12").getValue().toString();
    let b44Value = selectedSheet.getRange("B44").getValue().toString();
    return {customerName: customerNameValue, b4: b4Value, b5: b5Value, b11: b11Value, b12: b12Value, b44: b44Value}
  }
}

interface SelectedValuesToReturn{
  customerName: string,
  b4: string, 
  b5: string,
  b11: string, 
  b12: string,
  b44: string
}