Error handling for "Select columns by lookup" and in General - how to set up examples?

1

Hello,

I would be interested in understanding

  1. how to do Error handling setup in general for Easymorph workflows and any reference to sample examples?

  2. and I am using a “Select columns by lookup” action to dynamically read column names (from another config excel) to be used in downstream flows. But there will be cases where the column in the config excel will be empty and not contain any column name to be read.
    In this case the action “Select columns by lookup” will fail and throw an error. I would like to handle this error by setting some formula (like setting it to by “True”) rather than throwing an error and use that formula in following flows to decide some other actions.
    How can this be handled in Easymorph?

Kindly share your inputs.

Thank you,
Ashish

2

Hi Ashish and welcome to the Community!

Error handling can be arranged with actions "Call" or "Iterate" that have the "capture errors and continue" mode. It means that you put the workflow logic that can fail into a module, and call the module using the "Call" action in the "capture errors" mode. In this mode, even if the called module fails it doesn't stop project execution. Instead, the output of the "Call" action contains the list of errors.

See the example below:
error-recovery.morph (2.9 KB)

You can use the "Skip on condition" action explained in our tutorials: EasyMorph | Conditional workflows

Make the action skip the action “Select columns by lookup” if the list of values is empty.

3

Thank you @dgudkov! Everything worked as you suggested.