Run Action on another table - HELP

[Domearian]

I'm trying to run a simple action on another table 2 based on information from table 1.

For Table 2, I am simply trying to select the item (which is unique) where the [DOB ID] equals table 1's [DOB Unique ID] and then add a bit of text, "Closed", to be exact, to that second table.

So I am running this expression: 

SELECT(Patrols Data[DOB ID], ([DOB ID] = [_THISROW].[DOB Unique ID]), FALSE)

Patrols Data[DOB ID] is table 2, where I want to make the change.

[DOB ID] is table 2, selecting what I want to match against [_THISROW].[DOB Unique ID] from table 1.

The action "Close Patrol Entry along with DOB Closure" is assigned against the correct table. For some reason, this action simply isn't running. Any help would be greatly appreciated.

[Izzat_Safrah · Accepted solution]

Try it maybe it will work

FILTER(

"Patrols Data",[DOB ID]= [_THISROW].[DOB Unique ID]

)

[Domearian]

That worked thank you very much. I'm surprised the select didn't work.