//OnChange or on a button select after entering the names
Set(varNames,Split(TextInput3_1.Text, "; "))
//the initial formula shold be changed like this
ForAll(varNames,
First(Office365Users.SearchUser({searchTerm:(ThisRecord.Value)}).value).Mail)
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!
Thanks, and happy building!
Office365Users.SearchUser({searchTerm:(TextInput3_1.Text)}).value // Returns top 5 results
//get first result and display only the mail
First(Office365Users.SearchUser({searchTerm:(TextInput3_1.Text)}).value).Mail
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!
Thanks, and happy building!