Power Platform Community Forum Thread Details

Hi, I have 2 tables: testList and testLocation. In testList there is lookUp field that refers to testLocation.

I want to Collect some data from testList, but all fields that are a lookUp fields are returned as subtables.

I tried to Ungroup these, but it changes nothing. Perhaps because it is not groupped by groupBy.

How can I extract those values, so these are all accessible to me?

Categories:

Building Power Apps

Hi CU03090644-1

"Secondary" fields in Lookup columns are not compatible with Power Apps in many aspects and should not be used. You are better using AddColumns with Lookups to get those field values.

ClearCollect(
   colTestList,
   Ungroup(
      ShowColumns(
         AddColumns(
            testList,
            GroupField,
            With(
               {
                  _Fields: LookUp(
                     YourOtherList,
                     YourLookedUpField = locc.Value
                  )
               },
               {
                  Place: _Fields.place,
                  Side: _Fields.side,
                  Title: _Fields.Title
               }
            )
         ),
         Title,
         type,
         osVersion
         GroupField
      ),
      GroupField
   )
)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee