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.
Go to Solution.
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
View solution in original post
Check it out!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021