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:
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
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.