LinkedIn
Twitter
Hello everyone,
I'm aiming to establish two dropdown lists within my form
one to exhibit Tech users and another for Sales users. This will be accomplished by utilizing data from the user manager table and segregating users based on their role. Specifically, when a user's role is identified as 'sales,' they should appear in the sales dropdown.
Likewise, the second type in the second list
How can I achieve this using expressions, and what specific column types should be assigned to 'Technical' and 'Sales'?
thank you
Solved
2 ACCEPTED SOLUTIONS
The expression to use in the first one will be:
FILTER("USER",[Role]="Tech")
The second one will be:
FILTER("USER",[Role]="Sales")
For this kind of operation, I would recommend using the FILTER() expression, which allow you to catch the key-column automatically.
For reference:
