Lookup based on a condition

Is there a way to carry out a lookup based on a condition?

I only want to lookup values from a table where the values in This table's column "Revenue Split" are 0?

I know I can achieve the same thing in a couple of steps but just wondered if I'm missing something?

There is no single action for such a scenario. You can do it with a couple of 2-3 actions.

1 Like

Wow - that was quick!

Thank you for confirming!