Lists in SharePoint or SharePoint List Free Tutorial

Understanding Lists in SharePoint :

 

Lists have items, columns, and views. Items and columns correspond to the rows and

columns that you see on a grid layout in a spreadsheet. Views present list data in a friendlier

format that acts very similarly to a report.

 

Sample list which shows items,columns,view

 

 

 

The view here is All Items which is the default view,which also means that it shows all columns and items,hence called All Items.

You can also have a custom view,in which you decide the columns you want to see in the view.

 

SharePoint List Coloumn types:

1)      Single line of text

2)      Multiple lines of text

3)      Choice – You can give choice Example : Citynames as Pune,Mumbai,New York

4)      Number

5)      Currency

6)      Date and Time

7)      Lookup –  You can have a list as reference which you can use as look up like if you have a lookup column which has city names

8)      Yes/No - This checkbox column indicates whether an item matches a specific criterion.

9)      Person or Group - Users can select people or groups which they want to associate with the list

10)   Hyperlink or Picture - You can use this column type to allow users to enter a web address into a list item to create a hyperlink or display an image located at the source location.

11)   Calculated – Rather than have users enter information manually, you may want to calculate values based on other columns within the list

12)   Task Outcome (New in SharePoint 2013) - You can use this column type when defi ning workfl ow solutions. It is very similar to the Choice column in its properties, but is often leveraged related to the tracking on tasks for workflow

13)   External Data - In some cases, you may want to associate business data from an external business application with your list items. For example, you may have a listing of all products in a sales database and instead of re-creating it in SharePoint, you can connect to it and reuse that information.

14)   Managed Metadata: In some cases within your organization, another administrative user may have already defined a set of metadata to describe important aspects of your organization. Therefore, there is no requirement for you to redefine this information yourself.Example : Departments in a organisation are Finance,Admin,IT operations. So when you start typing this pre-defined and existing words populate.

15)   Audiences( New in SharePoint 2013 ) - If a list has audience targeting enabled, this column type is added to it automatically. Audiences are groups of users that you defi ne based on a set of criteria. When

you use audiences on list items, the items appear only to members of the audiences associated with the item.