How to get Active Directory information in to a form?

(0) Share

Report

Posted on by SPS-DEV-22

516

I'm trying to use user().<some field> I can get the User().FullName how ever I can not get any other information.

How do I get the Active Directory information pulled into form fields.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @SPS-DEV-22

As an example - Company

Office365Users.UserProfile("user.name@company.com").CompanyName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

there are like 3 fields on 0365. I need additional fields than what I seem to be able to find, does that mean I need to get the team to update it

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report
this didnt work:

Office365Users.UserProfile("user.name@company.com").CompanyName
I tried Department...

Office365Users.UserProfile("user.name@company.com").Department

Office365Users.UserProfile("Department").Department

No Go, Like a NOVA

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @SPS-DEV-22 ,

Yes - you can only find fields that exist in your AD.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@SPS-DEV-22 ,

I assume you used the user's actual email address.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

We have 10K that work for the company... I can not do a single person's email address.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @SPS-DEV-22 ,

Sorry I am a bit lost here - what are you going to use to identify the user if not their email address ?

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report
ok, let me ask this, if I put a person email address in the
Office365Users.UserProfile("user.name@company.com").Department

this doesnt work either
Office365Users.UserProfile("user.name@company.com").UserName

it is blank.. I think I need to get with our 0365 admin...

"user.name@company.com"
Do I need to put a user name here? as I got 10K users...

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@SPS-DEV-22 ,8

Yes

Office365Users.UserProfile("fred.jones@smith.com").Department

will find the department that Fred Jones works in Smith Company.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

I need the code to find the 9999 other employees, not just Fred...

I found this:
Office365Users.UserProfile(User().Email).<'code item'>

problem is the info I want is not available.

Was this reply helpful? Yes No