Dependent Enumlist

"Hi, I have a table called Libro de Clases, which is filled in the columns  Profesora, Nivel and Jornada using the formula LOOKUP(USEREMAIL(),Profesoras, EMail,Nombre). 

Screenshot 2024-04-07 01.13.49.png

I need is to be able to select the list of students that meet the three criteria: Teacher, Level and Day, either through an enum list or another alternative that you can suggest.

Yeyo1976_0-1712463797870.png

Something like this, but with the referenced data as I show early.

Yeyo1976_0-1712464260913.png

Please keep the language simple, as I am quite new to this program

0 2 44
2 REPLIES 2

Let's assume the "Pick a continent" would be an EnumList column. Then the dependent dropdown for the "Pick a country" needs to be..

SELECT(Documents[Country],IN([Continent],[_THISROW].[Pick a continent]))

Thanks!

What I need is that in the second pic, below Jornada, show the enumlist of students dependant of theese filters: Profesora, Niveles y Jornada.

The real data are the first 2 pics, could you give me a hand?

 

Top Labels in this Space