Filtering gallery with multiple dropdowns and radio buttons

(0) Share

Report

Posted on by muzamil-baxture

174

Hi,

I have a SharePoint list with different columns like Country, State, Title1 etc.., I have to filter my list with five dropdowns each for Title, Company, City, Sate, Country respectively. Also I have a radio button which has Choices type column in it. Based on these selections I have to filter my gallery also the default selected value of each dropdown should be 'All'. Below I will share the names of the Columns and controls associated with it.

Drp_title : Title1

Drp_company : Company

Drp_city : City

Drp_state: State

Drp_country : Counrty

Radio1 : Type1 (radio button , Type1 is choice column)

Name of Share Point list : 'Training Events List'

What would be the formulas I need to use?

@Drrickryp , @BCBuizer , @WarrenBelz , Hope you guys will help me

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Filter('Training Events List',
(IsEmpty(Drp_title) Or Title1 = Drp_title.SelectedItems)
And (isEmpty(Drp_company) Or Company = Drp_company.SelectedItems)
And (isEmpty(Drp_city ) Or City = Drp_city.SelectedItems )
And (isEmpty(Drp_state) Or State = Drp_state.SelectedItems )
And (isEmpty(Drp_country ) Or Counrty = Drp_country )
And (isEmpty(Radio1 ) Or Type1 in Radio1))

if multipleSelection in comboBoxes is false replace isEmpty with isBlank and Replace .SelectedItems with .Selected.Value

if this solve your problem please accept my solution,
Best Regards.

Was this reply helpful? Yes No
muzamil-baxture 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @OussamaOsman ,
Thanks for replying but the above formula isn't working. Also its giving me delegation warning.
I also need an Option of "All" in my dropdowns. Please could you re check and update me.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Radio Should be Radio1.Selected.Value if the delegation warning still appear let me know

Was this reply helpful? Yes No
muzamil-baxture 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @OussamaOsman ,
Its not working after making the above changes it says " Invalid argument type. Cannot use Text values in this context".

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You have to make the source of the radio control Choices
in the source property of the radio control
Put Choices('Training Events Lists'.Type1)

You said before that radio is a choice column so i thought you referring it source as a choice column.
If you want to keep it source as hard coded you can use "=" instead of in.

Was this reply helpful? Yes No
muzamil-baxture 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @OussamaOsman ,
I already used Choices('Training Events Lists'.Type1), for the Items property of my Radio1.
Now when I am using "=" the error says 'Incompatible types for comparison. These Cant be compared Record, Text

Was this reply helpful? Yes No
muzamil-baxture 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@OussamaOsman Please could you show me how to add "All" option for my every dropdown, it should be the default selected value of every dropdown

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

you can only add "All" if you enter the items as hard coded or from a collection, which if you do this you will pass the Incompatible types for comparison error with the same code

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
For your dropdowns, where you have Choices(.........)

replace them with:

Split(("All," & Concat( Choices([@YourDataSourceName].YourChoiceColumnName ), Value&",")), ",")

Replace YourDataSourceName and YourChoiceColumnName with your datasource name and your column name

Make sure to check/confirm that your column allows manually-entered values 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@muzamil-baxture what @iAm_ManCat suggests, works perfectly it will convert your choices to text (which remove the error) and will add the all to it.

Was this reply helpful? Yes No