Hi everyone,
I'm having an issue returning multiple values to a textinput or label.
Basically I have two text boxes.
One with the names of employees selected from a dropdown. (I already made the text comma delimited)
(FirstName LastName, FirstName LastName, FirstName LastName)
The other with the supervisors e-mail for the selected employees.
LookUp(TravelersList,AdditionalTravelers.Text = EmployeeName,CurrentSupMail)
My issue is that my 2nd textbox only shows the supmail when one employee name is selected.
Otherwise it is blank.
Can anyone help me display multiple sup e-mails based on my criteria?
Preferable seperated by "; " so I can e-mail those involved in the travel requests.
Thank You,
Justin
Solved! Go to Solution.
I think I have it figured out. Try this crazy formula that combines the ConCat, ForAll, Split and Lookup functions.
Concat(ForAll(Split(AdditionalTravelers.Text, ", "), LookUp(TravelersList, Result = EmployeeName, CurrentSupMail)), Value, "; ")
I think I have it figured out. Try this crazy formula that combines the ConCat, ForAll, Split and Lookup functions.
Concat(ForAll(Split(AdditionalTravelers.Text, ", "), LookUp(TravelersList, Result = EmployeeName, CurrentSupMail)), Value, "; ")
Thank you so much Jeff!!
It works perfectly! 😄
I spent a lot of time trying to get anything to work and I really appreciate your help and time!
User | Count |
---|---|
142 | |
141 | |
77 | |
74 | |
71 |
User | Count |
---|---|
230 | |
166 | |
75 | |
67 | |
61 |