Hello
I have below Nested if conditions applied on a Combobox, which I feel is right. I still get sysntax error (IF has invalid arguments)
DefaultSelectedItems=
If(SharePointForm1.Mode = FormMode.New,If(DataCardValue17.Value = true || DataCardValue16.Value = true ,["No"],["NA"]),Parent.Default)
If I just put inner If condition, it works fine
DefaultSelectedItems = If(DataCardValue17.Value = true || DataCardValue16.Value = true ,["No"],["NA"])
However, I want formula to run, only on NEWFORM and not edit. Any suggestions please?
Solved! Go to Solution.
Never mind, seems there is diffrent way to set Combobox value with conditions. Below is correct sysntax
If(SharePointForm1.Mode = FormMode.New,If(DataCardValue17.Value = true || DataCardValue16.Value = true ,{ Value: "No" },{ Value: "NA" }),Parent.Default)
This article explains these scenarios better.
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Never mind, seems there is diffrent way to set Combobox value with conditions. Below is correct sysntax
If(SharePointForm1.Mode = FormMode.New,If(DataCardValue17.Value = true || DataCardValue16.Value = true ,{ Value: "No" },{ Value: "NA" }),Parent.Default)
This article explains these scenarios better.
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
User | Count |
---|---|
126 | |
87 | |
84 | |
75 | |
69 |
User | Count |
---|---|
214 | |
179 | |
139 | |
105 | |
83 |