Unanswered

Unable to Show All Possible Options from Another List When Filtering

(0) Share

Report

Posted on by CU19111632-0

Hi everyone,

I’m having an issue with my Power Apps form when trying to configure the CustomerCombo dropdown. Here’s what’s happening:

If I use the following in the Items property:

Choices([@'Operational Issues'].Customer)

It pulls all customer values from the Customers list (since .Customer is a lookup column in the Operational Issues list using the Customers list as its source).

2. However, if I try to filter the list to show only customers based on the selected country (e.g., using CountryCombo), like this:

Filter('Operational Issues', Country.Value = CountryCombo.Selected.Value)

It only shows customers who already have data in the Operational Issues list, when it should be displaying the full list of customers from that country based on the data from the Customers list .

What I need is for the CustomerCombo to:

Pull the entire list of customers from the Customers list when filtered by the selected country, and not just show me customers that only have data in my Operational Issues list
Additionally, I would like to display the DisplayName (which is a lookup column in the Operational Issues list that fetches DisplayName from the Customers list) instead of using the full Customer name.

My Operational Issues list structure:

IssueName (Title): Text column
BusinessUnit: Choice column
Country: Choice column
Customer: Lookup column (points to the Title column in the Customers list)
DisplayName: Lookup column (uses Customer column next to it to fetch DisplayName from the Customers list)

My Customers list Structure:

FullName (Title): Text column
DisplayName: Text column
Country: Choice column

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

ronaldwalcott 3,914 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Why do you believe this

However, if I try to filter the list to show only customers based on the selected country (e.g., using CountryCombo), like this:

Filter('Operational Issues', Country.Value = CountryCombo.Selected.Value)

It only shows customers who already have data in the Operational Issues list, when it should be displaying the full list of customers from that country based on the data from the Customers list .

I don't think this is true. You are using Selected which means it selects where this column has a value thus where Operational Issues has a record thus customers who are associated with the record.
CU19111632-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@ronaldwalcott

"I don't think this is true. You are using Selected which means it selects where this column has a value thus where Operational Issues has a record thus customers who are associated with the record."

Filter('Operational Issues', Country.Value = CountryCombo.Selected.Value)

This filters only the Operational Issues list. Customers not present in this list are inherently excluded.

I want show all customers from the selected country, regardless of their presence in Operational Issues list.

Choices([@'Operational Issues'].Customer) does this, but doesn't filter for selected country.
CU19111632-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Really struggling here, can anyone help?
ronaldwalcott 3,914 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Would probably be something like

Filter(Choices([@'Operational Issues'].Customer), Value = CountryCombo.Selected.Value)

depending on your control names and the combo box field configuration