BOT Error: failed with exception Index was outside the bounds of the array.

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

Screenshot 2025-02-18 at 3.39.26โ€ฏPM.png

Screenshot 2025-02-18 at 3.37.23โ€ฏPM.png

Is there something I'm missing?

Thanks.



Solved Solved
0 11 219
1 ACCEPTED 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.

View solution in original post

11 REPLIES 11
Top Labels in this Space