ComboBox sorting based off another ComboBox selection

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Inogic 1,217 Moderator on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
carrie-anne27 260 on at

Like (0)

Report
Copy link

Link copied!

So sorry, I forgot to say that it is in an editable form, but do you think a gallery would be a better option?

Was this reply helpful? Yes No
carrie-anne27 260 on at

Like (0)

Report
Copy link

Link copied!

This formula doesn't work

Was this reply helpful? Yes No