Dear community member,

It can often happen that some situations are overlooked where data for a "lookup" column is not available during events like Updating or Creating a row in your CRM, thus your Cloud Flow action run is bound to fail if you haven't applied any preventive measures to it.

You can apply multiple Condition actions but your Cloud Flow model/structure becomes overwhelming and confusing when you have more than two lookup columns that can cause failure.

This short guide will show one of possible solutions how to prevent a Cloud Flow action from failing when a lookup column output from a previous action is "null/does not contain data".

By implementing a custom expression function, you can failproof the action and keep each lookup column empty if required.