Unanswered

Multiple mobile numbers in PowerApps

(0) Share

Report

Posted on by Mirtemir

242

I am trying to show a personal mobile number and business mobile number from users. I retreive the numbers from the Active Directory. I use this formula, but i only show the first personal mobile number. How can I show the second mobile number?

If(IsBlank(First(EmployeeProfile).mobilePhone);"-";First(EmployeeProfile).mobilePhone)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mirtemir ,

May be something like below will help in your case.

If(IsBlank(First(EmployeeProfile).mobilePhone);"-";IsBlank(First(EmployeeProfile).TelephoneNumber);First(EmployeeProfile).mobilePhone;First(EmployeeProfile).mobilePhone&" "&First(EmployeeProfile).TelephoneNumber) or If(IsBlank(First(EmployeeProfile).mobilePhone);"-";First(EmployeeProfile).mobilePhone&" "&First(EmployeeProfile).TelephoneNumber)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
logixcrm 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mirtemir

Question - do both phone numbers display on the user profile in columns (fields) or are they in a grid? the reasion I ask is because you are using a "First" expression which is normally used to to consider on the first record retrieved.

I am going to assume you want to show both mobile numbers in one field in a single input on a canvas app.

Firstly you should add an Office365User Connection.

Next create a add a label to get the UserID, for this you can user the following expression

Next add in input and use the following expression

Office365Users.UserProfile(Label7.Text).mobilePhone & " - " & First(Office365Users.UserProfile(Label7.Text).BusinessPhones).Value

I know this is not exactly what you are trying to do, however, once you are able to retrieve the data you can then write an If expression to manage how the data is displayed.

I hope this helps.

Was this reply helpful? Yes No
logixcrm 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mirtemir

Question - do both phone numbers display on the user profile in columns (fields) or are they in a grid? the reasion I ask is because you are using a "First" expression which is normally used to to consider on the first record retrieved.

I am going to assume you want to show both mobile numbers in one field in a single input on a canvas app.

Firstly you should add an Office365User Connection.

Next create a add a label to get the UserID, for this you can user the following expression

Next add in input and use the following expression

Office365Users.UserProfile(Label7.Text).mobilePhone & " - " & First(Office365Users.UserProfile(Label7.Text).BusinessPhones).Value

I know this is not exactly what you are trying to do, however, once you are able to retrieve the data you can then write an If expression to manage how the data is displayed.

I hope this helps.

Was this reply helpful? Yes No
Mirtemir 242 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, it did not get what i am after. I am trying to get these numbers. I would like to show the Homenumber (if there is one) and the Mobile number.

Was this reply helpful? Yes No
Mirtemir 242 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, i could not get this to work. So, i'll pause it for now and try again later.

Was this reply helpful? Yes No