Issue Returning Multiple Values

[Justin_Moz]

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

[Jeff_Thorpe · Accepted 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, "; ")

[Justin_Moz]

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!