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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Do a search with two C...
Power Apps - Power Apps Pro Dev & ISV
Answered

Do a search with two ComboBox with data from a Sharepoint

(1) ShareShare
ReportReport
Posted on by IS-28111528-0 28
Hello, 

I will add picture off the app and the data. You can see on picture 1 (app_view) that I have 2 ComboBox that can have 1 or more value selected. ComboBox1 argument are 'W1', 'W2' and ComboBox3 are id that can be translate to Value if we use NAME.Value. 

The 2 (data) picture is the Data in my sharepoint.
 
I want that if nothing is selected in both ComboBox it show every line of my Table. And if we add selection of ComboBox only the line  where thos informations appear. 

I have two prototype of code to put in the item section of the Gallery here but none of them work :

1 : 
 
If(
    IsBlank(ComboBox1.SelectedItems) && IsBlank(ComboBox3.SelectedItems);
    'APOLLON_2025_BOOKING TS';
    If(
        !IsBlank(ComboBox1.SelectedItems) && !IsBlank(ComboBox3.SelectedItems);
        Filter(
            'APOLLON_2025_BOOKING TS';
            WEEK in ForAll(ComboBox1.SelectedItems; Value) &&
            NAME in ForAll(ComboBox3.SelectedItems; Value)
        );
        If(
            !IsBlank(ComboBox1.SelectedItems);
            Filter(
                'APOLLON_2025_BOOKING TS';
                WEEK in ForAll(ComboBox1.SelectedItems; Value)
            );
            Filter(
                'APOLLON_2025_BOOKING TS';
                NAME in ForAll(ComboBox3.SelectedItems; Value)
            )
        )
    )
)
If(
    IsBlank(ComboBox1.SelectedItems) && IsBlank(ComboBox3.SelectedItems);
    'APOLLON_2025_BOOKING TS',
    If(
        !IsBlank(ComboBox1.SelectedItems) && !IsBlank(ComboBox3.SelectedItems),
        Filter(
            'APOLLON_2025_BOOKING TS',
            WEEK in ForAll(ComboBox1.SelectedItems, Value) &&
            NAME in ForAll(ComboBox3.SelectedItems, Value)
        ),
        If(
            !IsBlank(ComboBox1.SelectedItems),
            Filter(
                'APOLLON_2025_BOOKING TS',
                WEEK in ForAll(ComboBox1.SelectedItems, Value)
            ),
            Filter(
                'APOLLON_2025_BOOKING TS',
                NAME in ForAll(ComboBox3.SelectedItems, Value)
            )
        )
    )
)


2 : 
 
Filter(
    'APOLLON_2025_BOOKING TS';
    (IsBlank(ComboBox1.SelectedItems) || WEEK in ForAll(ComboBox1.SelectedItems; Value)) &&
    (IsBlank(ComboBox3.SelectedItems) || NAME in ForAll(ComboBox3.SelectedItems; Value))
)


I stay available if you need more informations and thanks if you try help me find this solution
Categories:
Power Platform Build Tools
data.png
app_view.png
I have the same question (0)
  • Suggested answer
    CU29110135-0 Profile Picture
    CU29110135-0 4 on at
    Do a search with two ComboBox with data from a Sharepoint
    .
  • jpespena Profile Picture
    jpespena 335 on at
    Do a search with two ComboBox with data from a Sharepoint
    Hi,
     
    Try this:
      
    Filter(
    'APOLLON_2025_BOOKING TS';
    Or(
        IsEmpty(ComboBox1.SelectedItems); 
        WEEK in Concat(
           ComboBox1.SelectedItems; 
           Value;
           ', '
         )
     );
     Or(
        IsEmpty(ComboBox3.SelectedItems); 
        NAME in Concat(
           ComboBox3.SelectedItems; 
           Value;
           ', '
         )
     );
)

     
  • IS-28111528-0 Profile Picture
    IS-28111528-0 28 on at
    Do a search with two ComboBox with data from a Sharepoint
    I have tried your code but no luck there is error that I have find early and I don't realy know how to fix it without changing my data.

    I join to this message the error in Image.


    I can had that I have tree line that work seperatly but I don't find a way to put them all in once : 
     
    'APOLLON_2025_BOOKING TS' // Show all data in the Gallery
     
    Filter('APOLLON_2025_BOOKING TS'; WEEK in ForAll(ComboBox1.SelectedItems; Value)) //ComboBox1 work
    Filter('APOLLON_2025_BOOKING TS'; NAME in ForAll(ComboBox3.SelectedItems; Value)) //ComboBox3 work





    Thanks for all the help
  • WarrenBelz Profile Picture
    WarrenBelz 152,811 Most Valuable Professional on at
    Do a search with two ComboBox with data from a Sharepoint
    If you are not concerned with Delegation 
    Filter(
   'APOLLON_2025_BOOKING TS';
   (
      Len(ComboBox1.Selected.Value) = 0 ||
      WEEK in ComboBox1.SelectedItems
   ) &&
   (
      Len(ComboBox3.Selected.Value) = 0 ||
      NAME in ComboBox3.SelectedItems
   )
)
    If you want some sort of Delegation Management 
    If(
   Len(ComboBox1.Selected.Value) = 0  && Len(ComboBox3.Selected.Value) = 0;
   'APOLLON_2025_BOOKING TS';
   With(
      {
         _Data:
         If(
            Len(ComboBox1.Selected.Value) = 0;
            'APOLLON_2025_BOOKING TS';
            Ungroup(
               ForAll(
                  ComboBox1.SelectedItems As _Items;
                  Filter(
                     'APOLLON_2025_BOOKING TS';
                     WEEK = _Items.Value
                  )
               );
               Value
            )
         )
      };
      If(
         Len(ComboBox3.Selected.Value) = 0;
         _Data;
         Ungroup(
            ForAll(
               ComboBox3.SelectedItems As _Items;
               Filter(
                  _Data;
                  NAME = _Items.Value
               )
            );
            Value
         )
      )
   )
)
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • IS-28111528-0 Profile Picture
    IS-28111528-0 28 on at
    Do a search with two ComboBox with data from a Sharepoint
    Hi @WarrenBelz,
     
    I try your code there is two error of type every time I don't know how to fix them because for ComboBox1.Selected.Value it says it's waiting for a Text Value but a Record is given. See image erreur2.1

    And the secondone is also for type and it's this line :
                WEEK = _Items.Value

    on the equal signes it says that both of them needs to be of the record type I don't really understand this typing please help me if you can I can also Show the data I use if you want. See Image erreur2.2

    Thanks in adavnced.
     
  • WarrenBelz Profile Picture
    WarrenBelz 152,811 Most Valuable Professional on at
    Do a search with two ComboBox with data from a Sharepoint
    What Is the Items of the Combo Boxes ? You can go back to (which should work) 
    IsEmpty(ComboBoxName.SelectedItems)
     
  • Verified answer
    IS-28111528-0 Profile Picture
    IS-28111528-0 28 on at
    Do a search with two ComboBox with data from a Sharepoint
    This code that I find myself work thanks all :
     
    Filter(
        'APOLLON_2025_BOOKING TS';
        (
            IsEmpty(ComboBox1.SelectedItems) || WEEK in ForAll(ComboBox1.SelectedItems; Value)
        ) &&
        (
            IsEmpty(ComboBox3.SelectedItems) || NAME in ForAll(ComboBox3.SelectedItems; Value)
        )
    )
  • WarrenBelz Profile Picture
    WarrenBelz 152,811 Most Valuable Professional on at
    Do a search with two ComboBox with data from a Sharepoint
    Yes - IsEmpty works (as I posted - not sure why Len() does not work for you as I use it regularly on this control type), but what you have is still not Delegable (and you do not need the ForAll reference). This should give you some Delegation control
    If(
   IsEmpty(ComboBox1.SelectedItems) && IsEmpty(ComboBox3.SelectedItems);
   'APOLLON_2025_BOOKING TS';
   With(
      {
         _Data:
         If(
            IsEmpty(ComboBox1.SelectedItems);
            'APOLLON_2025_BOOKING TS';
            Ungroup(
               ForAll(
                  ComboBox1.SelectedItems As _Items;
                  Filter(
                     'APOLLON_2025_BOOKING TS';
                     WEEK = _Items.Value
                  )
               );
               Value
            )
         )
      };
      If(
         IsEmpty(ComboBox3.SelectedItems);
         _Data;
         Ungroup(
            ForAll(
               ComboBox3.SelectedItems As _Items;
               Filter(
                  _Data;
                  NAME = _Items.Value
               )
            );
            Value
         )
      )
   )
)
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • IS-28111528-0 Profile Picture
    IS-28111528-0 28 on at
    Do a search with two ComboBox with data from a Sharepoint
    Hi I have this error with the equal I can't find a way to fix it if it works I will use it but for now I don't find a way to get reed of it.
     
     

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
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans