Putting table records into a collection

[avankosky]

Hello all,

I am trying to filter a table an put the results into a collection like:

Collect(CollectionName, Filter(TableName, criteria))

However the resulting collection table only contains the ids of the results returned, not the records themselves.  Looking at the documentation here: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-clear-collect-clearcoll... I understand you can put 'records' into a table by using the correct syntax, but can you not do this with table records returned by a filter?  Is this a limitation of the Collect function or am I doing something wrong?  

Thank you in advance to everyone who has a look.

Aaron

[CNT]

@avankosky This could be due to the "Explicit Column Selection" Setting.

You could disable this setting (but that's not recommended as this is in Preview and soon will become part of the core and therefore non-optional). But you could just turn it off and see if this is the source of the problem.

A workaround for this would be to wrap the Filter with ShowColumns.

ShowColumns(Filter(.......), "Column1", Column2",.........)

Please remember to give a 👍 and accept my solution as it will help others in the future.

[avankosky]

Thank you for the reply.  I understand your suggestion about wrapping the Filter in a show columns, but using this method I am just building a table in the collection using the properties of the objects returned by the filter, not putting the records returned by the filter into a table.

I am trying to get this:

CollectionTable

Record1

Record2

Your suggestion gives me this:

Name	Price	Description
Record1.Name	Record1.Price	Record1.Description
Record2.Name	Record2.Price	Record2.Description

Is what I am trying to get in the first table possible?  Can I put records retrieved from a filter (or lookup or search) into a collection as the full records themselves without having to recreate their structure in the collection table?

The reason I ask this that that further along in my app workflow I need to filter a different table based on an object related to the records in the first table like Record1.RelatedObject.Property.  I have an idea for a workaround, but it would just be easier if I had access to the first subset of records.  

This is my first crack at Power apps coming from the world of Object relational mapping and dotted notations.  So I am trying to wrap my head around the object hierarchy limitations.

Thank you again to the community for their assistance.

Aaron

[catra_does_pw]

Hi Aaron, I know it may be a little too late, but I think I have a solution 

I have a list that has a column type person  

this code 

ClearCollect(RecordCollection, ForAll('Microsoft_List' As MyItem, {Records: MyItem.column_Person.));

stores the different records as a table 
try it and tell me if it works for you!