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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ethan_009 4,838 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No
Rob_CTL on at

Like (0)

Report

Hi @Ethan_R

That's perfect, thanks!

Was this reply helpful? Yes No