hi all,
Say I have a datacardvalue of "Louis Stevens" ? How can I get their email?
Lets say I have datacardvalue24 with this in its default -
Hi @wonka1234
Assuming you have a text label (Label1), set its Text property to:
LookUp(EMPLOYEE_LIST, Name = DataCardValue24.Text).Email
(Or)
LookUp(EMPLOYEE_LIST, Name = DataCardValue24.Text, Email)
You might want to add some error handling to manage cases where the name is not found in the EMPLOYEE_LIST.
IfError(
LookUp(EMPLOYEE_LIST, Name = DataCardValue24.Text, Email),
"Email not found"
)
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional