Get the value of another column in same table in enumlist

[demo_demo]

I am having the Table Employe
i am having a table group
I am having the column name group members has enumlist,i am pulling the value from Employee name with select statement in suggestion value

I need the Email ID of the Group Members from Employee table in another column

Suggest any expression.??

[Sindulfo_Santac]

may be this article help you

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.