Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jeaRUq6bbP6FxxWsoEBMOT
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 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
    14 on 20 Jan 2025 at 12:06:42
    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
    14 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,518 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,692 Most Valuable Professional

Leaderboard
Loading started