How to delete row in another table if this table changes

[ezosoro]

I have a [Team] table with a [Status] column. When a Team member’s status changes to “Terminated” I want their row deleted from the Schedule table.

I made a grouped action for the Team table…
The first action just set’s the value of the [Status] column of the Team table to “Terminated”.
The second action looks like this: (the Schedule[Name] column contains the email from the Team table by reference.)

I think everything looks good, so why won’t the schedule row delete?

[Marc_Dillon]

I’m guessing the [Name] column is not the key column on the Schedule table.
Use FILTER(Schedule , … ) instead of SELECT(Schedule[Name] , … )
“Referenced rows” requires a List of key values on the “referenced table”.