Powerapps - filter 2 columns at the same time

1
votes

I built gallery on oracle table and currently filtering on one column which is a primary key. I would like my app to filter on 2 columns. Double filtering on same table and 2 columns.

I tried using this and it does not work

Filter('[POC].[VIATRM_BILLING]',StartsWith(PID,TextSearchBox1_1.Text) And EndsWith(PROGRAM_ID,TextSearchBox1_1.Text))
1
powerappspowerapps-canvas
any followup questions? – Arun Vinoth

1 Answers

1
votes

Try using && instead of And (should not be a problem as both must work, I'm just curious :)).

Filter('[POC].[VIATRM_BILLING]', StartsWith(PID,TextSearchBox1_1.Text) && EndsWith(PROGRAM_ID,TextSearchBox1_1.Text))

If not, you can put multiple conditions using comma.

Filter(tablename, StartsWith(fieldname, TextInput1.Text),
                 EndWith(fieldname, TextInput1.Text)
      )

Reference