Using Select () with dropdowns

[xavier7lemon]

The expression in question is exactly what I want to happen; Select values from [Company/Opp] column within the (Top Opps ALL) table when the user email matches the text in the [Rep] column… however nothing shows in the dropdown.

Is ‘Suggested Values’ the correct place to enter this formula?

I’m really baffled on how to do this - it’s the last step in my app

[Suvrutt_Gurjar]

Hi @xavier7lemon,

One thing you may wish to try is, if removing quotes in “USEREMAIL()” in the expression helps.
So please have expression as … =USEREMAIL() instead of …=“USEREMAIL()”

[xavier7lemon]

I got the values to show up by using your suggestion above however I am now getting this error:

Any suggestions on how to record the users selections?

[Suvrutt_Gurjar]

Hi @xavier7lemon

It sounds that you have defined the field “Opportunity 1” as Enum type and the value"Project Shield- Presbyterian deal" is not one of those valid Enum values. Is the expression for the field "Opportunity 1"trying to populate that invalid value into the field?

[xavier7lemon]

The expression for ‘Opportunity 1’ is suggesting starting values of the dropdown list from a column in another table.

What I’d like to have happen is a user selects one of those values in the dropdown and the selection is recorded on another sheet. This was working until I added the expression to suggest starting values.

[MultiTech · Accepted solution]

A quick hack of a solution would be to turn on the switch that allows new values in the enum.

[xavier7lemon]

That worked. I must’ve accidentally turned that switch off. The other Enums have that switch on and are working fine. Thanks a ton @MultiTech_Visions @Suvrutt_Gurjar !

Looking forward to deploying this app as my companies MVP.