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.
Solved! Go to Solution.
I was able to resolve this by creating a drop down field and setting the Items property as "First(EmployeeProfile).BusinessPhones".
Unfortunately @LeSmanSP creating that drop down menu did not work for me... I'm still getting the error "Office365Users.UserProfile failed: The method 'UserProfile' has an invalid value for parameter 'userId'" whenever the app is started 😞
I created the drop down menu on the initial employee directory search page and set the visibility to False.
Any other suggestions?
Ok, hope this helps anyone else who is going crazy trying to get this working.
I created a drop down menu as described below, but as my text I put: First(Office365Users.UserProfile(First(EmployeeProfile).UserPrincipalName).BusinessPhones)
This loaded the array at initialisation and I'm no longer getting the error at application start.
The information is stored in the BusinessPhones collection.
So you can set the "Text* property to the following formula: If(IsBlank(First(First(EmployeeProfile).BusinessPhones).Value),"-",First(First(EmployeeProfile).BusinessPhones).Value)
and the OnSelect action should be:
Will this formula only work for the user whose email is in place of "email@example.com"? If so, what should I put in place of that example email in order for the business phone number to show up for each user that accesses the app?
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!