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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to filter with com...
Power Apps
Answered

how to filter with combobox multi-select

(0) ShareShare
ReportReport
Posted on by JACK_LAI_1117 267

HI ALL

Annotation 2020-08-10 114700.jpg

 

This is my PowerApps UI , the data table "items" with this formula . But my boss ask me to let him select two values in combo box then the data table will show info in this condition ~~

 

How do adjustment in the formula to finish this job ????

 

Annotation 2020-08-10 115021.jpg 

Categories:
Building Power Apps
  • WarrenBelz Profile Picture
    WarrenBelz 156,545 Most Valuable Professional on at

    Hi @JACK_LAI_1117 ,

    I have not looked at the logic of your date filters, but if you change the Combo Box Department_manager_query_subordinate to Multi-select, this should work for you 

    Filter(
 [@APP1],
 Value(
 Left(Title,8)
 ) >= 
 Value(
 Text(Departmentmanagerquerystartdate.SelectedDate,"[$-en-US]yyyymmdd")
 ) && 
 Value(
 Left(Title,8)
 ) <= 
 Value(
 Text(Department_manager_query_end_date.SelectedDate,”[$-en-US]yyyymmdd")
 ) && 
 user_email in Department_manager_query_subordinate.SelectedItems
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • JACK_LAI_1117 Profile Picture
    JACK_LAI_1117 267 on at

    @WarrenBelz 

     

    Thank you for your replay , after I modify my formula , it still not work .

     

    In combobox , I can choose more than one user , but the data table only show last one user info  , I will still try other method to solve my question ~~~

  • WarrenBelz Profile Picture
    WarrenBelz 156,545 Most Valuable Professional on at

    @JACK_LAI_1117 ,

    That formula should work if your combo box Department_manager_query_subordinate contains multiple email addresses, however  one thing I noticed is that you are comparing it to a variable user_email. How is this set and is it the email of the current user?

    If so, there will only ever be one match in the drop-down. What are you wanting to compare with the the emails in the drop-down to get the multiple records?

     

     

  • JACK_LAI_1117 Profile Picture
    JACK_LAI_1117 267 on at

    @WarrenBelz 

     

    In combobox , it will show a lot of employee email address , then my boss will select which employee he want to look at .......if my boos pick up two employee email address ,the data  table will show those two employee info ,like male or female......tel number ......birthday .....like so no ~~~

     

    right now ,it just show the last select employee info in data table not all selected employee !!!

  • WarrenBelz Profile Picture
    WarrenBelz 156,545 Most Valuable Professional on at

    @JACK_LAI_1117 ,

    Is user_email a field in the list APP1? If so try this

    Filter(
 [@APP1],
 Value(
 Left(Title,8)
 ) >= 
 Value(
 Text(Departmentmanagerquerystartdate.SelectedDate,"[$-en-US]yyyymmdd")
 ) && 
 Value(
 Left(Title,8)
 ) <= 
 Value(
 Text(Department_manager_query_end_date.SelectedDate,”[$-en-US]yyyymmdd")
 ) && 
 Department_manager_query_subordinate.SelectedItems in user_email
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • JACK_LAI_1117 Profile Picture
    JACK_LAI_1117 267 on at

    @WarrenBelz 

     

    YES , user_email is a field in my share-point list 

     

    this is my combobox formula 

     

    Annotation 2020-08-10 154951.jpg

     then I use your formula in my data table , after I input in my formula , it showed error 

     

    Annotation 2020-08-10 155243.jpg

     

    Annotation 2020-08-10 155352.jpg

        

        I think it may cased by combobox setting .......but I do know how to deal with , so ...........I really thank for your help !!!!

     

  • Verified answer
    JACK_LAI_1117 Profile Picture
    JACK_LAI_1117 267 on at

    @WarrenBelz 

     

    After try and try again , finally I found answer......

     

    in combobox formula :

    Sort(getsubordinate,Result,Ascending)

    螢幕擷取畫面 2020-08-10 222216.jpg

     

    in dtat table formula :

    Filter(APP1, Value(Left(Title,8))>=Value(Text(Department_manager_query_start_date.SelectedDate,"[$-en-US]yyyymmdd"))&&Value(Left(Title,8))<=Value(Text(Department_manager_query_end_date.SelectedDate,"[$-en-US]yyyymmdd")) && user_email in Department_manager_query_subordinate.SelectedItems )

    螢幕擷取畫面 2020-08-10 222420.jpg

     

    After this , I choose more than one person , the person's info will show in data table ~~~~

     

    YES , I complete it !!!

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 156,545 Most Valuable Professional on at

    @JACK_LAI_1117 ,

    Your final formula

    Filter(
 APPl,
 Value(Left(Title,8))>=
 Value(Text(Department_manager_query_start_date.SelectedDate,"[$-en-US]yyyymmdd"))&&
 Value(Left(Title,8))<=
 Value(Text (Department_manager_query_end_date.SelectedDate,"[$-en-US]yyyymmdd")) && 
 user_email in Deportment_manoger_query_subordinate.Selectedltems 
)

    is exactly what I provided - you have marked you own post as the solution. You might consider correcting this.

     

  • JACK_LAI_1117 Profile Picture
    JACK_LAI_1117 267 on at

    @WarrenBelz 

     

    Yes , the formula that you provide is the correct answer for me , I just set your reply as a solution .

    In this period , thank you to take care my problem .

     

    👍👍👍👍👍

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans