I have a combobox where I want it to patch the selection into a SP list if there is a selection made. If a selection is removed (clicking the X on the selected result I want it to patch back to the SP "Available"...
I have the following line of code on the onchange property of the combobox. The problem is it only patches "Available" never the selection... I think from watching it, it runs through the code Patches the selection from the combobox then it carries on and then just patches back to "available"
Patch('SPList',ThisItem,{Spare1:If(IsBlank(ComboBox2_1.Selected.Result),"Available",ComboBox2_1.Selected.Result)})
Thanks in advance
Solved! Go to Solution.
Don't use IsBlank here use IsEmpty. Like this Example:
If(!IsEmpty(ComboBox1.SelectedItems),Collect(MyColl02,"Some" & Text(RandBetween(10,100))),Collect(MyColl02,"Zome" & Text(RandBetween(1,100))))
Here notice it works see this example where it works and knows when there's nothing or something in Combobox and reacts differently with above formula:
Don't use IsBlank here use IsEmpty. Like this Example:
If(!IsEmpty(ComboBox1.SelectedItems),Collect(MyColl02,"Some" & Text(RandBetween(10,100))),Collect(MyColl02,"Zome" & Text(RandBetween(1,100))))
Here notice it works see this example where it works and knows when there's nothing or something in Combobox and reacts differently with above formula:
| User | Count |
|---|---|
| 133 | |
| 107 | |
| 65 | |
| 43 | |
| 39 |