CODEWITHSUNDEEP
powerappspowerapps-formula
Az Hughes-Jackson
Az Hughes-Jackson

Reputation: 1

PowerApps Filter Gallery and Search Function

I have a gallery which has a search box attached to it with the following formula Search('Incident Report', TextInputSearchBox.Text,"Title")

I now also now want to add the following filter function to the gallery Filter('Incident Report', Lower('Notified Users'.Email) = Lower(User().Email)

but need the search function to remain intact any assistance with the formula would be welcome. For info data is gallery data is pulling from a SharePoint list.

Upvotes: 0

Views: 3144

Answers (1)

carlosfigueira
carlosfigueira

Reputation: 87228

You can feed the result of a Search function into the Filter function (or vice-versa). In your case, it would look somewhat like the expression below:

Search(
    Filter('Incident Report', Lower('Notified Users'.Email) = Lower(User().Email)),
    TextInputSearchBox.Text,
    "Title")

or

Filter(
    Search('Incident Report', TextInputSearchBox.Text, "Title"),
    Lower('Notified Users'.Email) = Lower(User().Email))

Upvotes: 0

Related Questions