Select item from ref list depending on user

[Tritonos_Gruppe]

Hi

Would appreciate som help with an expression.

I have a REF list in a form and would like to have a name from that selected depending on the user logged in. I have a field called user that logs USERMAIL() as initial value. I also need to be able to change that name if form is filled on behalf of another user.

Have been trying to use SELECT without luck.

Any help is appreciated.

[QREW_Cam]

If its an enum list you’ll need to add something to the Valid If like:

SELECT(Users[UserID], TRUE)

If not there wont be any options to choose from, even current user

[Tritonos_Gruppe]

Hi, its not a enum its a standard list with ref to another table that contains the users.

[QREW_Cam]

In the Select statement is Navn the key?

[Tritonos_Gruppe]

Navn is Key yes, but also tried without having it as key.

[Steve]

SELECT() returns a List:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

You want a column value from just a single row. Try LOOKUP() instead:

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Tritonos_Gruppe]

Hi
So I have a table with users and would like to select a name from this list when user add a new entry. But I also want the user to be able to select another name if needed.

When using ANY(SELECT(Brukere[Navn], ([User] = USEREMAIL()))) it will only add new name to list.

[Steve]

Use SELECT() (without ANY()) in the suggested values expression, then optionally use LOOKUP() or ANY(SELECT(...)) in the initial value expression to provide a default choice.

[Tritonos_Gruppe]

@Steve
Thats what I have been doing, but then I get this

[Steve]

Please reread my suggestion.

[Tritonos_Gruppe]

Sorry @Steve, missed out on selected values.
But when using LOOKUP in initial value get stuck with this

[Steve]

I encourage you to read the LOOKUP() help page I posted above. I have no idea why [_THIS] even occurs in your expression.