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:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
180 | |
45 | |
45 | |
34 | |
34 |
User | Count |
---|---|
255 | |
82 | |
78 | |
67 | |
65 |