Announcements
Hello,
I have a combo box containing a list of users. And I'm trying to get the manager's email for the selected person. What I'm missing from the below formula?
Office365Users.ManagerV2(SelectBox.Selected.Result).mail
Any suggestions?
Thanks,
Omi
Office365Users.ManagerV2(emailaddresshere).mail
@omi18
Depends...where are you putting this formula?
And what are the following properties of your combobox - Items, DefaultSelectedItems?
@JR-BejeweledOne
No, Person Name.
It needs an email address.
@RandyHayes ,
label text.
What is the items property of SelectBox?
@RandyHayes
Distinct(SortByColumns(Filter('[database].[Desc]',Year=YearBox_1.Selected.Result).FullName,"FullName",Ascending),FullName)
So your FullName column then is a text column in your datasource. You have no column with the email of whoever is "fullname"?
Yes, It is a text column. and no email for a full name.
Okay, then you'll need to do a double call to the 365 user connector.
With({_user: First(Office365Users.SearchUserV2({SearchTerm:SelectBox.Selected.Result, top:1).value)}, Office365Users.ManagerV2(_user.Mail).mail )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306
