Answered

Employee Phone number missing

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (37)

Answers (1)

sarafankit on at

Like (4)

Report
Can you please try:

First(Office365Users.MyProfile().BusinessPhones).Value

Was this reply helpful? Yes No
3m 16 on at

Like (0)

Report

Thanks for prompt reply. It works only for mine but when I search other user phone no doesn't change!

Sorry, I am very new in the tools.

Thanks

Was this reply helpful? Yes No
Verified answer

sarafankit on at

Like (4)

Report
Can you please paste the formula you are using, I was able to get this to work for other users as well.

Here is something you can try:
First(Office365Users.UserProfile("AnotherUser@contoso.com").BusinessPhones).Value
Please replace the anotheruser@contoso.com with the UPN/Email-id of other user in your org. The formula I had pasted earlier was showing the Phone for the current user.

Essentially the phone number will be part of the BusinessPhones, which is like an array, so you need to do First() on it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

am I missing something here? Because "businessphones" does not come up in the property browser. I get mobilePhone or TelephoneNumber, and both have my mobile phone number. This is the same for me whether I use EmployeeProfile or Office365Users.UserProfile

Was this reply helpful? Yes No
3m 16 on at

Like (1)

Report

Hi tcfranks,

This is what I am using to get employee business phone no. Hope this help

Concatenate("(03) 9999 -", First(Office365Users.UserProfile((First(EmployeeProfile).UserPrincipalName)).BusinessPhones).Value)

Regards,
Mohammad

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

as I said, "BusinessPhones" is not a recognized option to Office365User.UserProfile. Pasting in what you offered only causes an error in the formula.

Was this reply helpful? Yes No
sarafankit on at

Like (0)

Report

@SameerCh& @archanan - Any ideas what may be happening here?

@Anonymous- Can you please provide us a Session ID from your authoring session when you are hitting this? You can get the Session Id by going to File> Account > Diagnostics > Session Details

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Session ID: 7fc9d3fa-2116-3a62-9cb6-5377bccb55e7

Was this reply helpful? Yes No
sarafankit on at

Like (0)

Report

Thanks @Anonymous, we will look into it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

anything on this? I see others have the same issue, so is it truly just an enhancement idea? or a bug?

Was this reply helpful? Yes No