I need to construct an Enum field using a Valid_if formula to add the referenced data to field.
My problem is when i want to add manual values to the referenced data.
In my valid_if expression i did
SELECT(Customer[Name], TRUE) --> This works correctly. When i tried
LIST(“All Customers”, SELECT(Customer[Name], TRUE)), the values in the enum list are two (“All Customers”, “expression with all my customers separated with ,”)
Is there any way to add manual values to a enum field, and a list of values ?