I am trying to delete rows in Table A, when a row in Table B is deleted, with a Bot Trigger.
I'm pretty sure I've been able to do this with no issues before.
Bot Trigger:
When a row in Table B is deleted,
delete rows in Table A
Reference List -
I've tried all 3 options
LIST([Table_B_ID])
Select(Table A[ID], [ID]=[_THISROW].[Table_B_ID])
FILTER(Table A,[ID]=[_THISROW].[Table_B_ID])
Delete Rows
Is there something I'm missing?
Thanks.
Solved! Go to Solution.
I guess I've actually done this on a different app before...
My Solution without any additional Columns.
- Create a 'Fake' Delete Button that is a group action.
Sub actions inside group action:
- Delete Related Rows (Action on a set of rows)
- Delete This Row (Delete Action)
Hide the system 'Delete' button. Show the fake delete button.
This works well enough for my use case.
User | Count |
---|---|
23 | |
15 | |
4 | |
3 | |
3 |