I’ve this bot:
In condition:
COUNT(SELECT(OGGI[ID], [COLLEGAMENTO] = isnotblank)) > 0
Where Oggi is slice and Collegamento is a column URL type
In the run this process, email i’ve:
<<COUNT(SELECT(OGGI[ID], [COLLEGAMENTO] = isnotblank))>> number of record with Collegamento shown
and when i run test the mail is sent but the count is always 0 even if i’ve a record with Collegamento with data in it
Any hints ?
[quote=“FaCe”]
<
At least syntactically, it should be
<<COUNT(SELECT(OGGI[ID], ISNOTBLANK([COLLEGAMENTO])))>>
Thank you so much!
That error is a permanent warning error to warn that a row level expression cannot be used in a bot condition such as [_THISROW] etc.
However in general the condition you have should work. You may want to see the result of the expression by tapping on “Test” option at the test pane as highlighted below.
In my test bot, the scheduled bot is set to run when there are more than 6 order records with “Open” status and it runs perfectly.
when there are more than 6 test records the bot running condition evaluates properly and the bot runs
The bot does not run when there are less than 7 open orders and the condition evaluates to false as shown below
So in summary, you may want to evaluate how your bot running conditions is working.
