How to collect data (field values) from a CDS lookup Field

[JasonF]

Hi Everyone,

I thought this would be simple, but apparently not. Here is scaled down version of the CDS entity structure:

I was just looking to collect the table data into a collection:

Clearcollect(SalesDetailCollect, 'Sales Detail')

However the resulting collection has no data for 'Sales Category"

Any ideas of what I am doing wrong?

Thanks in advance.

[Drrickryp · Accepted solution]

Hi @JasonF 

You can add the data in the lookup field by using the AddColumns() function.  

ClearCollect(SalesDetailCollect, AddColumns('Sales Detail',"SalesCategory",Lookup('Sales Types',SalesCategory=SalesType))

 The reference for table shaping functions is https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping 

[JasonF]

Thank You,

That works.

JasonF