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).
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 .
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.
- 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 fetchDisplayName
from the Customers list)
- FullName (Title): Text column
- DisplayName: Text column
- Country: Choice column