Power Platform Community Forum Thread Details

I'm having trouble with a PowerApps form where my filtered lookup column isn't saving the selected value. Here's my setup:

I have an "Operational Issues" list with a lookup column "Customer Name" that pulls from a "Customers" list
Users need to first select a country, which should then filter the available customers in the dropdown
When adding a new record, even though I select a customer from the filtered dropdown, the value isn't being saved to the "Customer Name" column

Another screenshot

Preivous Configuration:
Here's my current Items property for the unfiltered version (which worked, but would shows all customers (200+) with no country filtering):
Choices([@'Operational Issues'].'Customer Name')

Current Configuration with Problem:
The moment I add the filter function and try to filter by country, it doesn't work. In my form, the selected customer value doesn't save to the record.
Filter('Customers',Country.Value = CountryCombo.Selected.Value)

Current Control Properties:
- Customer_DataCard1:
    Control: TypedDataCard
    Variant: fluentV9ComboBoxEditCard
    Layout: vertical
    Properties:
      DataField: ="Customer"
      Default: =ThisItem.'Customer Name'
      DisplayName: =DataSourceInfo([@'Operational Issues'],DataSourceInfo.DisplayName,'Customer Name')
      Required: =true
      Update: =CustomerCombo.Selected
      DisplayMode: =Parent.DisplayMode
      Height: =80
      Width: =582
      X: =1
    Children:
    - CustomerCombo:
        Control: ComboBox
        Variant: pcfdataset
        Properties:
          DefaultSelectedItems: =[Parent.Default]
          InputTextPlaceholder: ="Find a customer"
          Items: =Filter('Customers', Country.Value = CountryCombo.Selected.Value)
          Width: |+
            =Parent.Width -48
          X: =24
          Y: =36
        Children:
        - Title1:
            Control: PowerApps_CoreControls_ComboboxCanvasTemplate_dataField
            Variant: textualColumn
            Properties:
              FieldDisplayName: ="Title"
              FieldName: ="Title"
              FieldType: ="s"
              Order: =1

Table structures:

My Operational Issues list structure:

Issue Name (Title): Text column

Business Unit: Choice column

Country: Choice column

Customer Name (changed it from `Customer` like it says in screenshot): 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

Has anyone encountered this issue before? How can I maintain the country-based filtering while ensuring the selected customer value gets properly saved to the lookup column?

Thanks in advance for any help!

Categories:

Building Power Apps

Hi CU19111632-0

Without looking at all the column name changes (not a good idea at the best of times), the Update should be

{
   Value: CustomerCombo.Selected.Title,
   Id:
   LookUp(
      Customers,
      Title = CountryCombo.Selected.Title
   ).ID
}

and the DefaultSelectedItems

{Title: ThisItem.'Customer Name'.Value}

Also Lookup columns will continue to cause you unwanted restrictions and complexity (unless you have a specific reason for using them)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee