Unanswered

how to search for the user's login email by selecting the value in the dropdown

(0) Share

Report

Posted on by Gorilla_8

I have a dropdown that is populated by a column in a sharepoint list, and it contains some names, however I want that when the user selects the name, save in another field the email of the user selected in the dropdown.

I already have an Offic365Users connection, and I couldn't find a solution

And using User () in PowerApps, it doesn't work, it would have to be the connection of Office365 Users

So, how I do it?

Categories:

Building Power Apps

All responses (25)

Answers (0)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What type of column contains the name in SharePoint?
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@JR-BejeweledOne

Its a choice column
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately the User() function only returns information about the logged in user and you can't use the Office365 connector the way you are trying to.

What you can do is something like this:

Change the control where you want the email address to display to a combobox and set it's formula like this:

Filter(Office365Users.SearchUser({searchTerm: Dropdown.SelectedText.Value}), AccountEnabled=true).Mail

Your user will have to select the email address from the Combobox. I haven't found a way to set the Default value of the combobox using this formula.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@JR-BejeweledOne

I see this formula on the community too, but didn't work...

I got this error: incomparable type. The 'searchterm' column in the data source you are using expects a 'text' type, and you are using an 'error' type

It is not possible through the selection of the username in the choice column appears his email in another field?
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm thinking here and put a way that when he selects the user in the column, select the email from another column but the same ID.

Example:
He selects in the column "UsuarioNome" = Gorilla_8

And so in another field appears the email =
"gorilla_8@email.com"

And if for another user and goes like this ...

It would be possible?
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

So far this is the only way I have been able to come close to what you want.

This is the Items formula in the combox box.
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Depending on how those names are formatted in the SharePoint list, they may not be able to be used for searching the Office 365 users. It would have to be in email format or a last name, which you can see in my example.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@JR-BejeweledOne

The items on the dropdown column where the user select the name:

Choices([@DataSource].MyFieldName)

And here the Default property of the text field:

Filter(UsuáriosdoOffice365.SearchUser({searchTerm: DataCardValue1_3.Selected.Value}); AccountEnabled=true).Mail

This one I got error
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@JR-BejeweledOne

When you say:

Depending on how those names are formatted in the SharePoint list, they may not be able to be used for searching the Office 365 users. It would have to be in email format or a last name, which you can see in my example.

My idea was to get the data from the second column by selecting the name and in the other field appears the email
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I know. Unfortunately the Office 365 user connector only works with certain inputs.