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:
Solved! Go to 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!
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!
Worked like a charm, Cheers : )
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
64 | |
55 | |
29 | |
27 | |
25 |