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! Go to Solution.
Try
Filter(Likes , AND( useremail() = [Email] , [Product Id] = [_THISROW].[Product Id] ) )
Try
Filter(Likes , AND( useremail() = [Email] , [Product Id] = [_THISROW].[Product Id] ) )
It works. Thank you so much
User | Count |
---|---|
41 | |
27 | |
26 | |
20 | |
13 |