How to use filter in DataTable

[Hydrarian]

Hi there,

I'm creating a powerapp in which I want to display records of a CDS Entity. My problem is that I would like to insert InputText filters to display only some records. I tryed to use but I cannot find the correct syntax to do that. I tried Filter(DataTable1; TextInputNome.Text = cr5a8_primaryname) but it gives me syntax error.

Could you please show me some examples?

Here's what I have:

[CarlosFigueira · Accepted solution]

You're close to the solution. Instead of using DataTable1 as the first parameter of the Filter expression, you should use the name of your data source (your entity):

Filter(EntityName; cr5a8_primaryName = TextInputName.Text)

Hope this helps!

[Hydrarian]

Thank you very much Carlos, you made my day! Can I ask you also how can I show all the rows while there is no filter? And how about using multiple filter?

Thanks again for your help, I think it could be very helpful for other people also.

[CarlosFigueira]

If there is no text in that text input, then you can use the If function:

If(
    TextInputName.Text = "";
    EntityName;
    Filter(EntityName; cr5a8_primaryName = TextInputName.Text))

Or an Or expression in the filter:

Filter(EntityName; TextInputName.Text = "" Or cr5a8_primaryName = TextInputName.Text)