ERROR PAD "LaunchAndOpenUnderExistingProcess"

(0) Share

Report

Posted on by fgonzalez515

296

Hello Community,

When running a flow in Power Automate Cloud, with "Run a flow built with for Power Automate Desktop" it gives me the following error,

Problem executing the "LaunchAndOpenUnderExistingProcess" action. Could not open Excel document ".xls" (Error related to a file).
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Could not open Excel document ".xls" (File related error). ---> System.IO.FileNotFoundException: documentPathSafe
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.<>c__DisplayClass10_0.<LaunchExcel>g__SetActiveWorkbook|1()
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.LaunchExcel(Variant documentPath, Variant varPassword, Variant& excelInstance, Int32 launchMode, Boolean visible, Boolean loadAddInsAndMacros, Boolean needsAuthentication, Boolean readOnly, Boolean launchInNewInstance)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.LaunchExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

How can I solve that?

But when running in Power Automate Desktop, it runs fine.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (12)

Answers (1)

VJR 7,635 on at

Like (0)

Report

Before Line #6 add a line of code to write the CroppedText to a Text file or a Display box.

Run it again from the Cloud and see if it does not get the desired value.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Hi @VJR,

Thanks for your answer.
Excuse me, can you guide me how to do it, I did not understand well.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

For testing purposes,

Above line #6, add Display box and show the %CroppedText% variable.

Then run the process from the Cloud Flows

Check what the Display box shows. Does the show the correct excel file or incorrect?

One more thing,

In line #6 it shows .xls

in line #8 it is .xlsx

Which extension is correct? - .xls or .xlsx?

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Hi @VJR,

Add Message Box and it runs fine in Power Automate Desktop, but running in the Cloud gives me the same error.

Problem executing the "LaunchAndOpenUnderExistingProcess" action. Could not open Excel document ".xls" (Error related to a file).
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Could not open Excel document ".xls" (File related error). ---> System.IO.FileNotFoundException: documentPathSafe
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.<>c__DisplayClass10_0.<LaunchExcel>g__SetActiveWorkbook|1()
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.LaunchExcel(Variant documentPath, Variant varPassword, Variant& excelInstance, Int32 launchMode, Boolean visible, Boolean loadAddInsAndMacros, Boolean needsAuthentication, Boolean readOnly, Boolean launchInNewInstance)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.LaunchExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Yes, on line #6 it shows .xls, but on line #8 it is disabled, now delete line #8.
I get the file as .xls and then save it as .xlsx so I can run SQL

How can I solve that?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

But may I know why these are different?

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

In line #3 I get Excel file in .xls

In line #6 I open an Excel file in .xls and then in line #7 I close and save as .xlsx. I save the Excel file in .xlsx to filter items with SQL.

In line #8 I delete Excel .xls file to empty the folder.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hi @fgonzalez515

It is clear from the error that somewhere the file name variable is not getting initialised and therefore it is not printing the full file name in the below error. It is inly printing the extension as seen below.

Error: Could not open Excel document ".xls" (Error related to a file).

System.IO.FileNotFoundException

It is hard for me to diagnose and that too in a different language.

- Check what parameters are you passing from the cloud flows.

- For testing purpose add the default values to these parameters within Desktop flow and run it and test it that way.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Hi @VJR,

I leave images of the flow in the language, in order to help understand.
I did not understand the last two recommendations that you pointed out to me.
If you can help me with that.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hi @fgonzalez515

Instead of line #4, if you want to get the file name with/without extension then use Get file path part.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Hi @VJR,

I used "Get part of a file path"
How can I "Get part of a file path"?, because every time I download the file it changes its name. When selecting the "Get files from the folder" variable, it is not supported because it is "List of Files" and complementing it with a Range Number in Power Automate Cloud generates problems.
When I run flow in Power Automate Desktop, everything runs fine.

Was this reply helpful? Yes No