How to write expression in entra for updating Null values in Servicenow from AD

[Rini1]

Hi all,

We have an issue with null values not getting updated from AD to Servicenow. I tried looking at various articles but nothing worked out. I have no experience in writing the expression but tried updating the attribute mapping in Entra with an expression to update Null values.

Attached screenshot for reference. 

Here is the expression i.e. IsNull([mobile]) NotNull([telephonenumber]), This may not be the correct syntax. I would like to  insert expression of what to do if the attribute is not NULL.

Any guidance would be much appreciated.

Or is there any other way possible to sort this issue?

Thanks

Rini

[nizar_tliba]

Hi @Rini1,

 Please take a look to this Microsoft article: Reference for writing expressions for attribute mappings in Microsoft Entra Application Provisioning...

[Stephen Anderso]

Recommendation by Microsoft is the use the Switch function for the expression. So something like Switch([mobile],[mobile],"",[telephonenumber]) would send the default [mobile] unless the value was empty in which case it will send the [telephonenumber].