Answered

How to move CurrentItem / ExcelInstance in Error Handling

(0) Share

Report

Posted on by martvis

Goodday,

I'm trying to close and copy/delete a CurrentItem Excel session when it triggers an Error in the flow. However, when the file is not open at the moment of an Error the Power Automate Desktop app fails to execute the If condition at line 4.

I tried to resolve this with the If condition at line 3, but it still fails at line 4 when the Excel isn't open.

Any ideas how to resolve this, or generally improve the Error Handling towards operational Excels?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Martvis88 ,

Please find the below solution.
In If window action instead of By Window Instance or Handle use By Title and/or Class. It is working.

Code:
Please copy the below code to your flow.
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Downloads\\Sample_Template (2).xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance IF IsNotEmpty(ExcelInstance) THEN IF (UIAutomation.IfWindow.IsOpenByTitleClass Title: $'''Sample_Template (2) - Excel''' Class: $'''XLMAIN''') THEN Excel.CloseExcel.CloseAndSave Instance: ExcelInstance File.Copy Files: $'''C:\\Users\\Downloads\\Sample_Template (2).xlsx''' Destination: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\New folder''' IfFileExists: File.IfExists.Overwrite CopiedFiles=> CopiedFiles File.Delete Files: $'''C:\\Users\\Downloads\\Sample_Template (2).xlsx''' END END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Martvis88
Instead checking the instance. you can create label and next place close excel action like below screenshot. It should work in both ways even though the excel instance already closed also.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
martvis 71 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for the quick responses Deenuji and VishnuReddy1997. I now resolved this with the additional Title and/or Class condition, works like a charm. Will experiment with the Exception Handling methods in the coming weeks to see how that works. 👍

Was this reply helpful? Yes No