Combo Box if statement

(0) Share

Report

Posted on by fireflyxxoo

Hello,

I was wondering is there a possibility to include if statement in combo box.

For instance, I have a list of unique Regions and unique States. It is one to one relationship.

I created combo box where a state is dependent on a selection in the region. Thus a user can not chose a state before choosing a region.

I was wondering if I can create a function where if State is selected a corresponding Region will appear but I also want to the user to be able to select a region where a corresponding state will appear.

In the end, I want the final user be able to search based on either Region or state.

Best

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
in your region combobox put something like

Switch( statecombobox.selected.value, "Hawaii", ["Pacific"], "Texas", ["South"], Blank(), ["Pacific", "South"])

Then a similar switch in your items of state box

Could also be less typing to set these all up as a collection in the OnStart, and just reference the collection with both comboboxes

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @fireflyxxoo,

Could you please tell me which column type you choose to save the region and state, Single-line-of-text?

Here is what I got form your description:

1). Region and State has 1:1 relationship in your list

2). You want to create cascading dropodown based on this relationship

3). Either you select Region or State, another dropdown could be populated with the corresponding state or region

If the above is correct, here is a solution for your reference(Supposed to be a single-line-of-text column type).

1). Set the Region dropdown control Items property:

List.Region

2). Set the Region dropdown control Items property:

List.State

3). Set the DefaultSelectedItems(for ComboBox) as below:

If(!IsBlank(ComboBox_State.Selected.State),Filter(List,State=ComboBox_State.Selected.State).Region)//For Region ComboBox DefaultSelectedItems property
If(!IsBlank(ComboBox_Region.Selected.Region),Filter(List,Region=ComboBox_Region.Selected.Region).State)//For State ComboBox DefaultSelectedItems property

If you user a Dropdown box instead, you just need to replace the Filter() function with LookUp() function.

Was this reply helpful? Yes No