Hello,
In my order management app, I need to create a bot to send daily reports if condition - [order date] is not blank, i.e., bot shouldn’t send email if row is blank filtered by [order date] = today ()
now bot is sending email even order is not available for today
How to block bot if any order is not available for today?
Table name - Work Order
date column - [Order date]
You could try a BOT Event condition of
ISNOTBLANK(SELECT(Work Order[Table Key],[Order Date]=TODAY()))
Hi,
I tried the formula as per your reply and I found following
ISNOTBLANK(SELECT(Order Detail Sheet[Entry ID],[Order Date]=TODAY()))
but bot still sending email even there is no data
My testing showed that it works. Could you share where you are using the expression? And in test how it evaluates?
Thank you. How are you triggering the BOT, since it is scheduled BOT?
Hi @neovinu
can you try ISNOTBLANK(ANY(SELECT(Order Detail Sheet[Entry ID],[Order Date]=TODAY())))
Or FILTER(“Order Detail Sheet”,([Order Date]=TODAY()))
Hello,
not solved by - ISNOTBLANK(ANY(SELECT(Order Detail Sheet[Entry ID],[Order Date]=TODAY())))
Table name in process step is a slice (filtered for each - [Engineer] = “engineer 1” and [order date] = Today()+1
this is a scheduled BOT
Hi @jyothis_m ,
One can directly use ISBLANK(0 and ISNOTBLANK() with lists as well.
@Suvrutt_Gurjar Sorry 
My ignorance
Hi @jyothis_m ,
No problem at all. It is natural to think it woks on a single element.
Please clarify: which of the following is what you want?
Dear Steve,
I am looking for the first option -
Hi Steve,
Is there any update on this case ? we required the following option
kindly let us know.
Regards
The solutions offered previously should work. Please provide a screenshot of the bot’s event configuration, including the full condition expression.
