[SUPPORT TIP] How to manipulate the email suffix on Primary SMTP proxyAddress

Hello Again,

GOAL

Modify the primary SMTP Email Suffix within the ProxyAddresses attribute.

The challenge here is to be able to loop through the proxyAddresses collection and modify a single piece of information on a single line item in the proxyAddresses collection.

I was able to accomplish the given task through the following steps.

1. Open the Synchronization Rules Editor and select Inbound Rules
2. Click Add New Rule button
   1. DESCRIPTION TAB
      1. Name and Description fields are your discretion as to how you wanted to name the rule. For this example I called my rule "In from AD - Updating Primary SMTP ProxyAddresses" with the Description "Will modify the primary SMTP proxyAddresses email suffix"
      2. Connected System = On-Premise Active Directory Connector
      3. Connected System Object Type = User
      4. Metaverse Object Type = Person
      5. Link Type = Join
      6. Precedence = 119 (This is just where I set the precedence.       Please review the below link to discover where it is best fired for you.
         • NOTE: Discover more information on Synchronization Rule Precedence here: Understanding the default configuration: https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnectsync-understanding-default-configuration/
      7. Tag
      8. Enable Password Sync = Not Checked
      9. Disabled = Not Checked
3. SCOPING FILTER: Determine if you need a Scoping Filter based on your business rules
4. JOIN RULES: Determine if you need Join Rules based on your business rules
5. TRANSFORMATIONS:  

   1. Click Add Transformations

   2. Flow Type = Expression

   3. Source = IIF(InStr([proxyAddresses],"SMTP:",1,vbBinaryCompare)>0,Word([proxyAddresses],1,"@") & "@newcontoso.com",[proxyAddresses])

   4. Apply Once = Not Checked

   5. Merge Type = Update

      Here is how the transformation may look in PowerShell.

      

6. TESTING
   1. If you utilize the Preview feature of Azure AD Connect, then Commit the Preview instead of Generating the Preview
   2. Once you Commit the Preview, then review the actual Metaverse Object

AADConnect Additional Resources

• AADConnect Understanding the default configuration: https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnectsync-understanding-default-configuration/