Need Help with Groupby on Lookup columns

(0) Share

Report

Posted on by P1999

145

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

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P1999 145 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P1999 145 on at

Like
a
(0)

Report
Copy link

Link copied!

"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.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P1999 145 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P1999 145 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P1999 145 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried this
But it is empty

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PAJ1999

Dose the [Serial Number] in your "Emploee Asset" Table? I could not see it in your screenshot.

And what's the data type of your [Serial Number] column?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No