Populate Job Title, Department, etc based on user Full Name

[Anonymous]

Hi everyone,

I've created a form (please reference the attached image).

What I'm wanting the form to accomplish is, to enter a user's Full Name and then search for and populate their Email Address, Job Title and Department.

Or, to enter their Email Address, and populate their Full Name, Job Title and Department. 

I've added the O365 Users Connector and associated it with my form, so I have full access to all its functionality. I'm just not sure the best way to go about achieving this.

Thanks in advance!

[ericonline]

Awesome. If you wouldn't mind marking my last post as the solution, that will help others with similar questions find the answer too :). 

RE: Names in AD in different orders: That is indeed tricky! 

- Hm.... I think you can try wrapping your search query with the `in` or `exactin` function

- This should allow searching for "Smith" to find "Smith, Betsy" and "Betsy Smith". 

- I'm not exactly sure how. You'll have to do some research there. 

[Anonymous]

Thanks, @ericonline! Will definitely mark your above post as the answer. 🙂 

[Brice235i]

Thank you, this worked as the default value for the Department field... 

First(Office365Users.SearchUser({searchTerm:NameDataCardValue.SearchText})).Department

[dgarcia]

Will this work for company name as well?