Answered

Retrieve Office365User Email Addresses

(2) Share

Report

Posted on by Phineas

5,331 Moderator

I have Screen1, on which is TextInput_1 and Gallery_1.

TextInput_1 is being auto-populated with names from a
SharePoint List based on choices made elsewhere.

I would like the Gallery_1 Label to auto-populate the email
addresses (from Office365Users) associated with the names
in TextInput_1.

I have tried the following in the Gallery_1 Label, but I'm getting
an error.

What am I missing?

LookUp(Office365Users.SearchUser({searchTerm:(TextInput3_1.Text)})

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Phineas,

Your LookUp is still open and has no arguments.

You xould also need to add a ".value" after the Office365Users function so that you get the table with the top 5 records.
To display it you should put it in a Gallery or look add a .Mail to it

this would be what you are trying to get:

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

You can find more information here: Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn

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!

Was this reply helpful? Yes No
Verified answer

BD-01080338-0 44 on at

Like
a
(1)

Report
Copy link

Link copied!

There will be at least two names in the TextInput field.

Does this change the formula?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I got the following to work.

If I use User().FullName or hardcode my name into TextInput3_1.Text, the Gallery displays my email address.

However, if I try to use the following there are no results.

There are times when there may be one name returned, or two or more names returned to TextInput3_1.Text.

How do I update the formula so that the email addresses associated with the names in TextInput3_1.Text appear in the Gallery?

TextInput3_1.Text = (the property dropdown is on another screen)

LookUp(WRApprovalsCollection,HOA = Property_Dropdown.Selected.HOA,Title &", "& User().FullName )

Gallery Items = Office365Users.SearchUser({searchTerm:(TextInput3_1.Text)})

Gallery Email Address Label = ThisItem.Mail

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Phineas,

Whta Happens if you only tipe in Curtis?
Still no answers?

Let me know what happens afterwards we tackle the next issue

Was this reply helpful? Yes No
BD-01080338-0 44 on at

Like
a
(1)

Report
Copy link

Link copied!

When I type Curtis I get my email address returned to the Gallery.

However, if I type in John Smith (comma or semi-colin) Curtis (and my last name), no email appears in the Gallery.

I am trying to create a formula that returns all emails for all names entered into the TextInput.

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
To do that you would have to change the formula quite a bit.

You would need to do somehting like this:

//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)

Let me know how this worked.

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!

Was this reply helpful? Yes No