Forum Discussion

Hjalmar Otto Fjøsne's avatar
Hjalmar Otto Fjøsne
Copper Contributor
Feb 02, 2020

Text filters not working.

I have a table that reference another table in the same document. This table should filter all items that has a certain value ("*" in this case) in a certain column. I use power automate to fill the main table of a template (which the filtering table references). 

 

The filters i have set on the template indicate that they are active, however it seems to be filtering everything. to make the filter work as intended i have to manually open the filter dialog and just click accept without doing any changes to the filter. Is there a way to trigger re-applying the filter as a workaround?


I've notified / sent feedback about this issue a long time ago but it does not appear to be very high up on the agenda.

This is how it looks in excel (app) but is similar in excel for web.
The header filter indicator says a filter is active:

Filter appears to be on  

The filter menu is not consistent with what i set the text filter to be

The text-filter is still correct:

Clicking ok applies the filter and its like i wanted it to be:

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    On the Data tab there is a reapply button to reapply the same filter, is that what you are looking for?

Resources