Run command tool throwing an error when no records present

Question

Hello,

I have a simple flow that copies a template with the run command tool, when records are coming in it should execute the run command tool but when records are missing it should not do anything. But the issue is that the run command throws an error as soon as records are missing.

Any suggestions how to solve this?

Thanks in advance!

PH

2024-02-13_09-23-10.jpg

Peachyco · Answer

Maybe try this:

* Put the Run Command in a macro.
* Inside that macro, put the Run Command inside a Tool Container.
* Design the macro take as an input parameter the [Count of Records], such that if [Count of Records] = 0, then the Tool Container with the Run Command inside it is disabled.
* Add that macro to your main workflow.
* Use a Summarize tool to get the [Count of Records], and pass it to the macro.

If you don't like to work with macros, then you might try dynamically formulating the code that you pass to the Run Command based on the number of records.

* If [Count of Records] is not zero, then use your normal code.
* If [Count of Records] is zero, then execute some other code that really does nothing, like printing "Hello" or adding "1+1".