Modern table control not showing filtered data

(1) Share

Report

Posted on by PiebePost1

Hi,

I use a modern table control in my Power App. This table control items are filled with:

Filter(
    SortByColumns(
        'pa.vwExpeditieAppOpenstaandeBestellingen',
        "Ordernummer",
        SortOrder.Descending
    ),
    Or(
        IsBlank(txtSearch.Value),
        Ordernummer = txtSearch.Value,
        Leverancier = txtSearch.Value,
        Klantnaam = txtSearch.Value,
        OrderPartial = txtSearch.Value
        
    )
)

I have a modern textInput called txtSearch as a search box. But when I search in this field, I get all the items in the table again, while in the monitor I see that it did filter the data in the result of my monitor (see attachment). So it seems like it doesn't refresh the table items with the response of the call. Do you have any idea how this is possible?

Categories:

Building Power Apps

2024-10-02_16-58-...

I have the same question (1)

All responses (2)

Answers (1)

Verified answer

PiebePost1 61 on at

Like (0)

Report

Solved this with adding

Refresh('pa.vwExpeditieAppOpenstaandeBestellingen')

to the onChnage of the textinput. Is that the way it should work?

Was this reply helpful? Yes No
CU03101519-0 2 on at

Like (0)

Report

That works for me too. But you have to make sure you have the right Trigger output selection for the TextInput, because you may not get the expected results. E.g., if you want to see your table changes as you type, choose "Delayed" otherwise you have to focus out or click a button to see changes.

Was this reply helpful? Yes No