Answered

People picker help

(0) Share

Report

Posted on by ahhollan

576

I have an app with a text field that is autoassigned a value consisting of last name, first name as it would appear in Active Directory. However, it's not a people picker field, only text. I have another field where I want to use the value of the text field to query the Office 365 connection using the first field value and return the email associated with that name. Is that possible?

Thanks.

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

Verified answer

rsaikrishna

3,703 on at

Like (1)

Report

Copy link

Link copied!

@ahhollan

How are you auto assigning the first field with Last Name and Firstname ? Are you getting the currently logged in user information?

If so, place the currently logged user in a variable Set(varUser, Office365Users.MyProfile()) and use varUser.Mail property to get email address.

This way, you can set the value of 2nd text field with email directly instead of querying again.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

No. The logged in user isn't usually the person whose name needs to be in the field. It is auto assigned based on another SharePoint list with regional assignments.
Verified answer

SaiKrishnaGudluru 499 on at

Like
a
(2)

Report
Copy link

Link copied!
@ahhollan to achieve this you may need to consider two points...

may not receive exact values with the first name and last name values
to achieve correct data, the Search Field should be known
Here is an example:
Display Name: "Sai Krishna"
lblLastNameFirstName.Text = "Sai Krishna"
Query:
Set(varData,First(Office365Users.SearchUser({searchTerm:lblLastNameFirstName.Text})).Mail)

FYI: Search Term applicable to display name, given name, surname, mail, mail nickname, and user principal name. as per Microsoft Documentation

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

As @krishnags mentioned, you can use the formula to search the value.

Search term accepts following strings to search:

display name, given name, surname, mail, mail nickname and user principal name. If not provided then no filtering will be applied.

If the Search method returns multiple times, your desired value can be at any position. So filtering with proper value is important. Also, you must handle the case if Search does not return any values.

Regards

Krishna Rachakonda

ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

so would it be simpler to change my first box to a people picker that is auto-assigned? if so, how do i do that?

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@ahhollan

On App Start : Set(varUser, Office365Users.MyProfile())

On Textbox control card:

default value: varUser.Mail

Update value: varUser.Mail

But, you mentioned in your previous reply that you want to get the name from SharePoint list based on region and other information. The user who launches the app and who referred from your list, do you see both the values same? If not, then you must user approaches from @krishnags and mine to address the requirement.

Regards

Krishna Rachakonda

ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

the form user and the person auto assigned to the first field are not the same. Where do i put the variable and the search formula? Sorry, I'm not good with formulas.

thanks for the help.