Forum Discussion

Ajay_Joshi's avatar
Ajay_Joshi
Brass Contributor
Dec 08, 2023
Solved

Prepend a constant value to an existing attribute EmployeeID in the Sync rule - AD Connect

We need to create a new custom attribute in Azure AD Connect for syncing, call it OneTrustEmployeeID and populate it like:- OneTrustEmployeeID = "ISO Code of Country" + EmployeeID We are getting ...
azure active directory
microsoft entra
  • Ajay_Joshi's avatar
    Ajay_Joshi
    Dec 17, 2023
    Resolved by using the following expression:-

    CStr("IN") & [employeeID]
    or
    IIF(IsNullOrEmpty([employeeID]),NULL,CStr("IN") & [employeeID])

    If concatenating a number with a String type Attribute value:-

    CStr(91) & [employeeID]
    or
    IIF(IsNullOrEmpty([employeeID]),NULL,CStr(91) & [employeeID])
Ajay_Joshi's avatar
Ajay_Joshi
Brass Contributor
Dec 17, 2023
Resolved by using the following expression:-

CStr("IN") & [employeeID]
or
IIF(IsNullOrEmpty([employeeID]),NULL,CStr("IN") & [employeeID])

If concatenating a number with a String type Attribute value:-

CStr(91) & [employeeID]
or
IIF(IsNullOrEmpty([employeeID]),NULL,CStr(91) & [employeeID])

Resources