Add A Discussions List With Threaded View In Office 365 2013 Sharepoint Sites

discuss-2010A discussion board without a threaded view is like, well….having a blog on one site and its associated comments on another. You never know who’s replying to what. What makes Microsoft’s decision to remove the threaded view from Sharepoint 2013 even odder is that it worked fine in 2010 and still does in a 2013 site. All you have to do is save a discussion list as a template from a 2010 site and move it over.

If you want to add the list to a public site, you may find the template doesn’t show up when you click”add an app”. To workaround that restriction, try installing it on a sub site of the public site. Sub sites can be created with standard templates, so are not as restrictive as the public site. And it’s easy to make a sub site look like it’s part of the parent site by following this guide:

If you don’t have access to a 2010 site or want to save some time, you can download the 2010 template here » Just follow the installation instructions on that page.
I set up a working demo of the list on a 2013 public sub site here » You can add some styling if needed to dress it up a bit.


Visit my forum » if you have any questions. For development work, you can contact me here ». And if you think this would be useful to others, feel free to share it by clicking one of the share buttons up top!

An Easy (And Free) Way To Add Ecommerce To An Office 365 Sharepoint Public Site

demo-storeAdding a professional looking, functional and mobile friendly storefront to an Office 365 public site is something a lot of people want to do but there isn’t much information out there about the best way to do it. I recently reviewed a couple of options for adding ecommerce functionality including some management tools for e-commerce sites, and thought it would be helpful to provide a little tutorial on integrating the best of the bunch – the FREE Ecwid ecommerce widget – into a Sharepoint 2013 public site. See it: You can see a live demo store here »Get it: You can sign up for a free Ecwid account here »

Create Ecwid Account

Since my concern is integration with Office 365 (and the Ecwid interface is so intuitive), I won’t go into detail about how to build or manage your Ecwid store. A free Ecwid account has a lot of pro features including order tracking, inventory control, product galleries, product options and tax and shipping options. I also suggest you use the product import feature – it’s very easy and a big time saver. I had 20 or so demo products set up and the store operational in about 10 minutes.


Ecwid dashboard

Set Up A Page

If you want the same layout as my demo store », choose the left sidebar page layout. You’ll be adding the categories widget in the sidebar and the product section/cart/checkout in the main content area of the page. You can of course vary this to suit your needs. You only need to create one page – Ecwid uses ajax to display the different parts of your store in the same content area. The widgets are “smart” and interlinked – so once you add them to a page, you can navigate the entire store, view the cart and checkout.

Embed Storefront

Go back to your Ecwid account. At the top of the dashboard page, you’ll see all the code snippets you can use:

Product Browser Widget Code = Main product display – will show categories, individual products, cart and checkout in same block.
Bag Widget Code (recommended) = displays a shopping “bag” and its contents plus you can drag and drop products into it.
Categories Tabs Widget Code (optional) = Adds category tabs above the main product browser.
… or Categories Menu Widget Code (optional) = Vertical list of linked categories.
Search Box Widget Code (optional) = Displays search box for products.
Start by copying theProduct Browser Widget Code. Add a script editor web part to the main content area of your Office 365 page. Edit the snippet and paste the code.


Adding a script editor web part….


Paste the Ecwid code

Copy the Categories Menu Widget Code and paste that into a script editor web part in the sidebar area of the page.

That’s all you need for the store to look good and function. You can also add theBag Widget Code but it’s a little tricky to get it positioned right in the Office 365 editor unless you know some css. Likewise the search box.
When you’re done, save and publish the page and take a look at your new store! Now it’s set up, any editing you do in the Ecwid interface will immediately update your site.
Not bad for a free application!


Visit my forum » if you have any questions. For development work, you can contact me here ». And if you think this would be useful to others, feel free to share it by clicking one of the share buttons up top!

Add An Announcements List To An Office 365 Sharepoint Public Site With A Date Range Filter

news-page2A Sharepoint Announcements list can be used to show news items, upcoming events, product introductions or any manner of short update-type items. For some reason, Msft decided not to include this type of list in the public site, and made it rather difficult to add it. Only certain types of list can be added as apps. Even if you import an announcement list template from a team site, Msft prevents it from showing up as an app you can add.Not to worry – since it’s actually a pretty simple list to create, I’m going to show you how to do that – and go one better by enhancing the basic list by adding filters so the list ONLY shows items within a specified date range. You can see a live example of the end result here »Download
If you want to skip all the fun of creating your own list (!), you can download a convenient list template here »

Create The List

Click “Add An App” and create a new custom list, naming it “News” or whatever you want.
Open the list and add list fields by clicking “create column”


Add a multi line rich text field for your announcement’s content, and 2 date fields – one for “Start date” and one for “Expiry date”.
It will look like this when you open the list’s settings:


Create A Date Filtered View
The default announcements list includes an expiry date field – your custom version can go one better by adding a start date. There are many reasons you may want an announcement to become visible on your site at a specific time – if you’re running a promotion for instance. You may also want announcements to automatically drop off the public view, say after an event is over. To do that, you’ll need to create a new view of the list filtered to only display items between the start and expiry dates you set in the list.
Go to the list settings, click “Create view” and select “All items” as the starting point.

Name the view and make sure only “title” and “body” are checked
Scroll down to the filter section, and add filters as shown in the image:


The logic of the filters may seem a little odd – I’m still not sure I understand why it works – but it does. What it says in simple terms is show only items between the start date and expiry date. In more detail, it’s saying:
Show items IF:
Expiry date is equal to nothing = when the expiry date is empty (ie there is no expiry date)
Expiry date is greater than or equal to [Today] = when the expiry date is today or after today
Start date is less than or equal to [Today = ]the start date is today or after today.
Any item that fails to meet ALL those conditions will not be shown.

View Style
To give the announcements a vertical rather than horizontal presentation, you can change the style of the view.
Scroll down the list view settings page and open the “style” option
For a vertical orientation, select the “newsletter no lines” style.
Don’t forget whenever you change the view you have to go back and reselect it in the web part properties on the page!

Add To A Page

Now the list is built, you can edit a page, look for the web part with the name of your list under “Apps” and insert it where you want it to appear. You’ll just need to switch over to your custom view as follows:
Click the web part and in the ribbon click web part “properties”.
When the properties box opens, under “List views » selected view” pick the new view you created from the drop down.
Click ok to save your changes and remember to publish the page.


Add a few items to the list, and play with the date fields to test it out. Anything with a start date of today or after today AND an expiry date of today or before today should show up on the page.

Additional Points
By default, the”title” field is linked to the item but since Msft blocks anonymous access to list items, you may want to change the type of the title field from “title-linked to item” to just “title”. You can pick a different field type in the list view settings. This wi

FREE List Template And Web Part Downloads For Office 365 Sharepoint Online Sites!

111213_0003_addmultiple1Download these free list templates and web parts and add functionality and usefulness to your Sharepoint sites!Easy: download, extract and install!
Time saving: fully functional out of the box!
Safe: developed in a Sharepoint site – no additional code added!

Installation Instructions:
1/ Download file or zip file (and extract)

2/ Open”list template gallery” on desired site [If not in settings, use this url:]

3/ Click”upload document” and navigate to the location the .stp file was saved in.

4/ Click the”cog” icon at top right of page and “Add An App”

5/ Locate the app you uploaded and add to your site


Calendar Creator List Template Tested: SP 2010/2013

This free list template will let you add a list and simple calendar web part to Sharepoint Online 2013 public web sites.
Read more »

Download Here »
Announcements List Template Tested: SP 2010/2013

Add An Announcements List To An Office 365 Public Site With A Date Range Filter
Read more »
Download Here »

2010 Discussions List Template Tested: SP 2010/2013
Includes the all important threaded view missing from 2013!
Read more »
Download Here »

Picture Library Slideshow Webpart Tested: SP 2010/2013?

This free web part will let you add a slideshow that pulls images from a picture library..
Read more »

Download Here »
Content Query Webpart Tested: SP 2010/2013?
This free web part displays content from another SP location..
Read more »
Download Here »

Script Editor Webpart Tested: SP 2010/2013?

This free web part allows you to add scripts to a SP page.
Read more »

Download Here »

RSS Feed Viewer Webpart Tested: SP 2010/2013?

This free web part displays content from any RSS feed, including Sharepoint feeds from other sites..
Read more »

Download Here »


Visit my forum » if you have any questions. Another thing: use this template for managing goods supply, if needed. For development work, you can contact me here ». And if you think this would be useful to others, feel free to share it by clicking one of the share buttons up top!

An Office 365 Blog served up using an rss feed

How do you get a 365 blog published on your public site?MSFT makes it more difficult than it should be, but here’s one way.
Create a blog sub site under the public site collection in 365. Use the rss feed to embed the blog on your public site.
You could see the original blog the feed is from here but the link tool is broken in Sharepoint.
See the blog feed on a public site page here.
UPDATE:This worked for a while – displaying actual posts on the public site via rss – but now it just shows a link to the blog, so it looks like MSFT has closed off yet another useful feature of O365.