Power Platform Community Forum Thread Details

Hi, i have two tables like below;

Table 1 name: tblActivity_plan

project_code	activities	target
DP.2816	# of name	10
DP.2816	# of xxx	3
DP.2816	# of yyy	4
DP.2816	# of zzz	5
DP.2816	# of zzz3	5
DP.2816	# of zzz4	5
DP.2816	# of zzz5	5

Table 2 name: tblActivity_update

project_code	activities	updates
DP.2816	# of name	15
DP.2816	# of xxx	13
DP.2816	# of yyy	44
DP.2816	# of zzz	95
DP.2816	# of zzz3	75
DP.2816	# of zzz4	95
DP.2816	# of zzz5	57
CS.0000	# of name	799
CS.0000	# of yyy	878

My goal is to create a table in Gallery like below;

activities	target	updates
# of name	10	15
# of xxx	3	13
# of yyy	4	44
# of zzz	5	95
# of zzz3	5	75
# of zzz4	5	95
# of zzz5	5	57

So that, in the final output table, I want add the updates for each activities for the relevant project code.

I have a listbox named listProject which shows the project_code for selection.

I used the below code; but in my code; the first updates value is repeated in all rows.

ForAll(
    Filter(tblActivity_plan, project_code = listProject.Selected.project_code),
    {
        activities: activities,
        target: target,
        updates: Coalesce(
            LookUp(tblActivity_update, project_code = listProject.Selected.project_code && activities = ThisRecord.activities, updates),
            0
        )
    }
)



// For txtActivity
Text property of txtActivity:
ThisItem.activities

// For txtTarget
Text property of txtTarget:
ThisItem.target

// For txtAchievement
Text property of txtAchievement:
ThisItem.updates

So it gives an output like below which is not I am expecting.

project_code	activities	target	updates
DP.2816	# of name	10	15
DP.2816	# of xxx	3	15
DP.2816	# of yyy	4	15
DP.2816	# of zzz	5	15
DP.2816	# of zzz3	5	15
DP.2816	# of zzz4	5	15
DP.2816	# of zzz5	5	15