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! Go to Solution.
I fixed with a filter
FILTER(
'Ingredients',
AND(
[Ingredient]=[_THISROW],
[_THISROW].[Available as Ingredient]=NO
)
)
I fixed with a filter
FILTER(
'Ingredients',
AND(
[Ingredient]=[_THISROW],
[_THISROW].[Available as Ingredient]=NO
)
)
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |