How to use "All" in dropdown in power apps?

(0) Share

Report

Posted on by Sebey

127

I have a list that contains list of properties. the property categorized with column category:

column category has either House or Apartment value.

I use vertical gallery to display the list.

the value of Items for the gallery is:

SortByColumns(Filter(propertylist,category.Value=Dropdown1.SelectedText.Value), "posteddate", SortOrder.Descending)

the drop-down items value: ["House","Apartment"]

This gallery displays the list of house or Apartments at a time, now i want to add All into thee drop down, so that by default the list will be all lists of houses and Apartments. expected drop down options "All","House","Apartments". when I choice All, get list of both houses and apartments.

how can i do that?

the column category in SharePoint list is a type choice with House,Apartment.

your help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Sebey ,

You need to perform two actions.

1) Add "All" as an option in your dropdown. You can achieve this either by adding an additional choice in your SharePoint list and use Sort function in the Dropdown's Item property so that "All" appear on top. Alternately, if you don't prefer adding a new choice value in SharePoint, you can append the "All" to the existing dropdown datasource by setting the Items property like this

Ungroup(
Table(
{myMenuOptions: Table({Title: "All"})},
{myMenuOptions: Choices([@'List Name'].ColumnName)}
),
"myMenuOptions"
)

2) Next you need to add a conditional filtering on your Gallery's item property

If(Dropdown1.Selected.Value = "All",'ListName',Filter('ListName',ColumnName=Dropdown1.Selected.Value))

Hope that helps!

Was this reply helpful? Yes No
Verified answer

HectorOlivos 411 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello!

You can use a ClearCollect on start

ClearCollect( CategoryOptions, { Value: "All" }, { Value: "House" }, { Value: "Apartment" } )

In the Dropdown1 items property:
CategoryOptions

Then in the gallery you can try with this:

If(Dropdown1.Selected.Value = "All", SortByColumns(propertylist, "posteddate", SortOrder.Descending), SortByColumns(Filter(propertylist, category.Value = Dropdown1.Selected.Value), "posteddate", SortOrder.Descending) )

Was this reply helpful? Yes No
Sebey 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow works!🙏

Was this reply helpful? Yes No