Referenced Rows From the referenced table, these are the rows to act on

Hi, I want to an action that deletes a specific row in another table. So far I came up up with the following settings

(FILTER(Likes, in(useremail(),SELECT(Likes[Email], ([_THISROW].[Product Id] = [Likes].[Product Id])))=true))

Problem is the formula or expression is deleting all the row in the table. How can I construct an expression that just deletes a specific row in another table? Thank you

Try

Filter(Likes , AND( useremail() = [Email] , [Product Id] = [_THISROW].[Product Id] ) )

3 Likes

It works. Thank you so much :grinning:

2 Likes