Rule to Filter, Sort and Display Proxy Addresses as Alternate Emails

This recipe explains how to take a list of proxyAddresses from Active Directory.

For example, taking:

• SMTP:john.doe@example.com
• smtp:john.d.doe@example.com
• smtp:jdoe@example.com
• smtp:john.doe@other.com
• sip:john.doe@example.com

And displaying:

• jdoe@example.com
• john.d.doe@example.com
• john.doe@other.com

To display this way, select the Value Silo to be AD (or a connector space showing AD data), and select proxyAddresses as the multi-value attribute name.

The Value Rule accepts the list of values, and should process with List Functions it as needed for display. For example:

• Filter: Can be used to remove unnecessary addresses like SIP, X.500, and primary smtp addresses.
• Map: Can be used to reformat by removing the initial smtp:
• Distinct: Can eliminate duplicates (if present)
• SortBy: Alphabetizes the list

Example Rule:
SortBy(Distinct(Map(Filter(context, StartsWith(context, "smtp:")), ReplaceString(context, "smtp:", "")), context), context)