PPM Express Help Center

What do you need help with?

How to set up fields mapping between PPM Express Resources and Azure Active Directory

In this article, we will review how to set up field mapping between the PPM Express Resources page and Azure Active Directory. 

To create fields mapping perform the following:

1. Establish a connection between PPM Express and Office 365. This can be done if you add the following connections to PPM Express:

When the connection is added to Planner/Teams/Office 365, your Office 365 organization will be linked to PPM Express. 


Delete

Note: It is possible to add a restricted connection. It can only be used for Azure Active Directory user and Resource synchronization or import. It still requires Admin consent, but limited permissions are used: User.Read.All and GroupMember.Read.All. This type of connection can be added only from the Import Resources page.


Next, use the 'Import Resources' option to import required Resources from your organization to the PPM Express Resources page. 


Delete

Note: Azure AD synchronization option is used to establish field mapping for the Resources that are already synchronized from Office 365 organization. It cannot be used to synchronize new Resources to the Resources page.  


Alternatively, if you have a Planner connection added, you can import plans to PPM Express and Resource assignments within each plan will be synchronized as Resources to PPM Express. 

2. Open the Tenant Settings page from the gear button and scroll down to the 'Azure Active Directory Synchronization' section. 


Delete

Note: Only users who have Administrate app permission can open and manage the tenant settings. 


3. In the Organization Name field select the organization that you need to synchronize Resources from. 

If you add several Planner/Teams/Office 365 connections from different tenants, they will all appear in the list of available organizations. 

4. Click on the Configure Fields Mapping button. 

By default, there are no fields added for mapping. If the mapping of the fields is not established in the tenant settings, only the user name and email will be synchronized to the Resources dashboard from the Azure Active Directory of the connected organizations. 

5. All fields from the Details section of the Resource dashboard can be used for mapping. You can also use/add custom fields for mapping. 


Delete

Note: PPM Express fields of the Select type can be mapped, but the value will be imported from Azure Active Directory only if it exists in the list of PPM Express field values.  


The list of Azure Active Directory fields available for mapping is fixed (all fields available on the UI if you open any Resource in AD, and some other hidden fields). Custom fields from Azure AD are not available for mapping. 

To add fields for mapping click on the Add Mapping Fields button. 

Click the Save Mapping button when you are done. 

6. Select the time and day to schedule the data synchronization. To run an on-demand data synchronization, click on the Synchronize Now button. 

It is not possible to select specific users to be synchronized from Azure AD, all users within the organization that you select will be synchronized. 

If you try to map the fields of incompatible types, a corresponding error will appear on the mapping page. 

Two fields are available on the Resources page: 'Active Directory ID' and 'Last AD sync'. You can use these fields to create a view or add them to an existing view and quickly find the information for these fields on the Resources page. 


Was this article helpful?

Table of contents

    Back To Top