SELECT Expression from Operators table

[Dave_Willett]

Hi Guys
I have an ‘Operators’ table which holds users, managers etc. I am hoping to use that table to fill in an INITIAL VALUE in various tables.

SELECT(Operators[EmailAddress],([Email]=USEREMAIL()),true)

This is probably the first expression I have created but it returns all email addresses in that table instead of just one from the Operators table so its getting there.

I would need also to use a similar expression to pull other information so its not just as simple as putting USEREMAIL() in the INITIAL VALUE

Example:
SELECT(Operators[Role],([Email]=USEREMAIL()),true)
SELECT(Operators[Branch],([Email]=USEREMAIL()),true)

Theory being:
Select a column value from the Operators table where the email address in table Operators matches the useremail.

Can anyone help with this.