Forum Discussion

vllepa's avatar
vllepa
Copper Contributor
Mar 19, 2025

MS list filter by

I faced a problem with ms list "filter by"-search. So when I start to write text into the search field it will automatically selects the first value.

So basically the search is now almost unusable. Something must have changed as before this has been working normally and I was able to write search value and then select the values i want to be filtered. 

I created a test list to demonstrate the issue. I wrote "te" in the field and the firts value was selected automatically.

Have anyone else noticed this and is there something to do to fix it? 

 

 

microsoft lists
SharePoint Online

3 Replies

  • grant_jenkins's avatar
    grant_jenkins
    Iron Contributor
    Apr 12, 2025

    vllepaNot the best experience, I agree. This looks like what Microsoft would call a "design change". I'd call it a "regression" as it used to work much better.

    It might be worth either submitting something in the Microsoft Feedback Portal: SharePoint · Community, or an MS support ticket, but don't like your chances of getting anything changed unfortunately.

     

    EDIT: Looks like it was a regression based on this reply to another post.

    https://techcommunity.microsoft.com/discussions/sharepoint_general/filtering-autocompletes-based-on-top-result/4394982/replies/4395961

  • LucasWilson's avatar
    LucasWilson
    Iron Contributor
    Mar 31, 2025

    1.Basic Filtering Methods 
    Click on the column header in the list view → select "Filter" 
    Combine multiple conditions using "And/Or" logic 
    Click "Apply" to save the current filtered view 
    2.Advanced Filtering Techniques 
    typescript 
    // Using Filtering Formulas in List JSON Formatting 
    { 
     "$schema": "https://developer.microsoft. com/json-schemas/sp/view-formatting.schema.json", 
     "hideSelection": true, 
     "rowFormatter": { 
     "elmType": "div", 
     "style": { 
     "display": "=if([$ Status] == 'Approved', 'flex', 'none')" 
     } 
     } 
    } 
    3.Common Problems to deal with 
    Filters don't work 
    Check if the column type supports filters (calculated columns need special handling) 
    Reload the list after clearing the browser's cache 
    Verify the user's permissions (at least the "Participate in Discussions" permission is required) 
    4.Filtering Across Lists 
    Create an association flow using Power Automate Create a Linked Flow: 
    powershell 
    Connect-PnPOnline -Url "https://tenant.sharepoint.com"
    Add-PnPFlow -Name "CrossListFilter" -DefinitionPath "C:\flow.json" 
    5. Professional level solution 
    REST API Filter 
    http 
    GET https://{site_url}/_api/web/lists/getbytitle('ListName')/items? $filter=Status eq 'Active' 
    6.Graph API Query 
    powershell 
    Invoke-RestMethod -Method Get -Uri "https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$filter=fields/Status eq 'Approved'"

Resources