Unanswered

Excel Loop Error

(0) Share

Report

Posted on by WCF1

I have a flow that is based on a loop which opens an excel file in a particular folder directory, runs a macro on the open excel instance (to find and replace a list of keywords), closes excel, and then moves onto the next excel file in the directory. This works pretty well and cycles through a long list of files I have. However, if an excel file fails to launch properly (for whatever reason), this causes an error which terminates the flow.

Is there a way for me to just ignore any file that doesn't open correctly (and for that matter an error for any reason) and move on to the next file in the directory (i.e. so the flow works through every file and only skips those which cause an error). Ideally I'd get a list of the files that hadn't been processed, though this would just be a bonus.

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried using On Block Error?

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

Like
a
(1)

Report
Copy link

Link copied!

You can use the in-action error functionality of every action.

For example, Launching the Excel has its own set of Error Handlers

Refer the Advanced section:

Under the New rule button you can set a Flag variable. For Eg 1 if error and 0 if no error.

Enable "Continue Flow run" and select "continue next action"

Immediately after, have an If statement which will check this Flag value.

If 1 then add this file name to a List variable, that way you will also have a list of Excel files that failed.

Sometimes some error handlers do not capture specific types of errors. In that case encapsulate it with a on block error just like @ryule has suggested.

Was this reply helpful? Yes No