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! Go to Solution.
For Referenced rows, try:
FILTER(
"Table B",
([_THISROW].[PermitNum] = [PermitNum])
)
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |