cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amalinabaha
Frequent Visitor

Filtering multi combo box (2 combo box with multi choice selection) + combo box for date range + search box

Hi,

How to filter 4 sets of combo box which 2 of them are  combo boxes with multiple choice selection and the remaining is set of data range + 1 search box

 Screenshot_3.png

I have tried one formula in my table items and it is workable. However, I don't know how to combine all the formula as below:

Formula 1 - tested alone and it works

Filter('Test - Incident and Non-Conformance',
Or( IsBlank(ComboBoxRisk_1.SelectedItems),
IsEmpty(ComboBoxRisk_1.SelectedItems),
true in ForAll(ComboBoxRisk_1.SelectedItems,ThisRecord.Value in Risks.Value)
)) 

add

Formula 2

Filter('Test - Incident and Non-Conformance',
Or( IsBlank(ComboBoxStatus_1.SelectedItems),
IsEmpty(ComboBoxStatus_1.SelectedItems),
true in ForAll(ComboBoxStatus_1.SelectedItems,ThisRecord.Value in Status.Value)
)) 

add

Formula 3

‘Due date’ >=dpFromSP.SelectedDate && ‘Due Date <=dpToSP.SelectedDate

add

Formula 4

 txtRef.Text in Title

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
amalinabaha
Frequent Visitor

Finally it works, but with delegation remark

 

Filter(

    'Test - Incident and Non-Conformance',

    IsBlank(ComboBox1.Selected.DisplayName) || IsEmpty(ComboBox1.Selected.DisplayName) ||'Name of Action Party'.DisplayName= ComboBox1.Selected.DisplayName,

    IsBlank(ComboBoxStatus_1.SelectedItems.Value) || IsEmpty(ComboBoxStatus_1.SelectedItems.Value) ||'Status of Action'.Value in ComboBoxStatus_1.SelectedItems.Value,

    Or( IsBlank(ComboBoxRisk_1.SelectedItems),IsEmpty(ComboBoxRisk_1.SelectedItems),true in ForAll(ComboBoxRisk_1.SelectedItems,ThisRecord.Value in Risks.Value)),

    'Date of Report'>=dpfrom.SelectedDate && 'Date of Report'<=dpend.SelectedDate

)

View solution in original post

6 REPLIES 6
Drrickryp
Super User
Super User

@amalinabaha 

Give this a try and check your capitalization for 'Due date' vs 'Due Date'

 

Filter('Test - Incident and Non-Conformance',
 Or(CountRows(ComboBoxRisk_1.SelectedItems)=0,
    Risks.Value in ComboBoxRisk_1.SelectedItems
  ) && 
Or(CountRows(ComboBoxStatus_1.SelectedItems)=0,
   Status.Value in ComboBoxStatus_1.SelectedItems
 ) && 
‘Due Date’ >= dpFromSP.SelectedDate && ‘Due Date <= dpToSP.SelectedDate && 
txtRef.Text in Title
) 

 

 

 

amalinabaha
Frequent Visitor

Hi @Drrickryp 

 

Thank you, but somehow not working.

amalinabaha
Frequent Visitor

I have tried using below, but it is not working

 

Screenshot_4.pngScreenshot_5.png

amalinabaha
Frequent Visitor

Finally it works, but with delegation remark

 

Filter(

    'Test - Incident and Non-Conformance',

    IsBlank(ComboBox1.Selected.DisplayName) || IsEmpty(ComboBox1.Selected.DisplayName) ||'Name of Action Party'.DisplayName= ComboBox1.Selected.DisplayName,

    IsBlank(ComboBoxStatus_1.SelectedItems.Value) || IsEmpty(ComboBoxStatus_1.SelectedItems.Value) ||'Status of Action'.Value in ComboBoxStatus_1.SelectedItems.Value,

    Or( IsBlank(ComboBoxRisk_1.SelectedItems),IsEmpty(ComboBoxRisk_1.SelectedItems),true in ForAll(ComboBoxRisk_1.SelectedItems,ThisRecord.Value in Risks.Value)),

    'Date of Report'>=dpfrom.SelectedDate && 'Date of Report'<=dpend.SelectedDate

)

Drrickryp
Super User
Super User

@amalinabaha 

The operator "in" will always give a delegation warning with SharePoint.

Hi @Drrickryp ,

 

Any suggestion to replace "in"?

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,515)