Error message

(0) Share

Report

Posted on by batmanMon

199

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:

Mobile App

Using Apps Using Formulas

General Questions

All responses (7)

Answers (1)

batmanMon 199 on at

Like (1)

Report

Re: Error message

@BCBuizer it worked! Thank you so much!
Verified answer

BCBuizer 22,027 Super User 2025 Season 1 on at

Like (1)

Report

Re: Error message

Hi @batmanMon ,

Instead of using User().Email you may opt to use Office365Users.MyProfileV2().userPrincipalName
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Error message

Hi @batmanMon ,

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

Like (0)

Report

Re: Error message

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
batmanMon 199 on at

Like (0)

Report

Re: Error message

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
batmanMon 199 on at

Like (0)

Report

Re: Error message

@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.
BCBuizer 22,027 Super User 2025 Season 1 on at

Like (0)

Report

Re: Error message

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