SP2013 Not all list views showing in Selected View dropdown

Question

I have an issue in Sharepoint 2013. This is the situation. You create a (wiki)page that shows the web part of a list (in my case a calendar list). If you edit the web part, you get the option to select another list view from a drop-down menu titled 'Selected View' (marked in red in the image below). Normally this works fine, but if you have too many list views on the same list, it seems the drop-down menu only shows a limited amount (in my case 47 custom made views and 5 of the standard views). Is there a possibility to show all possible list view in the drop-down or to select the desired view in any other way?

Any help is deeply appreciated.

Answer 1

I've not encountered this issue before, but I don't think I've encountered a list with over 50 public views either.

You may also want to consider just using either a content query web part or search webpart and customize your view from there. You then have flexibility in using XSLT or display templates. You can still link back to the actual calendar list view for users that want to use the published view types.

Back to your specific request. One method I can think of is setting it via PowerShell

Disclaimer: I pulled this together from some older scripts I had but have not had a change to validate it directly - may need slight adjustments.

 $web = Get-SPWeb "https://<My Site URL>"  #web where page lives   
 $page = $web.GetFile("Pages/default.aspx")  #page where webpart lives
 $page.CheckOut()  
 $webpartmanager = $web.GetLimitedWebPartManager("Pages/default.aspx", [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)    

for($count=0;$count -lt $webpartmanager.WebParts.Count;$count++)  {   

    if($webpartmanager.WebParts[$count].title -eq "Calendar"){    #change this to your webpart title
        $wp=$webpartmanager.WebParts[$count];  
        $wp.ViewId=<view ID number>;  
        $webpartmanager.SaveChanges($wp);  
        break;   
    }   
}

$page.CheckIn("Relevant Articles")  
$page.Publish("Relevant Articles")  
$web.Update();   
$web.Dispose();  

You should be able to get reference to your webpart and export the ID's available, the trick part is correlating them back to your actual list view page.

Answer 2

It seems that the List View Web Part is limited to 50 views appearing in the Selected View drop-down field. See the Tech Net discussion thread Dashboard (web part) pages - cannot add view to web part and also see Not all views being displayed in my web part. It sounds like this limit is not well-documented, though.

You can use the Edit the current view to create the view you'd like to show in the List View Web Part on-the-fly, but obviously this isn't as convenient as being able to select the view you already created.

Answer 3

Another possible work-around if all you are displaying on the wiki page is the filtered view of the list:

You could instead use some URL hacking to link to a single view of the list, but filtered for the device value. You can get an idea of what the URL should be if you go to the view, filter the device column from the column header, and then use the URL generated. It will look something like this:

http://yourserver/sites/yoursite/Lists/yourlist/AllItems.aspx#InplviewHash48c2b48d-18df-4b25-bc3c-0e94bcd91266=InitialTabId%3DRibbon%252ERead-VisibilityContext%3DWSSTabPersistence-FilterField1%3DDevice-FilterValue1%3DSample%2520Name

Once you have the first one, you just need to change the FilterValue attribute for each device.