Hi
How to do the duplicate validation between selected value and the value in collection?
Expected result: Display error message as per below image upon clicking "+" icon when Selected Material (dropdown list) = Material in Collection (Data table)
Thank you.
Hi @jshuang, you can do this by trying to look up the value from the collection and seeing if it's blank.
If(
!IsBlank(
// Try to look up from collection
LookUp(
MyCollection,
// Your dropdown is called Dropdown, and Selected.Text is the text displayed in it
Material = Dropdown.Selected.Text
)
),
... the item is duplicated ...
,
... this item is not duplicated ...
)