Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Unable to Show All Possible Options from Another List When Filtering

Posted on 22 Nov 2024 06:36:46 by 6

Hi everyone,

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

  1. 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
  • CU19111632-0 Profile Picture
    CU19111632-0 6 on 22 Nov 2024 at 10:41:09
    Unable to Show All Possible Options from Another List When Filtering
     
    "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.
  • ronaldwalcott Profile Picture
    ronaldwalcott 716 on 22 Nov 2024 at 07:01:43
    Unable to Show All Possible Options from Another List When Filtering
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,081

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard