Delete row(s) containing a value in another table from an action

I am looking to have an action delete a row or rows in another table that match criteria using a data from the originating row.

For example (for a bookmarking process)

Table A - large data-set of read only data (Where the action will be invoked from a button in detail form)
has a column called โ€œPermitNumโ€

Table B (where bookmarking information is stored)
has a column called โ€œPermitNumโ€ that contains values that may match โ€œPermitNumโ€ from the original table. As well as the email address of the current user (who wishes to bookmark)

I would like to have an action button on a detail view in Table A that will delete the row or all rows in Table B where PermitNum = PermitNum (to remove the bookmark)

For context, the bookmarks are displayed in table A via a format rule that looks for matches between the two tables (IN([PermitNum],Bookmarks[PermitNum]))

Any help would be great. I have been trying to accomplish with an action that executes an action on a set of rows but cant get any of the โ€œReferenced Rowsโ€ criteria to work.

Solved Solved
1 15 3,411
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

For Referenced rows, try:

FILTER(
  "Table B",
  ([_THISROW].[PermitNum] = [PermitNum])
)

View solution in original post

15 REPLIES 15
Top Labels in this Space