Unanswered

Flow not working - Running a Excel Script in a OneDrive folder

(0) Share

Report

Posted on by PJ-23071512-0

Hi All,

I setup a flow where "For a Selected File" for "OneDrive Business" - I can "Run Script" for "Excel". Even though the status of the flow shows "Succeeded" when I run the automate in the OneDrive file; the script is not working as expected. What could I be missing here?

PS - The script works properly when I run it in Excel; thus - no issues with the Script.

All responses (2)

Answers (0)

PJ-23071512-0 2 on at

Like (0)

Report

Re: Flow not working - Running a Excel Script in a OneDrive folder

Adding more clarity:
1) Here's the flow I'm going for:
2) Once I select the file in OneDrive; I am able to select the flow I want to use:
3) The job of the excel script is to just move the rows to the right (Note that the script works properly when applied to a sheet directly):

function main(workbook: ExcelScript.Workbook) {
  // Get collection of worksheets in the workbook
  let worksheets = workbook.getWorksheets();

  // Loop through each worksheet and insert a column after column A
  worksheets.forEach(sheet => {
    let columnA = sheet.getRange("A1");
    columnA.getEntireColumn().insert(ExcelScript.InsertShiftDirection.right);
  });
}

4) Aim is to auto-save the sheet in OneDrive after the macro is applied. I'm nore if any flow step is required for it and thus, not added it

5) Once i select the OneDrive sheet and run the flow - I see it as succeeded in my "Run History":

However - I don't see the changes in my OneDrive sheet.

Am I missing something here?

PS - Hope this information can allow you to help me solve this. Happy to share more details!

Appreciate the help!
Michael E. Gernaey 43,285 Super User 2025 Season 1 on at

Like (0)

Report

Re: Flow not working - Running a Excel Script in a OneDrive folder

@Nemesis_M6

We cannot really do anything with the description you gave. "is not working as expected" doesn't tell us anything.

Pictures, Errors, what the script should does compared to what did it do, these details would help us.