Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Employee Phone number missing



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.







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




This is the original code:



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




New Member

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

This is what worked for me: 


it returns my phone number

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

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?


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)

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

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

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,752)