Input field to pick Workspace users

[Robbit]

Hello,

we want to deploy an app in which the user can enter an event and name all the company's users that have been attended. So we need an input field in which only active Workspace users can be chosen. What do we have to do to offer such an input?

Thanks in advance 🙂
-R.

[AleksiAlkio · Accepted solution]

You would need to have a Users table with the name (label), email (key) and status columns. Then you can use for example EnumList (base of Ref) column, with a formula like ORDERBY(SELECT(Users[Email],[Status]="Active"),[Name],FALSE). Then it shows names with the dropdown, but it saves the email (unique) to your data source.