ClearCollect(
colAdvFilProfile,
ShowColumns(
Filter(
colProfiles,
IsBlank(cmbFilterProfilePosition.SelectedItems) || Position in cmbFilterProfilePosition.SelectedItems,
IsBlank(cmbFilterProfileBranch.SelectedItems) || Branch in cmbFilterProfileBranch.SelectedItems,
IsBlank(cmbFilterProfileCitizen.SelectedItems) || 'Australian Citizen' in cmbFilterProfileCitizen.SelectedItems,
IsBlank(cmbFilterProfileClearance.SelectedItems) || 'Security Clearance'.Value in cmbFilterProfileClearance.Selected.Value,
IsBlank(cmbFilterProfileDomains.SelectedItems) || ForAll(cmbFilterProfileDomains.SelectedItems,Filter(colProfiles, Value in 'Skill Domain(s)'.Value))
),
ID,
'Consultant Name (Lookup)'
)
)
)


Report
All responses (
Answers (