Hello,
I am new to PowerApps, and I am building a referral application. I have a gallery (sorted/filtered) with all the referral information. I would like to have a checkbox above the gallery and on checking it should display any duplicate Candidate email id's in the gallery (data stored in SP)
Code in the gallery items property
LastN(
FirstN(
Sort(
Filter(
Employee_Input,
SearchBox_4.Text in Emp_Name||SearchBox_4.Text in Dept||SearchBox_4.Text in Employee_Mail_ID||SearchBox_4.Text in Candidate_Name
), ID, SortOrder.Descending),
drpDownPagi_ES_1.SelectedText.Value * varPageNumberES),
drpDownPagi_ES_1.SelectedText.Value * 1)
CandidateEmail is a new column in SP. When someone sends a referral, they will add the Candidate's Email. Selecting the checkbox will highlight if 2 people have referred the same candidate. I don't know how to achieve this. Appreciate the help.