Text filters not working.

%3CLINGO-SUB%20id%3D%22lingo-sub-1146823%22%20slang%3D%22en-US%22%3EText%20filters%20not%20working.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1146823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20that%20reference%20another%20table%20in%20the%20same%20document.%20This%20table%20should%20filter%20all%20items%20that%20has%20a%20certain%20value%20(%22*%22%20in%20this%20case)%20in%20a%20certain%20column.%20I%20use%20power%20automate%20to%20fill%20the%20main%20table%20of%20a%20template%20(which%20the%20filtering%20table%20references).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20filters%20i%20have%20set%20on%20the%20template%20indicate%20that%20they%20are%20active%2C%20however%20it%20seems%20to%20be%20filtering%20everything.%20to%20make%20the%20filter%20work%20as%20intended%20i%20have%20to%20manually%20open%20the%20filter%20dialog%20and%20just%20click%20accept%20without%20doing%20any%20changes%20to%20the%20filter.%20Is%20there%20a%20way%20to%20trigger%20re-applying%20the%20filter%20as%20a%20workaround%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI've%20notified%20%2F%20sent%20feedback%20about%20this%20issue%20a%20long%20time%20ago%20but%20it%20does%20not%20appear%20to%20be%20very%20high%20up%20on%20the%20agenda.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20how%20it%20looks%20in%20excel%20(app)%20but%20is%20similar%20in%20excel%20for%20web.%3CBR%20%2F%3EThe%20header%20filter%20indicator%20says%20a%20filter%20is%20active%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20155px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168514iC7991B9B57203BFC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20appears%20to%20be%20on%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20filter%20menu%20is%20not%20consistent%20with%20what%20i%20set%20the%20text%20filter%20to%20be%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168516i139BC6B931776078%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20text-filter%20is%20still%20correct%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168517i51C82FC52499D3FA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_3.png%22%20title%3D%22clipboard_image_3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EClicking%20ok%20applies%20the%20filter%20and%20its%20like%20i%20wanted%20it%20to%20be%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168519i71165EDCBA289DF6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1146823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1147964%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20filters%20not%20working.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1147964%22%20slang%3D%22en-US%22%3EOn%20the%20Data%20tab%20there%20is%20a%20reapply%20button%20to%20reapply%20the%20same%20filter%2C%20is%20that%20what%20you%20are%20looking%20for%3F%3C%2FLINGO-BODY%3E
New Contributor

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 onFilter appears to be on  

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

clipboard_image_2.png

The text-filter is still correct:

clipboard_image_3.png

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

clipboard_image_4.png

1 Reply
On the Data tab there is a reapply button to reapply the same filter, is that what you are looking for?