Filter (with multi selected values) in PowerApps Gallery

In Microsoft PowerApps, we can use the Filter (with multi selected values) in PowerApps Gallery function to find a specific part of data that meet your need.

• The Filter (with multi selected values) function in PowerApps used to find the records of the table that adhere to a formula.
• You can use multi select filter Function to find a set of records that meet the criteria so If the condition you apply is met, so the records will be displayed otherwise, they are discarded.

Required:

• PowerApps
• SharePoint (Database)

Solution:

Now we will learn how to use the filter (with multi selected values) with the gallery control.

In this example we will filter (with multi selected values) a gallery that contain data from a SharePoint list (DemoList), and we will use text input (‘Budget Year’, Pipeline Name) and choice (Status (Budget)) columns from SharePoint to multi select filter the gallery in PowerApps.

In PowerApps Screen, place 3 combo boxes (named as CbPipelineGal, CbBudgetSheet, CbStatus).

Take a gallery control and now apply filter (with multi selected values) functionality on it by using the below code.

Code:

SortByColumns(
If(
IsBlank(txtSearch.Text),
Filter(
Or(
CbPipelineGal.Selected.Result = "All",
'Pipeline Name' = CbPipelineGal.Selected.Result
),
Or(
CbBudgetSheet.Selected.Value = "All",
IsBlank(CbBudgetSheet.SelectedItems.Value) || IsEmpty(CbBudgetSheet.SelectedItems) || "yes" in Concat(
ForAll(
CbBudgetSheet.SelectedItems.Value,
If(
Value in 'Budget Year',
"yes",
"no"
)
),
Value
)
),
Or(
CbStatus.Selected.Value = "All",
IsBlank(CbStatus.SelectedItems.Value) || IsEmpty(CbStatus.SelectedItems) || "yes" in Concat(
ForAll(
CbStatus.SelectedItems.Value,
If(
Value = 'Status (Budget)'.Value,
"yes",
"no"
)
),
Value
)
)
),
Filter(
txtSearch.Text in 'Budget Year' ||txtSearch.Text in RootId|| txtSearch.Text in 'Project Title' || txtSearch.Text in 'Status (Budget)'.Value || txtSearch.Text in 'Integrity Specialist'.DisplayName|| txtSearch.Text in 'Total Cost',
Or(
CbPipelineGal.Selected.Result = "All",
'Pipeline Name' = CbPipelineGal.Selected.Result
),
Or(
CbBudgetSheet.Selected.Value = "All",
IsBlank(CbBudgetSheet.SelectedItems.Value) || IsEmpty(CbBudgetSheet.SelectedItems) || "yes" in Concat(
ForAll(
CbBudgetSheet.SelectedItems.Value,
If(
Value = 'Budget Year',
"yes",
"no"
)
),
Value
)
),
Or(
CbStatus.Selected.Value = "All",
IsBlank(CbStatus.SelectedItems.Value) || IsEmpty(CbStatus.SelectedItems) || "yes" in Concat(
ForAll(
CbStatus.SelectedItems.Value,
If(
Value = 'Status (Budget)'.Value,
"yes",
"no"
)
),
Value
)
)
)
)
,
"ID",
If(
sorting,
SortOrder.Descending,
SortOrder.Ascending
)
)
)

Conclusion:
In this PowerApps blog, we knew about the filter (with multi selected values) in PowerApps on gallery.

=====

Plus read

Export PDF in PowerApps

Hide any SharePoint List or Library using Power Automate