cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
3m
Level: Powered On

Employee Office location

Just wondering if anyone can help how to display employee office location in powerapps using office365user connection?

For example, I am located in CB01.17.02 which I can see through office365 user profile.

 

Thanks in adavnce.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Power Apps Staff carlosag
Power Apps Staff

Re: Employee Office location

Unfortunately today the Office 365 User connector does not expose that property:

 

It only includes:User

 

 

Description: User model class.

 

          Properties:

Name

Type

Summary

Id

string

User id

User id.

DisplayName

string

Display name

Display name of user.

GivenName

string

Given name

Given name of user.

Surname

string

Surname

Surname of user.

Mail

string

Email

Email id of user.

MailNickname

string

Nickname

Nickname of user.

TelephoneNumber

string

Telephone number

Telephone number of user.

BusinessPhones

array of (string)

Business Phones

Business Phone numbers of user.

AccountEnabled

boolean

Account enabled?

Account enabled flag.

UserPrincipalName

string

User Principal Name

User Principal Name.

Department

string

Department

Department of the user.

JobTitle

string

Job title

Job Title of the user.

mobilePhone

string

 

User's mobile phone.

 

View solution in original post

Power Apps Staff carlosag
Power Apps Staff

Re: Employee Office location

Wanted to update that we have now added a few more properties to the Office 365 User Connector which now includes: City, Company Name, Country, and more;

 

 

  User Properties:

Name

Type

Summary

Id

string

User id

User id

AccountEnabled

boolean

Account Enabled?

Account enabled flag

BusinessPhones

array of (string)

Business Phones

Business phone numbers

City

string

City

City

CompanyName

string

Company Name

Company name

Country

string

Country

Country

Department

string

Department

Department

DisplayName

string

Display Name

Display name

GivenName

string

Given Name

Given name

JobTitle

string

Job title

Job title

Mail

string

Email

Email address

MailNickname

string

Nickname

Nickname

mobilePhone

string

 

Mobile phone number

OfficeLocation

string

Office Location

Office location

PostalCode

string

Postal Code

Postal code

Surname

string

Surname

Surname

TelephoneNumber

string

Telephone Number

Telephone number

UserPrincipalName

string

User Principal Name

User principal name

 

View solution in original post

3 REPLIES 3
Power Apps Staff carlosag
Power Apps Staff

Re: Employee Office location

Unfortunately today the Office 365 User connector does not expose that property:

 

It only includes:User

 

 

Description: User model class.

 

          Properties:

Name

Type

Summary

Id

string

User id

User id.

DisplayName

string

Display name

Display name of user.

GivenName

string

Given name

Given name of user.

Surname

string

Surname

Surname of user.

Mail

string

Email

Email id of user.

MailNickname

string

Nickname

Nickname of user.

TelephoneNumber

string

Telephone number

Telephone number of user.

BusinessPhones

array of (string)

Business Phones

Business Phone numbers of user.

AccountEnabled

boolean

Account enabled?

Account enabled flag.

UserPrincipalName

string

User Principal Name

User Principal Name.

Department

string

Department

Department of the user.

JobTitle

string

Job title

Job Title of the user.

mobilePhone

string

 

User's mobile phone.

 

View solution in original post

Power Apps Staff carlosag
Power Apps Staff

Re: Employee Office location

Wanted to update that we have now added a few more properties to the Office 365 User Connector which now includes: City, Company Name, Country, and more;

 

 

  User Properties:

Name

Type

Summary

Id

string

User id

User id

AccountEnabled

boolean

Account Enabled?

Account enabled flag

BusinessPhones

array of (string)

Business Phones

Business phone numbers

City

string

City

City

CompanyName

string

Company Name

Company name

Country

string

Country

Country

Department

string

Department

Department

DisplayName

string

Display Name

Display name

GivenName

string

Given Name

Given name

JobTitle

string

Job title

Job title

Mail

string

Email

Email address

MailNickname

string

Nickname

Nickname

mobilePhone

string

 

Mobile phone number

OfficeLocation

string

Office Location

Office location

PostalCode

string

Postal Code

Postal code

Surname

string

Surname

Surname

TelephoneNumber

string

Telephone Number

Telephone number

UserPrincipalName

string

User Principal Name

User principal name

 

View solution in original post

omelo
Level: Powered On

Re: Employee Office location filter

I need help filtering a gallery by the admin office location.

My data source is a sharepoint visitor list that has a people group column ( Created by), the show field is Office and checkout date field. And a few other columns not relevant here.

The idea is that the admin loggs in in the AM and visitors will register during the day.  We have multiple offices around the country.The created by will be the admin user logged in.

The app has 3 forms checkin checkout and admin. The admin page has a gallery that I need to filter by the office of the admin logged in and the status of the visitor .  Filtering by user won't work as we have shifts at reception.

I could easily create a views in Sharepoint by office but the idea is to have the admins using powerapps.

I've tried many things during the last couple of days and haven't been able to find a solution.

 

Im using the Office 365 connector and I'm able to get the office of the logged in user. I just don't know how to filter so that the Office of the user logged in = "created by".Office  column in sharepoint.

 

Please help!

Thank you


Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,293)