Filtering a gallery from two independent text input control?

(0) Share

Report

Posted on by Rob_CTL

Hi,

I have a gallery that is filtered from the text within text input control using the following formula.

Filter('Memberships',StartsWith(Postcode,inp_editmember_membership_search.Text)

This filter uses the "Post code" column on the SharePoint list that is providing the data. What I'd like to do is add a second text input control that will allow the user to search on the "Last Name" column. The idea is that the user can choose which criteria to search on and the gallery will filter on either box.

This is the formula I'm using but only the "Post code" box is working

Filter('Angling Memberships',StartsWith(Postcode,inp_editmember_membership_search.Text) Or StartsWith('Last Name',inp_editmember_membership_search_1.Text))

Any hints or tips gratefully received.

All responses (2)

Answers (1)

Rob_CTL on at

Like (0)

Report

Re: Filtering a gallery from two independent text input control?

Hi @Ethan_R

That's perfect, thanks!
Verified answer

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report
Re: Filtering a gallery from two independent text input control?

Hi @Rob_CTL ,

Is this you are trying to achieve?

Filter( 'Angling Memberships', (IsBlank(inp_editmember_membership_search.Text) || StartsWith(Postcode,inp_editmember_membership_search.Text)) And (IsBlank(inp_editmember_membership_search_1.Text) || StartsWith('Last Name',inp_editmember_membership_search_1.Text)) )

Hope this helps