You’re offline. This is a read only version of the page.
Announcements
Hi All!
So I’m facing strange issue, I have prepared Office Scripts for Excel and when I run them directly in Excel everything works but as son as I want to run them via Power Automate I'm getting errors.
Issue 1
This works fine:
Share
Reportworkbook.getWorksheet("Sheet1").setName("SampleName");
This doesn't work:
let SampleVariable = "SampleName";
workbook.getWorksheet("Sheet1").setName(SampleVariable);
and return error:
Błąd skryptu Office JS: Line 35: {"message":"The argument is invalid or missing or has an incorrect format.","code":"InvalidArgument","type":"Worksheet","method":"setName","line":34}
As mentioned when running scripts directly in Excel both methods works just fine.
Issue 2
This code works fine when run in Excel but doesn't work in Power Automate:
let selectedSheet = workbook.getWorksheet("SampleName");
let SampleRng = selectedSheet.getUsedRange();
and return error:
Błąd czasu wykonywania: Line 59: Cannot read properties of undefined (reading 'getUsedRange')
Anyone have a workaround?
Hi @krzycho - sorry to hear you're running into this issue! I tried running the code snippets you shared through Power Automate and they worked fine for me. To help us troubleshoot better, would you be able to share (1) your entire script, and (2) your flow configuration, with sensitive data removed as needed?
All responses (
Answers (
501
