Create separate Tile list view for a Promoted Links in SharePoint

Most business users prefer to present featured links in Tile view in SharePoint.

SharePoint does not give an option to modify the Title view for promoted links in a traditional way, which means you cannot filter or sort the Tiles item.

Here I am going to show you how to modify or create separate Tile list view for a Promoted Links in SharePoint.


Go to your site where you want your promoted links and within the site contents click on "Add an App"

Give a name to your promoted links. Once the promoted links is created, add new columns as per you business requirements. Now to modify the Tile view or create a separate tile view, click on Create view 

SharePoint will take you to the List view settings page. Click on Custom View in SharePoint Designer. This will open a SharePoint designer, and ask you specify Tile view name. Enter the Tile view name.

Once the new SP Tile view is created, edit the newly created view. Now you will notice all your new columns available to select, filter etc. Make necessary changes in the list view, and click Okay.

You will see your custom Tile view! 

Team Members list by Department in SharePoint 2013

You can use SharePoint out of box WebPart to display users i.e. Site Users, but the Site Users WebPart is not very flexible.

There is also another SharePoint out of box approach which you can take to display the Team Members which you can filter by Department number. Depending upon your scenario, you can also filter the users list by individual names or by any custom User Profile attributes.

My assumption is, you have setup User Profile Service correctly and synchronized with Active Directory, and also Search Service is also configured and crawled atleast once.

Go to the page where you want to display Team Members, and follow these steps
Site Action
Edit Page
Select the Content Rollup under Categories
Insert a Content Search webpart
Click Add

Edit the Content Search Webpart
Under properties, expand Search Criteria
Click on Change Query

Select People result source i.e. most likely it will be your Local People Results
Select the department number to filter
Click Ok

If you would like to display other User's attributes like Title, Job Title, Department name etc then make sure required User's attributes are selected.

Expand property Mappings
Select Title, Job Titles, Department name etc
Click Ok.

Finally you will see Team Members list in the webpart.

It would like nice if your users have photo in their profile!

Wrap Promoted Links in SharePoint

SharePoint promoted links are a great way to dress up your site. By default, they do not wrap to more than one row. Some of the links are hidden until you scroll right with the right arrow. This functionality makes the promoted links web part appear not good in side columns.

Below CSS will wrap the promoted links according to the width availability.

<style>
.ms-promlink-body {
    width: inherit;
}

.ms-promlink-header {
    display: none;
}
</style>

Remove SharePoint Webpart title link so that it does not drill down to the underlining list

There are many options you can take to remove the Title link. It depends upon whether you would like to keep every out of box or prefer to use Javascript.

Option 1:
Add an empty content editor webpart and give same title as listview webpart, and on the listview webpart you have to set the chrome to none so title doesn't display once you exit out of design mode.

You can modify Chrome Type property of the List View Webpart:

• Site Action
• Edit Page
• From the context menù on the top-right of the webpart choose Edit Web Part
• Within the properties pane expand Appareance section
• Modify the property Chrome Type to None or Border Only
• Click Ok
• Click on Stop Editing button

Option 2:
If you put a pound "#" in the Title URL you get a link to current page.

You can modify Chrome Type property of the List View Webpart:

• Site Action
• Edit Page
• From the context menù on the top-right of the webpart choose Edit Web Part
• Edit the list view webpart
• Expand the Advanced tab, and replace the title url with #
• Click on Apply button
• Click on Stop Editing button

Option 3: Javascript
Add a script editor webpart on the page, and add the following Javascript code. This code will disable all Webparts Title link on the page.

<script>
$(function() {
    $('.ms-webpart-titleText').each(function() {
        var link = $(this).find('a');
        if (link.length > 0)
            $(this).text(link.text());
    });
});
</script>

Option 4: Javascript
Add a script editor webpart on the page, and add the following Javascript code. This code will disable only specific Webpart Title link on the page.

<script>
$( document ).ready(function() {
    $('a[href="/sites/yoursitename/Lists/yourlistname"]').contents().unwrap();
});
</script>

Excel files download in Chrome rather than opening from SharePoint Server

Chrome browser is not fully compatible with MS Office. I did some research on this and found out the issue is expected in Chrome browser i.e. when you click on the Excel file name in SharePoint, the browser just download the file to a download folder.

If you prefer continue to use chrome, I would suggest to click on the three dots “…” next to the Excel file name and click “Edit” link. This will open the file in Excel and also changes you make in the file will reflect back in the SP library. See the attached screenshot

My recommendation would be to use IE when working with SharePoint, especially to use features like “open with Explorer”, and to edit the Excel file by clicking on the file name.