Forum Discussion

sanjay patnaik's avatar
sanjay patnaik
Copper Contributor
Sep 19, 2017

Modern List and Filtered View URL with ampersand issue

I got into an issue using list filtered view URL in modern site. I observed that if the filtered column value contains ‘&’ then view is not loading any items. This works fine if I convert this library to classic view.


How to reproduce this issue

  1. Create a custom Library/List in a modern site
  2. Create a list item with one of the column value( e.g. column1) value contains ‘&’ (e.g. ‘Micky & Donald’)
  3. Use the SharePoint OOTB list filter to filter the items using Column1 = ‘Micky & Donald’). This will return all the items where Column1 = ‘Micky & Donald’
  4. Get the filtered view URL from #3
  5. Either create a link in left navigation using above filter view URL or Browse that URL in a new tab or browser. This does not return any items.

 

Is this a know issue/bug?

SharePoint modern site list filtered amerpsand
    • sanjay patnaik's avatar
      sanjay patnaik
      Copper Contributor
      Sep 20, 2017

      I opened a support ticket with Office-365 team and they were able to reproduce this issue. But have not got any solution for this yet.

      • sanjay patnaik's avatar
        sanjay patnaik
        Copper Contributor
        Sep 21, 2017

        This issue is resolved now by adding a querystring parameter "useFiltersInViewXml=1" to the filter view URL . When we create a list filter view, by default there is no querystring parameter useFiltersInViewXml=1. So we need to add this parameter to make it work.

Resources