Blog Archives

SharePoint – Using Flows on yours list items and documents

Hey Everyone!!

Today i will talk about Flows!!! March 2017 bring us a new capabilities about integrating Flows with modern libraries, allowing you create interactive in document libraries and list! Probably they will quickly replace the old Event Handler or Event Timer Jobs!…

Flows, introduce a new way to development scheduler to build and respond your business needs, it is very fast to implement them and very intuitive!…with the ability to build zero code processes directly from a SharePoint list. These Flows operate against the entire scope of a list, waiting for data-or driven triggers to launch each process. Flows operate on a single item or document selected in the modern user experience.

You could create Flows using templates or you could create your owns directly inside SharePoint. Selecting a Flow launches the browser based Flow designer. When you save the Flow it’s also added as a drop-down button in that list or library.

Take a look at the flow templates list that you can use:


Fábio Carvalho


SharePoint Online – Storage Metrics – Monitor storage usage in your Site Collection

Hey Everyone!!!

Today i will talk about Storage Metrics in your SharePoint Site Collection!!!

Everyone knows what is the main feature on SharePoint that you could interact with and Structure of SharePoint Site Collections! right!? Site Content and Struct (/_layouts/sitemanager.aspx)!!!

Site Content and Structure page, give you a great overview about all your Site Collection structure. This feature, available since Microsoft Office SharePoint Server 2007, give the capability to navigate dynamically on your site collection hierarchy, it is familiar to Windows Explorer in fact. You can see the site collection hierarchy in the navigation pane as a tree view on the left of the Site Content and Structure page.

But, if you need know more details about storage, probably don’t help you as you expect, so in this case you case access to Storage Metrics (/_layouts/storman.aspx).


Storage Metrics underneath Site Collection Administration, access to your all sub-sites and libraries in SharePoint Online ( also available for SharePoint 2010, SharePoint 2013 and SharePoint 2016) and give you the information about how much storage they are consuming.

It is great!!! Because Storage Metrics allows you to drill down to each site, library and even folder to show a very granular report on your storage consumption, this is very important if you need migrate a large lists or even you are planning an migration between SharePoint Versions without any 3rd Party tool.

Take a Look:




Fábio Carvalho
SharePoint Consultant

SharePoint Templates – Understand the differences

Hey Everyone!

Today i will talk about SharePoint Site Templates, and explain the main difference between each template and how it is extremely important to have in mind what each version can offer you in terms of features and capabilities to meets your business needs.

So the first thing you must know is there are 3 main categories of templates:

  • Collaboration
  • Enterprise
  • Publishing

For each category you have different site types, when you create a new site the “site type” define the purpose of the new one and includes all the features.

Collaboration site templates:
  • Team Site – This template can be  used when you what organize and share information with your team or project members, this template includes lists and libraries for: Share Documents, Announcements, Calendars, Links, Tasks, Discussion Board.

  • Blog Site – This template can be  used when you what announce company announcements, post ideas, observations, expertise with your team organization. It is easy  start a new blog, including Comments and Links.

  • Project Site – With this site template it is so much easy to manage your projects, it is an upgrade of Team Site but this one have more functionalities including Projects Summary, Task Lists. Calendar Sharing, Task Scheduler, Visual Timeline of the Project’s Tasks.

  • Community Site – It is more than a Blog Site, this template you can create a place where you can discuss topics that you have in common with others team members, it is more easy and you have more benefits over email, with a full retention of discussion history in compliance with corporate guidelines.
Enterprise site templates:
  • Document Center Site – This template is indicated when you want manage large numbers of documents, it is more easy create folder structures and use file versions also you can use workflows to control document life cycles.

  • Records Center Site – This template is indicated when you what organize, store and manage records such as legal or financial documents, the site includes versioning, auditing, metadata management, eDiscovery feature to help manage records more effectively.

  • Business Intelligence (BI) Center Site – This is one of my favorite site template, you can store, manage, share and view business reports, scorecards and dashboards. This template includes Performance Point Service, a service very important to build dashboards inside of SharePoint.

  • Search Center (Enterprise or Basic) Site – A template dedicated to search features where you can search and apply refiners to your search results.

Publishing site templates:
  • Publishing Site – The template indicated when you want create enterprise intranets, communication portals and public websites. This template by default have publishing features enable including Page Layouts, Column Types, Web Parts, Lists and very important Documents and image libraries for storing web publishing assets.

  • Publishing Site with Workflow – Use the Publishing site with workflow to publish web pages on a schedule by using approval workflows. It includes document and image libraries for storing web publishing assets.

  • Enterprise Wiki – It is a publishing site for sharing and updating large volumes of information across an enterprise,  your organization can centralized knowledge repository.

The follow table show all Templates available for each SharePoint version.

Site Type
Template ID
Site Collection
SharePoint Server 2013
SharePoint Foundation 2013
SharePoint Server 2016
SharePoint Online
Collaboration Team STS#0 Yes Yes Yes Yes Yes Yes
Collaboration Blog BLOG#0 Yes Yes Yes Yes Yes Yes
Collaboration Project PROJECTSITE#0 Yes Yes Yes No Yes Yes
Collaboration Community SPSCOMMU#0 Yes Yes Yes No Yes Yes
Enterprise Document Center BDR#0 Yes Yes Yes No Yes Yes
Enterprise Records Center OFFILE#1 Yes Yes Yes No Yes Yes
Enterprise Business Intelligence Center BICenterSite#0 Yes Yes Yes No Yes Yes
Enterprise Enterprise Search Center SRCHCEN#0 Yes Yes Yes No Yes Yes
Enterprise Basic Search Center SRCHCENTERLITE#0 No Yes Yes No Yes Yes
Publishing Publishing Site BLANKINTERNET#0 No Yes Yes No Yes Yes
Publishing Publishing Site with Workflow BLANKINTERNET#2 No Yes Yes No Yes Yes
Publishing Enterprise  Wiki ENTERWIKI#0 No Yes Yes No No Yes


Also you have different types of site template variation, the following table show ALL the Template ID available, and you can you use powershell command to create them.

New-SPWeb http://createIT/blog -Template "BLOG#0"
Template ID
GLOBAL#0 Global template
STS#0 Team Site
STS#1 Blank Site
STS#2 Document Workspace
MPS#0 Basic Meeting Workspace
MPS#1 Blank Meeting Workspace
MPS#2 Decision Meeting Workspace
MPS#3 Social Meeting Workspace
MPS#4 Multipage Meeting Workspace
CENTRALADMIN#0 Central Admin Site
WIKI#0 Wiki Site
BLOG#0 Blog
SGS#0 Group Work Site
TENANTADMIN#0 Tenant Admin Site
APP#0 App Template
APPCATALOG#0 App Catalog Site
ACCSRV#0 Access Services Site
ACCSRV#1 Assets Web Database
ACCSRV#3 Charitable Contributions Web Database
ACCSRV#4 Contacts Web Database
ACCSRV#5 Projects Web Database
ACCSRV#6 Issues Web Database
ACCSVC#0 Access Services Site Internal
ACCSVC#1 Access Services Site
BDR#0 Document Center
DEV#0 Developer Site
EDISC#0 eDiscovery Center
EDISC#1 eDiscovery Case
OFFILE#0 (obsolete) Records Center
OFFILE#1 Records Center
OSRV#0 Shared Services Administration Site
PPSMASite#0 PerformancePoint
BICenterSite#0 Business Intelligence Center
SPS#0 SharePoint Portal Server Site
SPSPERS#0 SharePoint Portal Server Personal Space
SPSPERS#2 Storage And Social SharePoint Portal Server Personal Space
SPSPERS#3 Storage Only SharePoint Portal Server Personal Space
SPSPERS#4 Social Only SharePoint Portal Server Personal Space
SPSPERS#5 Empty SharePoint Portal Server Personal Space
SPSMSITE#0 Personalization Site
SPSTOC#0 Contents area Template
SPSTOPIC#0 Topic area template
SPSNEWS#0 News Site
CMSPUBLISHING#0 Publishing Site
BLANKINTERNET#0 Publishing Site
BLANKINTERNET#1 Press Releases Site
BLANKINTERNET#2 Publishing Site with Workflow
SPSNHOME#0 News Site
SPSSITES#0 Site Directory
SPSCOMMU#0 Community area template
SPSPORTAL#0 Collaboration Portal
SRCHCEN#0 Enterprise Search Center
PROFILES#0 Profiles
ENTERWIKI#0 Enterprise Wiki
PROJECTSITE#0 Project Site
PRODUCTCATALOG#0 Product Catalog
COMMUNITY#0 Community Site
COMMUNITYPORTAL#0 Community Portal
SRCHCENTERLITE#0 Basic Search Center
SRCHCENTERLITE#1 Basic Search Center
VISPRUS#0 Visio Process Repository


Using templates to create different kinds of SharePoint sites
SharePoint templates and their IDs


Fábio Carvalho
SharePoint Consultant

SharePoint Online, 2013 and 2016 – Display list data in grid using Rest API

Hey Everyone!

Today, in this post i will show you how can we display list data in a grid using Rest API in SharePoint Online, 2013 and 2016.
In this example, i will create a table – Cars – with 4 columns:

– Make
– Model
– Price
– Color


        var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Cars')/items";
              url: requestUri,
              type: "GET",
              headers: {
                  "accept":"application/json; odata=verbose"
              success: onSuccess,
              error: onError

  function onSuccess(data) {
     var objItems = data.d.results;
     var tableContent = '' + '' + '' + '' + '';
     for (var i = 0; i '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
         tableContent += '';
    function onError(error) {

<input type="button" id="btnClick" value="Get All Cars"/>
' + objItems[i].Make + '' + objItems[i].Model + '' + objItems[i].Price + '' + objItems[i].Color + '
tableCars' style="width: 100%;" border="1 px">
carsGrid" style="width: 100%">
</td> </tr> </table> </div>

You just need to copy the code and past in a script editor webpart, if you press the button  – Get All Cars –  the result it’s a the following table:

Mark Model Price Color
Mercedes A180 22.000.00€ Red
Jaguar X-Type 72.000.00€ Green
Fiat 500 20.000.00€ Blue
Bmw 320d 32.000.00€ Black

If you are interested to read more, i recommend the following links:


Fábio Carvalho
SharePoint Consultant