Answered

Retrieve the businessPhone number for the current user

(0) Share

Report

Posted on by Chris1968

1,148

Hi,

I'm trying to retrieve the businessPhone number for the current user to self populate a DataCard in my app.

Managed to get Current Users Name, Department, ManagersName and Manager Email

Using this formula Office365Users.UserProfileV2(User().Email).displayName (UserProfileV2 changed to ManagerV2)
When using Office365Users.UserProfileV2(User().Email).businessPhones get any error message Expected 'Text Value'

Tried this formula Text(Office365Users.UserProfileV2(User().Email).businessPhones) Another error message Expecting Text or Number at this point.

The SP data source this is connected to as the column 'Contact Number' a Text, Single line.

How do i get the number to populate the field??

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report

Hi @ClarkyPA365 ,
Try using the below code-
Index(Office365Users.UserProfileV2(User().Email).businessPhones,1).Value

Was this reply helpful? Yes No
Chris1968 1,148 on at

Like (0)

Report

Hi @NandiniBhagya20

Thank you for you prompt reply.

It worked 😃

Can you provide an explanation of how and why this worked??

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (2)

Report

Hi @ClarkyPA365 ,
Office365Users.UserProfileV2(User().Email).businessPhones will return a table with phone number in Value column. There can be more than one business phone number. In the below code we are capturing value of 1st item from the table
Index(Office365Users.UserProfileV2(User().Email).businessPhones,1).Value

If you would like to display all values (in most of the cases there will only be a single entry), you can use below code -
Concat(Office365Users.UserProfileV2(User().Email).businessPhones, Value)

Was this reply helpful? Yes No