EntraId to SuccessFactors Writeback | Add leading zeros

Wieland, Sebastian 20 Reputation points
2024-05-07T08:59:26.06+00:00

Hi all,

we are using the Entra ID Provisioning Service Writeback to send Email and Phone Number to SuccessFactors.

However, we are struggeling with matching IDs on both sides.
We are using the a userID in extensionAttribute14 in AD, consisting of 3-5 numbers. On SF side this ID is also used, however there it is filled with leading zeros to have an 8 digit ID (necessary for downstream systems).

AD: 12345

SF: 00012345

It always have to be exactly 8 characters. The Ids can also contain 0, so removing all 0 is not an option (like 12305).

Is there a way to use Expressions to still be able to match those userIds?
Any ideas would be highly appreciated!

I tried using REGEX by using the Replace expression, but can't get it to work. For example:

Replace(Append("0000000",[extensionAttribute14]), ,"\d{0,8}$", ,"", ,)
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,629 questions
{count} votes