Hi all,
I am using the Office365Usersa connector to lookup a particular users manager. It works fine if the user has an assigned manager but throws an error when manger is null (or in the case of the combo box when i clear the current user and searching for another).
When my combobox is empty:
When my combobox has a a selected user where manager is null:
The expression i am using to get the manager is:
Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName
userSelect = combobox
I have been trying things like:
If(
!IsBlank(Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName)),
Coalesce(Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName, Blank()),
Blank()
)
If(
!IsBlank(Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName)),
Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName,
"No Manager"
)
If(
!IsBlank(userSelect.Selected.UserPrincipalName),
If(
!IsEmpty(Errors(Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName))),
Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName,
"No Manager"
),
"Invalid User"
)
If(
!IsBlank(Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName),
Office365Users.ManagerV2(userSelect.Selected.UserPrincipalName).displayName,
Blank()
)
Any guidance how i can ignore that error? I have turned on Formula level error management
Thanks,
David
