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

Solved Solved
0 2 1,872
1 ACCEPTED SOLUTION

Try

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

View solution in original post

2 REPLIES 2

Try

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

It works. Thank you so much

Top Labels in this Space