web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / filter gallery on Shar...
Power Apps
Unanswered

filter gallery on SharePoint as data source multi select combo box in filter.

(0) ShareShare
ReportReport
Posted on by 2

Hi, 

 

I want to know how I can make multi select on a ComboBox in a PowerApps application on SharePoint Datasource.

If I only select on entry in the ComboBox it's working, but how to deal if i want to select multi entry in the ComboBox.

 

My SharePoint list contains more than 10000 rows

 

My ComboBox source is :

 

Item=Choices('Engagement Tracking'.'Fiscal Year')

 

This one not working on my sharepoint list to delegation issue I think

 

 

 Filter(
 'Engagement Tracking';
 And( 
 Or(
 IsEmpty('Fiscal_Year-ComboBox'.SelectedItems) || IsEmpty('Fiscal_Year-ComboBox'.SelectedItems) || 'Fiscal Year' in 'Fiscal_Year-ComboBox'.SelectedItems
 );
 BDM.Value = 'BDM-ComboBox'.Selected.Value);
 And(
 StartsWith(Customer;CustomerSearchBox.Text)
 )
)

 

 

 

And this one not working if I select more than one entry in the ComboBox

 

 

 

 Filter(
 'Engagement Tracking';
 And( 
 Or(
 IsEmpty('Fiscal_Year-ComboBox'.SelectedItems) || IsEmpty('Fiscal_Year-ComboBox'.SelectedItems) || 'Fiscal Year' = 'Fiscal_Year-ComboBox'.SelectedItems
 );
 BDM.Value = 'BDM-ComboBox'.Selected.Value);
 And(
 StartsWith(Customer;CustomerSearchBox.Text)
 )
)

 

 

 

Thank you for your help

Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,741 Super User 2025 Season 2 on at

    Hi @Julien__ 

    Set the Items property of the ComboBox : Distinct(Filter('Engagement Tracking', 'Fiscal Year' <> ""), 'Fiscal Year')

    Filter query 

    Filter( 'Engagement Tracking',

    'Fiscal Year' in ComboBox_FiscalYear.SelectedItems.Value &&

    BDM.Value = ComboBox_BDM.Selected.Value &&

    StartsWith(Customer, CustomerSearchBox.Text)

    )

    If delegation issues may still arise if the number of selected items exceeds the delegation limit. In such cases, you may need to consider alternative approaches, such as using a gallery control with checkboxes for multi-select functionality.

    Thanks!

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • Julien__ Profile Picture
    2 on at

    Thanks, it's not working due delegation.

     

    Do you have an example with checkboxes instead of Combobox?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard