Hi
How do I set the value of a combo box to one of the choices in the Combo box ?
Thanks
Nigel
What you want is the second dropdown to react on the first and on the occassion that there is just one result in the second combobox you want to auto select this result. To do this do the next:
[Combo2].Items
ShowColumns(Filter(DropDown2,C1 = ComboBox1.Selected.Value1),"C2","C1")
[Combo2].DefaultSelectedItems
If(CountRows(Filter(DropDown2,C1 = ComboBox1.Selected.Value1)) = 1,First(Filter(DropDown2,C1 = ComboBox1.Selected.Value1)))
Basically you take the same filter formula from the Items part and count the rows. When this is 1 then you take the first record from the filter and set this as default. When it is not 1 then this part is in fact just false, like as you dont set a defaultselected item.
On the label (or textbox default) you can do a few things, like:
ComboBox1.Selected.Value1 & " - " & Coalesce(ComboBox1_1.Selected.C2)
Or when you don't want the minus sign to be visible this:
ComboBox1.Selected.Value1 & If(!IsBlank(ComboBox1_1.Selected.C2), " - " & ComboBox1_1.Selected.C2)
Unfortuately there is no [Combobox].CountItems on this moment, this would make this a lot easier. On the idea board there is a threat off mine on this topic, maybe you can give this kudos?
Hope this works for you.
greatings Paul
Hi,
In my screnario,
I need to get values into the dropdown from a swagger custom connetion.
Is there any way to get values from swagger into a dropdown.
i tried to get user infromation using custom connection, but here i'm trying to get more than 10 values into a dropdown using a custom swagger connection.
Please let e know if anyone have tried this.
Thanks in advance
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
196 | |
175 | |
62 | |
34 | |
32 |
User | Count |
---|---|
340 | |
271 | |
110 | |
76 | |
59 |