Combining different tables as dropdown

[Nadhirah]

Hi everyone,

So, I have a 3 different tables which is technician team, engineer team and cleaner team each holding the same column such as name, id and phone number for example. so in another different table which I will call it as Drill. 

Using form, Drill needs to asks which team and shows another dropdown that have all the name of technician. engineer and cleaner based on the previous selection. Only using one dropdown. 

Question is, is it possible to combine different tables as one dropdown?

[Suvrutt_Gurjar · Accepted solution]

In general, it sounds that you could try table based valid_ifs

For example for the [Name] column of the Drill table, the valid_if could be something like 

SWITCH([Team] , "Technician", Technician_Table[Name] ,

                 [Team] , "Engineer", Engineer_Table[Name] ,

                 [Team] , "Cleaner", Cleaner_Table[Name] ,

                LIST("")

             )

[Nadhirah]

This works for me. Thank you so much! I tweak a bit though

SWITCH(
[Staff Position],
"Technician", Team[Name],
"Engineer", Team[Name] ,
"Cleaner", Team[Name],
LIST("")
)

[Nadhirah]

But what if I want to make another column that refer to the name. For example, if the name was chosen, then the phone number and email should be shown automatically. Usually I would use reference but in this case i am not sure how to switch it 

[Nadhirah]

Lmao I found the solution to this.

I used this formula for the column related 
SWITCH(
[Staff Role],
"Technician", LOOKUP([Staff Name],"Team","Name","Phone"),
"Engineer", LOOKUP([Staff Name],"Engineer Team","Name","Phone"),
"Cleaner", LOOKUP([Staff Name],"Cleaner Team","Name","Phone"),
LIST("")
)

[Suvrutt_Gurjar]

Thank you for the update. Good to know you extrapolated the suggested  concept to switch the tables based on selection.