Employee Phone number missing

[3m]

Hi,

In my powerapps I am using office365user as a datasource. I added below code to display user phone extension number but nothing showing whereas if I use .MobilePhone it does show use mobile no. What I am doing wrong? I have tried to use .BusinessPhones but still no luck. I can see user extension no through office365 mail.

Any help will be appreciable.

If(IsBlank(First(Employeeprofile).TelephoneNumber),"-",First(EmployeeProfile).TelephoneNumber)

Thanks

Mohammad

[mbailey218]

I also tried to use your code in the OnSelect section and it produces an error on the ".Value" 

Launch("tel:"&(Office365Users.UserProfile("mbailey@dornier.com").BusinessPhones).Value)

This is the original code:

Launch("tel:"&First(EmployeeProfile).mobilePhone)

[sarafankit]

@mbailey218- I think you are missing a First in the formula:

Launch("tel:"&First(Office365Users.UserProfile("mbailey@dornier.com").BusinessPhones).Value)

[mikel]

For other users I used First(Office365Users.UserProfile(ThisItem.Mail).BusinessPhones).Value

[jnebben]

This is what worked for me: 

First(Office365Users.UserProfile(First(EmployeeProfile).Mail).BusinessPhones).Value 

[tcfranks]

it returns my phone number

[jnebben]

Are you looking at your profile when it returns your number? It returns the correct number for the user profile in my app

[tcfranks]

so what it really turned out to be (this is the org browser after all) is :

First(Office365Users.UserProfile(TextBox1_26).BusinessPhones).Value  (where the textbox is displaying the value of the email address.

Is there a data list browser?  to see what fields are available in the UserProfile object for example?

[jnebben]

Iv'e found a number of different ways to return the data i need but i can't get past this error: 

Office365Users.UserProfile failed: The method 'User Profile' has an invalid parameter for 'userId' 

These are just a few that work but still throw the error: 

If(!IsBlank(EmployeeProfile.BusinessPhones), First(Office365Users.UserProfile(TextBox1_26).BusinessPhones).Value)
 First(Office365Users.UserProfile((First(EmployeeProfile).UserPrincipalName)).BusinessPhones).Value)
First(Office365Users.UserProfile(TextBox1_26).BusinessPhones).Value 

[tcfranks]

yes.  I'm down to that error as well.

[jnebben]

If there is a way to suppress the error that would work as well. The app is working like it needs to now, i just cant roll it out with that error popping up