Scheduled bot returns 0 rows when run on Slice or with Filter

I have a Daily scheduled bot that runs every night.  It runs a process of several data actions against each row in the table it applies to.  When it runs it gives me this message in the Audit Log indicating that the slice is surfacing 0 rows:

Properties:
{
"ForTableNameRows": "Table or slice 'Compound Mismatch' returned 0 rows",
"AppTemplateName": "d2328598-8320-43fe-a2b5-3830aac4a22e",
"Operation": "Unknown",
"Result": "Success"
}

The slice in fact has 6 rows. Here are the settings for the event:

thethunderbird_0-1657425932090.png

It works when I run it against the entire table.  It returns 0 rows when I select the Slice, or any other Slice, or put anything in the Filter Condition field other than true.

Solved Solved
0 5 232
1 ACCEPTED SOLUTION

It was a blank value comparison operator issue.  My app had the Legacy setting and it was causing the expression for the slice to work differently in the app vs the bot.  I changed the setting and added some ISBLANK() expressions to the filter and it solved it.

View solution in original post

5 REPLIES 5
Top Labels in this Space