Bot: Run action on Rows

AppSheet AppSheet Q&A
,
1

Im creating a bot for adding or removing rows in a different table depending on a column (Yes/No) (set as toggle on views), the creating works fine with the add rows data action but when i set the toggle off (No) i tell the bot to run action on rows i put the following expresion on Referenced Rows:

SELECT(Ingredients[Ingredient],
(Ingredients[Ingredient]=SELECT(RecipeBook[Recipe],AND(([Recipe]=[_THISROW]),[Available as Ingredient]=NO)))
)

I run the test on expression and as a result it show me both Yes and No.

The results are rows on the Ref Table

The bot does not delete any row at all

Thanks!

2

I fixed with a filter

FILTER(
‘Ingredients’,
AND(
[Ingredient]=[_THISROW],
[_THISROW].[Available as Ingredient]=NO
)
)