Reports for Office 365 Users

Office 365 Users

is a data source that enables you to import data to Power Apps. You can access the user profiles in your company by using your Office 365 account with the Office 365 Users connection. There are various titles like your own profile information, other employee’s profile information and manager information. In this article, we will be using the DirectReports feature.

With this feature, you can list the personnel of a manager by clicking their names like shown in the GIF below.

Add Office 365 Users Connection to the Mobile App

Go View –> Data Sources –> Add Data Source –> Write Office to the search bar and add the Office365Users connection.

Using the Offıce365Users.DirectReports Feature

You need to add a Dropdown List and a Gallery item to your own application in order to design a screen like below and list the personnel.

*The name of the Dropdown List used in the scree is Dropdown1. The formulas have been written according to this item name.

• This formula is written into the Items property of the gallery item on the screen

Office365Users.DirectReports(Dropdown1.Selected.Value)

• In order to edit the text in gallery, you can click on the Fields Edit in the window on right and edit one by one on the screen that pops up.
• To display the user photos, the formula below will be written into the Image property of the Display item.

Office365Users.UserPhoto(Subtitle6.Text)

Subtitle6.Text is the Label that contains the e-mail addresses in the Gallery.

You can take a look at this link for Office365 connection details.

Offıce365 User Information

Office 365 Users

is a data source that enables you to import data to Power Apps. You can access the user profiles in your company by using your Office 365 account with the Office 365 Users connection. There are various titles like your own profile information, other employee’s profile information and manager information.

In this article, we will be using the UserProfile feature.

With this feature, you can view details of each user among the company personnel like shown in the GIF below.

Information to Use

The users formula is used with the formulas below.

1. MyProfile (to access your own profile)
2. UserProfile (to access any user’s profile)
3. Manager (to access any user’s manager profile)
4. DirectReports (to get data as a report)
5. SearchUser(to search any user in the system)
6. UserPhoto(to access any user’s photo)

Each one of the title above can be more detailed while used with the sub titles below.

• City
• CompanyName
• Country
• Department
• DisplayName
• GivenName
• Id
• JobTitle
• Mail
• MailNickname
• mobilePhone
• OfficeLocation
• PostalCode
• Surname
• TelephoneNumber
• UserPrincipalName
• AccountEnabled
• BusinessPhones
• Manager
• Photo

Add Office 365 Users Connection to the Mobile App

Go View –> Data Sources –> Add Data Source –> Write Office to the search bar and add the Office365Users connection.

Create Office365 connection in a Mobile App

You need to add a Dropdown list, Image to show your photo and Label to show textual data to your own app in order to design a screen like the one below.

*The name of the Dropdown List used in the scree is Dropdown2. The formulas have been written according to this item name.

Formulas

Displaying the user details based on the e-mail address chosen from the dropdown list.

• Write the formula below into the Image property of the Display item.
  Office365Users.UserPhoto(Dropdown2.Selected.Value)

There is information like displayName,Mail, Department, JobTitle in Labels.
The formulas are the same, we only determine the detail we want in the last parameter.

• “displayName: ”  &   Office365Users.UserProfile(Dropdown2.Selected.Value).DisplayName
• “Mail: ”  &  Office365Users.UserProfile(Dropdown2.Selected.Value).Mail
• “Department: ”  &  Office365Users.UserProfile(Dropdown2.Selected.Value).Department

Different from the others, the Office365Users.Manager formula is used for the Manager information.

• “Manager: “& Office365Users.Manager(Dropdown2.Selected.Value).DisplayName

You can take a look at the link for the Office365 connection details.

MAKE A SEARCH IN THE OFFICE 365 USERS LIST

Office 365 Users

is a data source that enables you to import data to Power Apps. You can access the user profiles in your company by using your Office 365 account with the Office 365 Users connection. There are various titles like your own profile information, other employee’s profile information and manager information.

In this article, we will use the SearchUser feature.

Thanks to this feature, you can view the list of company users and search users like in the image below.

Add Office 365 Users Connection to the Mobile App

Go View –> Data Sources –> Add Data Source –> Write Office to the search bar and add the Office365Users connection.

 Using the Office365Users.SearchUser Property

You need to add a Text Box and a Gallery item to your own application in order to design a screen like below and make a search by writing user names.

*The name of the Text Box used in the scree is txt_search_user. The formulas have been written according to this item name.

“Search” has been written into the Hint Text property of the txt_search_user item through the properties window on the right. And then it has been enabled for the text to be written inside by increasing the left padding through the padding field.

The magnifying glass icon has been chosen among the icons and positions on the upper left of the Text Box.

• This formula is written into the Items property of the gallery item on the screen

Office365Users.SearchUser({searchTerm: txt_search_user})

• In order to edit the text in gallery, you can click on the Fields Edit in the window on right and edit one by one on the screen that pops up. This way, Fields like Display Name, Department and Mail can be quickly added.
• To create a one line text without an image like in the example, click Gallery and open the Display option on the menu that pops open on right and then choose Title. You can choose the Gallery display the way you want.