Solved: An Expression Question - Page 2

Leonsk2037 · 10-25-2022 12:05 PM

I'm working on an Add to My Cart Action, which can apply to a Product but only once, which is a user can not add the same product twice to the Cart. However, this expression seems to not work, any ideas on fix?

the logic for this expression is that the current user can not put his own product to the cart, and from the Cart table select all rows' email columns that referenced this product and check if the current user's email is one of them.

Aurelien

Hi @Leonsk2037

What about:

AND(
  USEREMAIL()<>[Seller Email],
  ISBLANK(
    FILTER("Cart",
      AND(
        USEREMAIL()=[User Email],
        [Product Title]=[_THISROW].[Product Title]
      )
    )
  )
)

View solution in original post