Solved: Prevent duplicates in list (virtual column type li... - Page 2

Sistemas_Ammade · 06-28-2020 07:43 AM

Hi! Is there a way to prevent duplicates in a virtual column type list? I would like to prevent duplicates just in the current order, (If I already picked apple, I should not add apple again?)
Thanks

LeventK

I belive that Order Details column is a reverse-ref (isPartOf property of your Ref set to TRUE). If so;
you can set a valid_if expression in your child table for that [Fruit] column. Please make necessary changes in the expression to fit in your table schema.

COUNT(
    SELECT(
        Orders[Fruit],
        AND(
            [_THISROW].[Fruit] = [Fruit],
            [_THISROW].[RefColName] = [RefColName]
        )
    )
) = 0

View solution in original post

Prevent duplicates in list (virtual column type list)