Office365Users.UserProfile failed: error message

(0) Share

Report

Posted on by RL-23102031-0

Hello,

I have a field in the gallery Text = Office365Users.UserProfile(Text(ThisItem.'Team Member'.Email)).mobilePhone.

When I run the app, I get this "Office365Users.UserProfile failed" message.

Can you please help get rid of the error message?

Thank you!

Here is the entire message.

Office365Users.UserProfile failed: { "status": 404, "message": "No user found with the specified id.\r\nclientRequestId: 25821216-f2b3-4238-8dba-93220b5679d5\r\nserviceRequestId: 39d37c1e-4772-417f-8c66-43e108d2ab39", "error": { "message": "No user found with the specified id." }, "source": "office365users-eus.azconn-eus-01.p.azurewebsites.net" }

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
It's not finding the email address you are using so I would start by modifying your formula. You shouldn't need to convert the email address to text. Also try putting a label on the screen and setting it to ThisItem.'Team Member'.Email to make sure it's returning what you want to see.

Office365Users.UserProfileV2(ThisItem.'Team Member'.Email).mobilePhone

Also if you have a connector like the Office365 Users connector and it has a V2 or V3 or numbered option, always use the newest one.

Was this reply helpful? Yes No
RL-23102031-0 on at

Like (0)

Report

Thank you for your advice. I updated the formula to what was suggested above and received a different type of error message. Also, I've noticed a comment when hovering over the formula in the app, it says 'This formula uses scope, which is not presently supported for evaluation. Data type: Record.' I am not sure what it is...

Office365Users.UserProfileV2 failed: { "error": { "code": "ResourceNotFound", "message": "User not found", "innerError": { "date": "2022-03-10T18:16:49", "request-id": "7038edaa-37a2-466d-bd93-bfff1df2c940", "client-request-id": "7038edaa-37a2-466d-bd93-bfff1df2c940" } } }

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Is the 'Team Member' column a person or group column?

Was this reply helpful? Yes No
RL-23102031-0 on at

Like (0)

Report

Yes. It is a person column.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
I have tested this and it works.   So I would suggest that you do 2 things for troubleshooting.

Add a label in your gallery to display ThisItem.'Team Member'.    If your column is set to display the email address, you don't need to add the .email at the end of this.   If your column is showing a different value (name, department etc.), you will need the .email

Outside of the gallery, drop a label on the screen and put this formula in and manually enter the email address you are having problems with.   This will let you know if the problem is not something in the gallery

Office365Users.UserProfileV2("jane.hancock@abcletters.com").mobilePhone

Was this reply helpful? Yes No
RL-23102031-0 on at

Like (0)

Report

Thank you so much for the suggestions.
For the first suggestion, I changed the text field to ThisItem.'Team Member' and nothing showed in the field. To get some values to show in the field, the field has to be ThisItem.'Team Member'.DisplayName, ThisItem.'Team Member'.Email and such.

The second suggestion - I added a text field outside of the gallery and put the formula as advised. It showed my mobile number.

Does it give you any insights on what is wrong? I appreciate your help!

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

I am not sure at this point. Is this a standard canvas app or Teams Studio app? What is the data source where your column is?

As you can see below, it does work. Department is the name of my Person column

Was this reply helpful? Yes No
RL-23102031-0 on at

Like (0)

Report

My apology. I was not clear with my issue. The value (mobilePhone) shows up in the text field, but when I test run the app, the error message below shows up. I am not sure why I get the error message because the data source is a SharePoint list, and there is no issue in the SPO list as far as I know...

Here is the error message I received.
Office365Users.UserProfileV2 failed: { "error": { "code": "ResourceNotFound", "message": "User not found", "innerError": { "date": "2022-03-11T20:56:14", "request-id": "c1d9f29a-0182-4500-ba8d-9e6f0d3c42ad", "client-request-id": "c1d9f29a-0182-4500-ba8d-9e6f0d3c42ad" } } }

Was this reply helpful? Yes No
RL-23102031-0 on at

Like (0)

Report

@JR-BejeweledOne is yours a gallery? I have about 600 + rows in the SharePoint list. I don't see any errors on either the SharePoint list or app editing mode. When I test the app, I get the error message. The Power App app downloaded to my phone has a slightly different error message.

Office365Users.UserProfileV2 failed: The method 'UserProfileV2' has an invalid for parameter 'id'

Does it give you any clues to what's wrong...?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
I actually do have an app where I am doing exactly the same thing. Occasionally that error shows up even when the data populates.

Here are a couple things I have determined that are possible culprits.

The email address in one or more of the entries is missing or wrong. It could be any of the items in the gallery that has the issue, not necessarily the first one you see.

Since it doesn't pull the data row by row or in a specific order, it sometimes seems to get 'confused' and misses one.

Was this reply helpful? Yes No