Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Missing colums from collection record

Posted on by 4
Hi Everyone!

I have a table B with a relationship to table A. I created a filter of table B and then passed the distinct lookup column (the relationship to table A) as the Items property of a gallery. The problem is that only the primary column is available as data on the gallery. So almost all the columns of table A are missing from the saved record created through the lookup column. Here is the formula I'm using:
 
Distinct(Filter(tableB, tableC.GUID = dropdown.Selected.GUID), tableAlookupcolumn)
  • Suggested answer
    KeithAtherton Profile Picture
    KeithAtherton 3,649 on at
    Missing colums from collection record
    Hey. Thanks for the follow-up. Could ShowColumns still be used like this?:
     
    Distinct(
      ShowColumns(
        Filter(
          tableB,
          tableC.GUID = dropdown.Selected.GUID
        ),
        Column1, Column2
      ),
      tableAlookupcolumn
    )
  • AM-26111532-0 Profile Picture
    AM-26111532-0 4 on at
    Missing colums from collection record
    Hi Keith! Appreciate the support.

    I can't use the show columns option since the table this formula generates returns {Value: Record}. If I use the dot to see the field it shows me the names of all the columns but if I try to use any that aren't the primary column it returns as blank
  • Suggested answer
    KeithAtherton Profile Picture
    KeithAtherton 3,649 on at
    Missing colums from collection record
    Hey. I'm not sure why that is happening, but do the columns show if you use the ShowColumns function?
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard