Hello
I am trying to create a collection, however my cmbFilterProfileDomains is a combobox and my 'Skill Domain(s)'is a multiselect choice column. I tried the below approach (the other filters work fine), but the ForAll part is erroring with the following description -The expression is intended to apply multiple filters to different tables based on selected items in various dropdown controls. The errors in the expression are due to incorrect data types being used in certain parts of the expression where Power Fx expects Boolean, Number, Decimal, Text, or UntypedObject.
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)'
)
)
)
Any suggestions on how to tackle this would be greatly appreciated :)