Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

When viewing an existing item in my form, a field appears blank even though the data exists

(1) ShareShare
ReportReport
Posted on by 14

Hi PowerApps Community,

I'm having an issue with a lookup column (Product) in my SharePoint form. When viewing an existing item in my form, the Product field appears blank even though the data exists for that item. Here's my setup:

  • I have a Product List that I use to fetch the product name under the `Title` column in my main list

 

  • Here is my main list that clearly has an existing item with a value under the product column:

 

  • When I click on this existing item, my form should show me the value "vEPC" in the Product field, but it doesn't. It shows me blank:
 
 
 
 
 
Here is my current setup for the Product combobox, and it's parent data card:
And the parent data card:
 
and the YAML code for both:
```powerapps
- Product_DataCard1:
    Control: TypedDataCard
    Variant: fluentV9ComboBoxEditCard
    Properties:
      DataField: ="Product"
      Default: =ThisItem.Product
      DisplayName: =DataSourceInfo([@'Hot Issues'],DataSourceInfo.DisplayName,Product)
      Update: |-
        ={
           Value: ProdCombo.Selected.Title,
           Id:
           LookUp(
              'Product List',
              Title = ProdCombo.Selected.Title
           ).ID
        }
      DisplayMode: =Parent.DisplayMode
      Height: =45
      Width: =576
      X: =1
      Y: =5
    Children:
    - ProdCombo:
        Control: ComboBox
        Variant: pcfdataset
        Properties:
          AccessibleLabel: =Parent.DisplayName
          DefaultSelectedItems: |-
            ={Title: ThisItem.Product.Value}
          Items: =Filter('Product List', 'Product Family' = ProdFamCombo.Selected.Value)
          Required: =Parent.Required
          ValidationState: =If(IsBlank(Parent.Error), "None", "Error")
          DisplayMode: =Parent.DisplayMode
          Width: =(Parent.Width - 48) * 0.4
          X: =DataCardKey3.X + DataCardKey3.Width
          Y: =10
        Children:
        - Title2:
            Control: PowerApps_CoreControls_ComboboxCanvasTemplate_dataField
            Variant: textualColumn
            Properties:
              FieldDisplayName: ="Title"
              FieldName: ="Title"
              FieldType: ="s"
              Order: =1

 
```
 
 
 
The weird part is that my Customer field works perfectly with almost identical configuration.  I.e. My customer field displays the existing item's Customer name:
 
```powerapps
- Customer_DataCard1:
    Control: TypedDataCard
    Variant: fluentV9ComboBoxEditCard
    Properties:
      DataField: ="CustomerName"
      Default: =ThisItem.'Customer Name'
      DisplayName: =DataSourceInfo([@'Hot Issues'],DataSourceInfo.DisplayName,'CustomerName')
      Update: |-
        ={
           Value: CustomerCombo.Selected.Title,
           Id:
           LookUp(
              Customers,
              Title = CustomerCombo.Selected.Title && Country.Value = CountryCombo.Selected.Value
           ).ID
        }
      DisplayMode: =Parent.DisplayMode
    Children:
    - CustomerCombo:
        Control: ComboBox
        Variant: pcfdataset
        Properties:
          AccessibleLabel: =Parent.DisplayName
          DefaultSelectedItems: |-
            ={Title: ThisItem.'Customer Name'.Value}
          InputTextPlaceholder: ="Find customer"
          Items: =Filter(Customers, Country.Value = CountryCombo.Selected.Value)
          Required: =Parent.Required
          ValidationState: =If(IsBlank(Parent.Error), "None", "Error")
          Width: =(Parent.Width - 48) * 0.4
          X: =DataCardKey1.X + DataCardKey1.Width
          Y: =10
        Children:
        - Title1:
            Control: PowerApps_CoreControls_ComboboxCanvasTemplate_dataField
            Variant: textualColumn
            Properties:
              FieldDisplayName: ="Title"
              FieldName: ="Title"
              FieldType: ="s"
              Order: =1
```
 

Any ideas what might be causing this? I am really struggling here and would really be grateful for anyone's help!

  • CU19111632-0 Profile Picture
    CU19111632-0 14 on at
    When viewing an existing item in my form, a field appears blank even though the data exists
    Would appreciate help on this...
  • CU19111632-0 Profile Picture
    CU19111632-0 14 on at
    When viewing an existing item in my form, a field appears blank even though the data exists
    Edit: I coincidentally discovered that ThisItem.Product.Value returns nothing, and I have that set as my DefaultSelectedItems value. Not sure what to do
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard