Need Help with Groupby on Lookup columns

[PAJ1999]

I have a dataverse table 

'Employee ID' column is a lookup column to the Employees table

I tried using a Groupby like this

ClearCollect(NewCollection,GroupBy(

    AddColumns('Employee Assets','_empid', 'Employee ID'.'Emp ID'),

    '_empid',

    'dataRecords'

))

But it gives something like this , 

everything inside 'dataRecords' is empty, It has 3 rows , but apart from unique identifier , there is nothing

[v-yueyun-msft]

Hi , @PAJ1999 

Which field or value you want to get in your Employees Table? The data in your "dataRecords" , what do you want to get in your side?

Best Regards,

Yueyun Zhang

[PAJ1999]

Due to urgency , I am tagging some people from whom I have recieved help many times, I hope they can help me 

@MarkJarvis , @WarrenBelz ,@Amik , @mmbr1606 , @anandm08 

[PAJ1999]

"Employee Assets" is a custom many to many table with columns Employee ID and Asset Number which act as lookup columns to their respective tables (i.e Employees and Assets). I am trying to use groupby by Employee ID , so that I can get all the assets respective to each employee. I am trying to make a accordian of nested galleries. For each asset type I want all the assets in the inner gallery.. I am trying to use groupby on Employee Assets table to seperate each allocation row by Employee Id and then by assets. 

[v-yueyun-msft]

Hi , @PAJ1999 

Thanks for your response. In my thought , you do not need to worry about the blank value in your collection.

For example , this is my Dataverse table:

Gallery1 -items:

GroupBy( AddColumns( 'Employee Assets' , '_empid' ,'Employee ID'.'Employee ID' ) ,_empid , 'dataRecords')

Label -Text in Gallery1 :

ThisItem._empid

Add a nested Gallery2-items in Gallery1:

ThisItem.dataRecords

The Label in Gallery2 you can use the expression to get the value in your "Employee Asset" Table, for example:

ThisItem.'Asset Type'

The result is like this in my here:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[PAJ1999]

Sorry but scenario has changed a bit. 

For the outer gallery instead of grouping by id , I am grouping it by Asset Type

-> GroupBy('Employee Assets',pj_assettype,GroupData)

But my GroupData is empty. 

What i want is the data inside GroupData for the sub-gallery

[v-yueyun-msft]

Hi , @PAJ1999 

Sure , this can also work in my thought. Do your "Asset type" is a Text type column in your Dataverse?

In my outer Galley1 -items:

GroupBy(  'Employee Assets' ,cr667_assettype ,GroupData )

In your Nested Gallery2 -items:
ThisItem.GroupData

Label-Text in Galley2 :

ThisItem.'Employee ID'.Name

ThisItem.LookUpColumn.'Field In Your LookupTable'

The result is like this in my side:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[PAJ1999]

What if I want something from my assets table. Employee ID is a lookup to the employees table. 

[v-yueyun-msft]

Hi , @PAJ1999 

You can directly use this expression:

ThisItem.'Your Field Name in your Employee Asset'

For example, [ID] column is in my Employee Asset:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[PAJ1999]

I tried this 

But it is empty