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

Like (1) ShareShare
ReportReport
Posted on 14 Jan 2025 14:59:44 by 12

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 12 on 14 Jan 2025 at 17:34:39
    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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard
Loading complete