Unanswered

Getting Email address using Office365 Connector

(0) Share

Report

Posted on by pocketens

Hey Everyone,

Im using a combobox and the office 365 connector to populate it so you can search for a username. The goal is/was to use that display name and then use the collect feature to input that users email address into a sharepoint list. Its not working, when I submit it comes through as blank, and even trying to set a variable, its mentioning the Username1.Mail as a table and not a text field.

What am I doing wrong here:

Office365Users.SearchUser({searchTerm:ProjectControllerCombo_1.SearchText}).DisplayName

Thats the one to search for the username.

For the onselect for the next page to declare a global variable to get the email, I have this:

Set(ProjControllerEmail,First(Office365Users.SearchUser({searchTerm:ProjectControllerCombo_1.SearchText}).Mail));

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Consider this:

On your combobox:

Office365Users.SearchUser({searchTerm:ComboBox2.SearchText}).DisplayName

OnSelect of the Button:

Set(ProjControllerEmail,Office365Users.SearchUser({searchTerm:ComboBox2.SearchText}))

In your TextBox or what to save:

LookUp(ProjControllerEmail,DisplayName=ComboBox2.Selected.DisplayName).Mail

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@pocketens wrote:
Hey Everyone,

Im using a combobox and the office 365 connector to populate it so you can search for a username. The goal is/was to use that display name and then use the collect feature to input that users email address into a sharepoint list. Its not working, when I submit it comes through as blank, and even trying to set a variable, its mentioning the Username1.Mail as a table and not a text field.

What am I doing wrong here:

Office365Users.SearchUser({searchTerm:ProjectControllerCombo_1.SearchText}).DisplayName

Try this:

First(Office365Users.SearchUser({searchTerm:ProjectControllerCombo_1.SearchText}).value).DisplayName

This connector returns a record called "value", which within this record is a table of all the possible matches from your search. Your code needs to access the "value" record, and then be able to deal with a table of more than one record within that.

Similarly, your second statement should probably look more like:

Set(ProjControllerEmail, First(Office365Users.SearchUser({searchTerm:ProjectControllerCombo_1.SearchText}).value).Mail );

Hope that helps,
Bryan

Was this reply helpful? Yes No