Expressions Azure AD - Workday to Local AD

Question

Hi everyone,

the telephone number in Workday is not written down in one field but 3. So we decided to use the join function to combine all fields.
Also the + sign is not delivered by using the "WorkphoneLandlineCountryCodeNumber"

So we tried this join command
Join("+", [WorkphoneLandlineCountryCodeNumber], [WorkphoneLandlineExtension], " ", [WorkphoneLandlineNumber])

How can the outcome of it be like this?
49+ +1234561234

There might me an error with the field extension but how can the + not be the leading sign?

Also the "test one user" is not working properly.

Information:
https://learn.microsoft.com/en-us/azure/active-directory/app-provisioning/functions-for-customizing-application-data

Best regards
Stephan

Answer 1

Hi @StephanG - your Join expression is using "+" as the separator and that's why the output has "+" signs in between.
Try this expression instead:
Join("", "+", [WorkphoneLandlineCountryCodeNumber], " ", [WorkphoneLandlineNumber], "x", [WorkphoneLandlineExtension])