Missing colums from collection record

(1) Share

Report

Posted on by AM-26111532-0

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey. I'm not sure why that is happening, but do the columns show if you use the ShowColumns function?

More info: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-shaping#syntax

Was this reply helpful? Yes No
AM-26111532-0 4 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

)

Was this reply helpful? Yes No