ComboBox sorting based off another ComboBox selection

Like (0) Share

Report

Posted on 23 Feb 2024 03:51:10 by carrie-anne27

260

Hi all,

In the below, I am trying to get the "Catchment" to only show the "Catchments" for the selected "Service Type", "Recycled Water" in this case, however, the Service Type and Catchment are on two separate tables, but the Catchment table has an ID number for each Catchment depending on the Catchments type, for example, Recycled Water has a Catchment ID of 4, where as Sewerage Catchment ID is 3). So I guess what I am trying to do is:

If "Service Type" = "Recycled Water" then only show "Recycled Water Catchments"

These are both currently in an editable form.

Categories:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (0)

carrie-anne27 260 on 27 Feb 2024 at 23:39:08

Like (0)

Report

Re: ComboBox sorting based off another ComboBox selection

This formula doesn't work
carrie-anne27 260 on 23 Feb 2024 at 06:37:10

Like (0)

Report

Re: ComboBox sorting based off another ComboBox selection

So sorry, I forgot to say that it is in an editable form, but do you think a gallery would be a better option?
Inogic 935 Super User 2025 Season 1 on 23 Feb 2024 at 06:23:41

Like (0)

Report

Re: ComboBox sorting based off another ComboBox selection

Hi @carrie-anne27

To achieve this in Power Apps, you can use the Filter function to filter the Catchment table based on the selected Service Type.

Assuming you have a dropdown control named ServiceTypeDropdown for selecting the Service Type and a gallery control named CatchmentGallery to display the filtered catchments, you can use the following formula:
Filter(
Catchment,
Type = "Recycled Water"
)

Here Catchment is the name of your Catchment table, and Type is the column in the Catchment table that specifies the type of catchment. Replace "Recycled Water" with the actual value you're using for Recycled Water catchments if it's stored in a column.

You can set the Items property of your gallery control (CatchmentGallery) to this formula to display only the Recycled Water catchments when the Recycled Water service type is selected.

Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/