January 6, 2020

Retrieve User Profile information from Delve using Office 365 Connector in Power Apps

Introduction:
We have come across with specific requirement to fetch User Profile properties from Delve for the specific user, by having a custom People Picker in Power Apps - Canvas App.

Please refer to this article for creating Custom People Picker.

The expected end result is as follows, where the current logged-in user will search for the Employee using email ID and Delve Profile information will be displayed in the App.

So, now let’s start the development process to fulfill the requirement.

A. Create a Template to display User Profile Information:
1. In this App. we are displaying the following Delve properties to the end-user.
  • Name
  • Reports to Manager
  • Department
  • Designation
  • About
  • Previous Projects
  • Employee Photo

2. To display the information, we will use Labels and Image controls in Power Apps.



B. Configure properties to fetch infromation:
3. Once template is created, we need to configure the properties for each control. Please find the below table showing all the information which are mapped for each control.
Property Name
Event for the Selected Property
Formula/ Text/URL
Name
Text
If(IsBlank(SelectedUserEmail),"",Office365Users.UserProfileV2(SelectedUserEmail).displayName)
Reports To
Text
If(IsBlank(SelectedUserEmail),"",Office365Users.ManagerV2(SelectedUserEmail).displayName)
Department
Text
If(IsBlank(SelectedUserEmail),"",Office365Users.UserProfileV2(SelectedUserEmail).department)
Designation
Text
If(IsBlank(SelectedUserEmail),"",Office365Users.UserProfileV2(SelectedUserEmail).jobTitle)
About
Text
If(IsBlank(SelectedUserEmail),"",Office365Users.UserProfileV2(SelectedUserEmail).aboutMe)
Previous Projects
Text
Office365Users.UserProfileV2(SelectedUserEmail).pastProjects.Value
Profile Image
Image
If(IsBlank(SelectedUserEmail),"",Office365Users.UserPhotoV2(SelectedUserEmail))
          **Please refer references section for the other User Properties.

4. Once the properties are configured, let’s check the output. Search for the user and select value from the suggestion box.
And here it is!! The output will be shown in the following screen.

References:
Below is the list of the functions of Office 365 Users.
  • Office365Users.DirectReportsV2
  • Office365Users.ManagerV2
  • Office365Users.MyProfileV2
  • Office365Users.MyTrendingDocuments
  • Office365Users.RelevantPeople
  • Office365Users.SearchUsers
  • Office365Users.TrendingDocuments
  • Office365Users.UserPhotoV2
  • Office365Users.UserPhotoMetadata
  • Office365Users.UserProfileV2

Below is the list of properties which we can get using a user’s email.
  • Office365Users.UserProfileV2(SelectedUserEmail).aboutme
  • Office365Users.UserProfileV2(SelectedUserEmail).accountEnabled
  • Office365Users.UserProfileV2(SelectedUserEmail).birthday
  • Office365Users.UserProfileV2(SelectedUserEmail).bussinessPhones
  • Office365Users.UserProfileV2(SelectedUserEmail).city
  • Office365Users.UserProfileV2(SelectedUserEmail).companyName
  • Office365Users.UserProfileV2(SelectedUserEmail).country
  • Office365Users.UserProfileV2(SelectedUserEmail).department
  • Office365Users.UserProfileV2(SelectedUserEmail).displayName
  • Office365Users.UserProfileV2(SelectedUserEmail).givenName
  • Office365Users.UserProfileV2(SelectedUserEmail).hireDate
  • Office365Users.UserProfileV2(SelectedUserEmail).id
  • Office365Users.UserProfileV2(SelectedUserEmail).interests
  • Office365Users.UserProfileV2(SelectedUserEmail).jobTitle
  • Office365Users.UserProfileV2(SelectedUserEmail).mail
  • Office365Users.UserProfileV2(SelectedUserEmail).mailNickname
  • Office365Users.UserProfileV2(SelectedUserEmail).mobilePhone
  • Office365Users.UserProfileV2(SelectedUserEmail).mySite
  • Office365Users.UserProfileV2(SelectedUserEmail).officeLocation
  • Office365Users.UserProfileV2(SelectedUserEmail).pastProjects
  • Office365Users.UserProfileV2(SelectedUserEmail).postalCode
  • Office365Users.UserProfileV2(SelectedUserEmail).prefferredLanguage
  • Office365Users.UserProfileV2(SelectedUserEmail).responsibilities
  • Office365Users.UserProfileV2(SelectedUserEmail).schools
  • Office365Users.UserProfileV2(SelectedUserEmail).skills
  • Office365Users.UserProfileV2(SelectedUserEmail).state
  • Office365Users.UserProfileV2(SelectedUserEmail).streetAddress
  • Office365Users.UserProfileV2(SelectedUserEmail).surname
  • Office365Users.UserProfileV2(SelectedUserEmail).userPrincipleName
  • Office365Users.UserProfileV2(SelectedUserEmail).userType


If you have any questions you can reach out our SharePoint Consulting team here.

January 3, 2020

How to hide the Filter Pane in published version of Power BI Report?

Problem Statement:
We know that the Filters are very important feature of Power BI desktop. Sometimes, as a developer, we use the functionality of the filter at the visual level, page level, and report level to set the required business logic.

When we publish the Power BI report to the service, at that time, the Filter Pane is clearly visible to end-users. If the filter is not in the locked stage, then end-users can easily change the value of the filters which we have applied to set the business logic. This may spoil the data for the visualization we have configured.

In order to overcome this situation, we can hide the Filter Pane from the published version of the Power BI report. Now, let’s see how we can easily hide the Filter Pane from the Power BI Online/Service.

Solution:
Step 1:
Open the Power BI Report in Power BI Desktop. When we create any Power BI report, the filter pane is opened in the right side of the screen.
Step 2:
To hide the Filter Pane from the published version of the Power BI Report, click on the Hide icon from the filter pane.

Once, we click on the “Hide” icon, the icon will be changed as shown in the following screen.

Step 3:
Publish the Power BI Report, the Filter Pane is now hidden from the Power BI Service.

Conclusion:
This is how, we can easily hide the filter pane from the Power BI Online. Isn’t it amazing??
Stay connected with us for more articles!!

Happy Reporting!!

If you have any questions you can reach out our SharePoint Consulting team here.

December 30, 2019

How to build a Custom People Picker in Power Apps

In Power Apps - Canvas App, we came across the specific requirement to have a custom people picker where user can search employees by its name and associated email-id should be displayed in the drop-down.

We know, Power Apps doesn’t provide any OOTB people picker without Form control. That’s why we need to build a custom people picker in our App. So, let start creating the custom people picker in Power Apps.


A. Create Custom People Picker:
Please follow the below steps to create our own custom people picker with the suggestion box.

  1. Add Data Source. To add the data source, Go to the View menu and then select Data Sources option.

  2. Click on “Office 365 Users” for adding the Data Source.
                         

  3.  Now, add  List Box” and “Text Input” Control.
    • To add List Box click on “Insert” then on “Controls” -> “ListBox

    • To add Text Box click on “Insert” then in “Text” select “Text Input”.
  4. Select the Textbox control which we have added in Step 3 and configure the following properties.
    • Text Box
      • Default: SelectedUserEMail
      • OnSelect: Set(UsersListBox,true)
    • List Box
      • Items: If(!IsBlank(TextInput2.Text), Office365Users.SearchUser({searchTerm:TextInput2}).Mail)
      • Visible: UsersListBox
      • OnSelect: Set(SelectedUserEmail, ListBox1.SelectedText.Value); Set(UsersListBox,false);Reset(TextInput2)

Now, let’s test our custom people picker!
  • Search for the Employee name in textbox of Custom people picker.
  • It will show the email-id property of that user in the suggestion box. Currently, we have displayed only “Email Property” in the combo box. However, we can show the other Office 365 properties as well.

If you have any questions you can reach out our SharePoint Consulting team here.