Employee Office location

[3m]

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.

[carlosag · Accepted solution]

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.

[carlosag · Accepted solution]

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

[omelo]

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

---

[ppatterson]

Office365Users.MyProfile().OfficeLocation will show location of person logged in.  You can display any items in list above.  Set the Default and update as needed.