Power Platform Community Forum Thread Details

Hi,

I have two dataverse tables linked by a lookup column.

The first is a users table. The second a points table.

I want to create a collection of users with an added column of total points per person.

ClearCollect(
Totals,
AddColumns(
BSKL_Users,
"Total",
Sum(
Filter(
'Point Transactions',
'Student ID'.ID = selectedUser.ID
),
'Earned points'
)
);

This code should work; however, it produces a 'The specified column cannot be accessed in this context'. Could someone help me overcome this error?

Thank you in advance

Categories:

Combing dataverse tables with a sum filter option on a lookup column - over coming the 'Specified column cannot be accessed'