Ok, i managed to show data in one gallery. Now there is another problem.
For eg. Vince pat is in sales. He will get his own sales incentive. But he is also Gabriel and Anna's Team lead, so he will get 25% of their incentive. Same for John Doe. He gets his own sales and 25% of their subordinates.
let's say
Vince Patt 5000, Manager Aaron patt- 1250
Anna 10000, Manager-Vince 2500
Gabriel 5000, Manager-Vince 1250
Michelle 12000,Manager- John Doe-3000
When i click a button an email should be send which has this structure
Anna 10000
Gabriel 5000
Michelle 12000
Vince Patt-8750
John Doe-3000
Aaron patt- 1250
So, HR will know the exact incentive for a person. Otherwise she'll have to manually calculate.
Appreciate the help.
Item property of gallery:
Search(
GroupBy(
AddColumns(
Filter(
ITPathFinderSubmissionDetail,
InterviewMonthForIncentive=Dropdown2.Selected.Value &&
InterviewYearForIncentive=Dropdown2_1.Selected.Value
),
"Recruiter",
'Created By'.DisplayName
),
"Recruiter",
"DATA"
),
SearchRecruiter.Text,
"Recruiter"
)
All the number you see in picture are calculated on labels. They are not actual column in database. except for Employee name
