Solved: Re: Populate Manager Name

omi18 · ‎08-20-2021

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

RandyHayes · ‎08-20-2021

@omi18

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

)

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

JR-BejeweledOne · ‎08-20-2021

Office365Users.ManagerV2(emailaddresshere).mail

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.

RandyHayes · ‎08-20-2021

@omi18

Depends...where are you putting this formula?

And what are the following properties of your combobox - Items, DefaultSelectedItems?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

omi18 · ‎08-20-2021

@JR-BejeweledOne

No, Person Name.

JR-BejeweledOne · ‎08-20-2021

It needs an email address.

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.

omi18 · ‎08-20-2021

@RandyHayes ,

label text.

RandyHayes · ‎08-20-2021

@omi18

What is the items property of SelectBox?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

omi18 · ‎08-20-2021

@RandyHayes

Distinct(SortByColumns(Filter('[database].[Desc]',Year=YearBox_1.Selected.Result).FullName,"FullName",Ascending),FullName)

RandyHayes · ‎08-20-2021

@omi18

So your FullName column then is a text column in your datasource. You have no column with the email of whoever is "fullname"?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!