Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Filtering a multi select field using a combo box

(1) ShareShare
ReportReport
Posted on by 23
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 :)
  • FLMike Profile Picture
    FLMike 31,580 on at
    Filtering a multi select field using a combo box
    Hi 
     
    Sorry what ForAll I don't see that anywhere.
     
    It would be so much easier if you showed Pictures of the app, annotated what you want out of it.
     
    You are explaining things that aren't even here, nor sharing error messages, or anything.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard