Creating AD user from Forms. Empty answers problem.

[AgileGrrrrrg]

I want new user to be created via Microsoft forms. Not all of the properties are mandatory to fill out. Like phone number for example. If the tile is left empty i get this error:

"Invalid value specified for property 'mobilePhone' of resource 'User'.",

    "details": [

      {

        "target": "mobilePhone",

        "code": "InvalidLength"

      }

I searched forum but cant find the solution.

[tom_riha · Accepted solution]

Hello @AgileGrrrrrg ,

you can try using the if(...) expression on the optional columns.

if(condition, ifConditionTrue, ifConditionFalse)

In your situation you want to check if the input from MS Forms is empty. If true, if it's empty, use the null value, if it's not empty, use the actual value from the MS Forms.

if(empty([dynamicContentFromMSForms]), null, [dynamicContentFromMSForms])

Note:
[dynamicContentFromMSForms] is a placeholder, replace it with the dynamic content from the MS Forms!

[AgileGrrrrrg]

Worked like a charm, Cheers : )