Office 365 user profile failed

(0) Share

Report

Posted on by SShulaw

I am using this code below

First(Office365Users.UserProfile(_selectedUser.Mail).BusinessPhones).Value

And I am getting this error when running the app.

I have tried to write a If(!isblank code.... but I have been unsuccessful.

Can someone assist with this? I know this is a known bug, but that error message is daunting.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SShulaw ,

The code is valid as below - I got my phone number - you might have a look at the validity of _selectedUser.Mail

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SShulaw 51 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is working to retrieve the number as intended, but not without the error.

So I attempted to do something similar to the solution from this thread:
https://powerusers.microsoft.com/t5/Building-Power-Apps/the-service-returned-an-error-Office365Users-UserProfile/td-p/32972

however, I cannot get the If(!IsBlank to cooperate with the other code to still pull the number. The furthest I have gotten is to get the field to display a true/false.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@SShulaw ,

Just to be clear, you are saying

_selectedUser.Mail

returns a valid email address and

First(Office365Users.UserProfile(_selectedUser.Mail).BusinessPhones).Value

returns an error. If so, sorry, I cannot reproduce that here.

Was this reply helpful? Yes No
SShulaw 51 on at

Like (0)

Report
Copy link

Link copied!

Yes. So I am using the "MyPeople" connector or "People Picker" I have heard some people call it. Once that person is selected, they are then the "_selectedUser".

Was this reply helpful? Yes No
SShulaw 51 on at

Like (0)

Report
Copy link

Link copied!

And to be clear, the error only shows up when there is not someone selected. Hence why I was trying to do a If(!IsBlank

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@SShulaw ,

You need something like

If( !IsBlank(_selectedUser.Mail), First(Office365Users.UserProfile(_selectedUser.Mail).BusinessPhones).Value )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SShulaw 51 on at

Like (0)

Report
Copy link

Link copied!

YES! This worked perfectly! Thank you so much.

Was this reply helpful? Yes No