dependent drop down enum appsheet from useremail or another fixed value

[Yeyo1976]

Hi, me again...

I have a question that I asume it's easy to answer.

I have this form whe

re the user (nombre and Email) both are a fixed value, due it's the name of de current user (LOOKUP(USERSETTINGS(Correo Usuario),Usuarios, Correo Electronico,Nombre)

it's any way where the dropdown "Alumno" only shows the values of this user?

I try with Lookup and with dependet dropdow, but shows me all the "Alumnos" from the table Alumnos.

My table strcuture:

Thanks!!!

[lynchk21 · Accepted solution]

What is the structure of your Alumnos table?

You should be able to use a slice on the Alumnos table based on the user setting and then use that slice for your suggested values. Or you could use a SELECT expression in your suggested values like SELECT(Alumnos[Alumnos Nombre],[Email]=[_thisRow].[Email])

Exactly what you need depends on what columns you have in the Alumnos table to reference

[Yeyo1976]

Hi, 

---

@lynchk21 wrote:

What is the structure of your Alumnos table?

---

---

@lynchk21 wrote:

Or you could use a SELECT expression in your suggested values like SELECT(Alumnos[Alumnos Nombre],[Email]=[_thisRow].[Email])

---

It doesn't work...

But the slice option works great!

Thanks!

[lynchk21]

Great!

Seeing your table, you could try this expression in SELECT if you want, but they slice seems like a better options anyway

SELECT(Alumnos[Nombre Alumno],[Email Alumno]=[_thisRow].[Email])