Valid if Dropdown with table values + "N/A"

Hi Community,

I’ve set a valid if formula in my form to choose a value of Employee name from the Employee table.
Now, I would like to add “N/A” to the list of employees, without adding “N/A” as an Employee name.

How can I also add “N/A” as a choice?

regards

OK I’ve found the solution.
Here the my formula I used as a Valid if constraint
LIST(“N/A”)+sort(select(dbo.Employee[Name],[active]=“Y”))

2 Likes