Lookup Email and Add phone Number to field

(0) Share

Report

Posted on by knishal

185

Hey I have the following fields:

The email field is coming from SharePoint person column, I am trying to automatically insert the phone number when an email is

selected. Currently its not letting me with SharePoint.

I found this formula to display phone number but I want to modify it so it look at the email field and based on the email it automatically insert the phone number. The email field is datacardvalue40

First(Office365Users.UserProfileV2(ThisItem.Name.Email).businessPhones).Value

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@knishal

What is the Items property of your Email combobox? If it is already Office 365 based, then you don't need to perform the UserProfile action again, you can just reference the combobox.

i.e.

First(yourDropdown.Selected.businessPhones).Value

I hope this is helpful for you.

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report

The email combobox is a person column from a sharepoint list. I tried the formula you provided but its not working

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@knishal

Yes...that is why I asked if the Items property was Office 365 based! Since it is not, then it will not have any of that information and you will need to perform the userprofile action.

So, your Default property on your Phone Number textinput control should then be:

First(Office365Users.UserProfileV2(DataCardValuie43.Selected.Email).businessPhones).Value

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report

I have the office 365 connector and its giving this error: I have to enter information before the error goes away. Is there a fix for when the form is blank?

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@knishal

Sure...

If(!IsBlank(DataCardValuie43.Selected.Email), First(Office365Users.UserProfileV2(DataCardValuie43.Selected.Email).businessPhones).Value )

Was this reply helpful? Yes No
knishal 185 on at

Like (1)

Report

@RandyHayes amazing, It works. thanks a lot for your help with this

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@knishal

Excellent! Happy to help!

Was this reply helpful? Yes No