Solved: Re: Office365Users.UserProfile failed: error messa...

222lovebirds · ‎03-10-2022

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" }

222lovebirds · ‎03-17-2022

@JR-BejeweledOne I did some research and found out about the "Experimental Features" and enabling "Formula Level Error Management." After I enabled the feature and added this code to "OnError," the error message stopped popping up.

Code: IfError(Office365Users.UserProfileV2(Email).mobilePhone, "")

View solution in original post

JR-BejeweledOne · ‎03-10-2022

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.

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

222lovebirds · ‎03-10-2022

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" } } }

JR-BejeweledOne · ‎03-11-2022

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

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

222lovebirds · ‎03-11-2022

Yes. It is a person column.

JR-BejeweledOne · ‎03-11-2022

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

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

222lovebirds · ‎03-11-2022

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!

JR-BejeweledOne · ‎03-11-2022

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

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

222lovebirds · ‎03-11-2022

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" } } }

222lovebirds · ‎03-16-2022

@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...?