Bot fire condition - depending if any related entry has a value

[pricetag]

Hello folks,

i try to fire up a bot but only if any of the related order summarys has en entry. 
I tried several cases but none match my expectetion.

Show More

ISNOTBLANK(ANY([Related Order Summarys][Zustand]))

In my head, this should only fire the bot if any of the related Order summarys the [Zustand] is not empty. So if all emtpy no bot, if any has a value bot starts.

When i test this condition one of the entry that def. has values, would give me a false, even when i can see that some entrys has values. (Attached) 

What do i miss?

[Suvrutt_Gurjar]

---

@pricetag wrote:

ISNOTBLANK(ANY([Related Order Summarys][Zustand]))

---

Can you please instead try

ISNOTBLANK([Related Order Summarys][Zustand])

[pricetag]

hmmm, no this does not solve my question.

the [Zustand] comes from a enum (is that a problem?), it seems when empty it counts as a comma?

[Suvrutt_Gurjar · Accepted solution]

Oh yes, please try

ISNOTBLANK(SELECT([Related Order Summarys][Zustand] , ISNOTBLANK([Zustand])))

[pricetag]

Genius, thank you!

[Suvrutt_Gurjar]

You are welcome.