Error message

(0) Share

Report

Posted on by batmanMon

202

hi. I have a customized form. When the user opens the form on sharepoint, it would extract users details.

I used this code for the managers hierarchy

Office365Users.ManagerV2(User().Email).mail - user manager

Office365Users.ManagerV2(Office365Users.ManagerV2(User().Email).mail).mail - manager of the users manager

Office365Users.ManagerV2(Office365Users.ManagerV2(Office365Users.ManagerV2(User().Email).mail).mail).mail - etc

It works. But one user have this error message and it doesnt work for him, im not quite sure why.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @batmanMon ,

Perhaps someone's manager hasn't been set. This will cause the ManagerV2 function to return an error.

I advise to add some error handling in your code, for instance with the IfError function: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-iferror

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report

@BCBuizer thank you for your reply. The user works for the same manager for a couple of years now 😞 i dont know why he is the only one whos got this error message.

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report

The weird thing is, if I put a text label and type this specific users email address(lets call him Bob). then I inserted a second label with Office365Users.ManagerV2(Label2.Text).mail. it works, it recognizes Bobs manager.

The form doesnt recognize Bobs office365 details, when he opens the app himself. It works perfect for any other user

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report

I know now what was wrong. It appears that the user has two email addresses. I dont know how to go around it in smart way, so i hardcoded Bobs email addresses in if statement

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @batmanMon ,

Instead of using User().Email you may opt to use Office365Users.MyProfileV2().userPrincipalName

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @batmanMon ,

Instead of using User().Email you may opt to use Office365Users.MyProfileV2().userPrincipalName

Was this reply helpful? Yes No
batmanMon 202 on at

Like (1)

Report

@BCBuizer it worked! Thank you so much!

Was this reply helpful? Yes No