Bot: Run action on Rows

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!

Solved Solved
0 1 237
1 ACCEPTED SOLUTION

I fixed with a filter

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

View solution in original post

1 REPLY 1

I fixed with a filter

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

Top Labels in this Space