Stop the bot sending email if row is blank

[neovinu]

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]

[Suvrutt_Gurjar]

You could try a BOT Event condition of 

ISNOTBLANK(SELECT(Work Order[Table Key],[Order Date]=TODAY()))

[neovinu]

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 

[Suvrutt_Gurjar]

My testing showed that it works. Could you share where you are using the expression? And in test how it evaluates?

[neovinu]

I am adding formula in yellow highlighted area 

[Suvrutt_Gurjar]

Thank you. How are you triggering the BOT, since it is scheduled BOT? 

[neovinu]

this is a scheduled BOT

[jyothis_m]

Hi @neovinu 

can you try ISNOTBLANK(ANY(SELECT(Order Detail Sheet[Entry ID],[Order Date]=TODAY())))

Or FILTER("Order Detail Sheet",([Order Date]=TODAY()))

[neovinu]

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

[Suvrutt_Gurjar]

Hi @jyothis_m ,

One can directly use ISBLANK(0 and ISNOTBLANK() with lists as well.

ISNOTBLANK() - AppSheet Help

[jyothis_m]

@Suvrutt_Gurjar Sorry 🙏  My ignorance 

[Suvrutt_Gurjar]

Hi @jyothis_m ,

No problem at all. It is natural to think it woks on a single element.

[Steve]

Please clarify: which of the following is what you want?

1. Only send the report if there are any orders for today; do not send the report if there are no orders for today.
2. In the report, only include orders for today; do not include orders that are not for today.

[neovinu]

Dear Steve,

I am looking for the first option - 

1. Only send the report if there are any orders for today; do not send the report if there are no orders for today.

[neovinu]

Hi Steve,

Is there any update on this case ? we required the following option

1. Only send the report if there are any orders for today; do not send the report if there are no orders for today.

kindly let us know.

Regards

[Steve]

The solutions offered previously should work. Please provide a screenshot of the bot's event configuration, including the full condition expression.