Use Search and Filter into a Gallery

(0) Share

Report

Posted on by esjimenezp

485

Hi Community,

I would like to use the function Search and Filter into a Gallery, the idea is to use a Text filter and by default into the Gallery, filtering by Priority & Value fields, I use the next formula only to filter by default in the Gallery, but the Search I don't know how to combine with the Filter function

//Search('Project Inventory', txt_SearchProjectName.Text, "ProjectName") 
Filter('Project Inventory', Priority.Value = "High", Value.Value = "High")

The Gallery works with the filter but no with the Search function, any help that would be great, thanks.

Kind regards 👋

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@esjimenezp

PowerApps executes commands from inside out. The following formula filters the datasource and reduces to a table that can be searched.

Search(
Filter(
'Project Inventory', Priority.Value = "High", Value.Value = "High"
), txt_SearchProjectName.Text, "ProjectName"
)
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@esjimenezp

If this answered your question, please mark it solved so others can find it.
esjimenezp 485 on at

Like
a
(0)

Report
Copy link

Link copied!

it works, thanks for your help @Drrickryp

Kind regards 👋