I am manipulating datasource of CDS Entity with more than 2000 records through formulas in my powerapp, however for large data source I was recommended to use collection, so I did that, but, when I do that I am unable to use fields created through relationship and metadata fields like "Created By"
These fields are always blank in collection, and therefore I am unable to use them - is there any way to add fields in collection while create them to add data from the actual data source ? Or is there any alternative way ?
It is not usually necessary to use collections for CDS entities as most functions are delegatable, even aggregating functions. delegation-of-aggregate-functions-for-cds/ . I usually just see if I can use the datasources directly and consider using collections if I run into a problem.