Answered

Creating AD user from Forms. Empty answers problem.

(0) Share

Report

Posted on by 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.

All responses (2)

Answers (1)

AgileGrrrrrg 28 on at

Like (0)

Report

Re: Creating AD user from Forms. Empty answers problem.

Worked like a charm, Cheers : )
Verified answer

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report
Re: Creating AD user from Forms. Empty answers problem.

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!

Community site session details

Creating AD user from Forms. Empty answers problem.

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Creating AD user from Forms. Empty answers problem.

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates