How to write a formula to look up user based on job title

[DanielRK]

Hi,

I have a formula to look up a person's email based on their job title:

LookUp(
            Office365Users.SearchUserV2({searchTerm: ""}).value,
            JobTitle = "CEO").Mail
);

How would you write this to get more information about the user like the User() function where you can append 

.Email

.FullName

.Department

As needed? My formula is too narrow. I want to get more attributes than just the email.

Thanks a lot for your help!

Regards,

Daniel

[v-qiaqi-msft · Accepted solution]

Hi @DanielRK,

Have you solved your problem?

Do you want to get info based on Job Title?

Could you please share a bit more about your need?

Actually, the User() function only support to get info about the current login user.

If you want to get info like department, Mail based on the Job Title, I think you should use the Office365Users() function.

I think you should pull out all the Job Title using Office365Users() as below:

Distinct(Office365Users.SearchUserV2({searchTerm:""}).value.JobTitle,JobTitle)

Then you could add a Label and set the Text property to display the needed info based on Job Title:

LookUp(Office365Users.SearchUserV2({searchTerm:""}).value,JobTitle=ComboBox35.Selected.Result).Mail

There is no much easier method as above to achieve this.

[DanielRK]

Hi @v-qiaqi-msft ,

My apologies for only replying to you now.

Thank you this helps me tremendously.

Regards,

Daniel