Skip to main content

O365: Create a SharePoint List-On-Line

O365: Create a SharePoint List-On-Line


What is a List?


Viewed through a browser a SharePoint on-line List looks very much like a SharePoint on-line Library. However, where the library is a place to store a file, along with any metadata which describes the file a list is a place to store simple data. The data stored can be used as information, can be used as metadata across the site or can be manipulated to present different aspects of the information. In this sense a SharePoint on-line list can be compared to a spreadsheet, or a view of the contents of a database.


 A word of caution here, SharePoint on-line lists and libraries are effectively limited in content to 5000 rows. If it is anticipated that the row count of a list is likely to approach this number, it would be appropriate to split the list in to two or more separate lists, create a list which utilizes metadata indexing to filter searching or create a list which reads data from an external database on demand. These three options required a little more analysis of the list requirements and will be dealt with in later articles.

List Usage.

A very simple form of list is one that contains detail about customers. A customer list would contain information, such as names, addresses, contacts and the like which can be used across other lists and libraries in the site. So, for instance, when indexing a new invoice into the Invoices library the customer data can be selected from the Customer list instead of retyping or cutting and pasting.

Create the List

  1.  Open O365 in a browser. I prefer to use IE for this as Edge will not allow reliable copy and paste.
  2.  Click on the app launcher icon 




  3. Click on the tile for the Site where you wish to create the list. For the screen shots here I’ve used my own ffox Test site.
  4. I use ffox Test to test new ideas and processes.
  5. From the left hand ‘Quick Access’ menu select ‘Site Contents’
  6. Click the ‘add an app’ icon 


    and select ‘List’ from the top of the list.

  7. A dialogue will ask for a name for the new library, enter ‘Invoices’ and click create. Be sure to click the box for Show in Site Navigation.

  8. The new ‘Invoices’ list appears in the list and it will also be shown in the ‘Quick Access Menu’ on the left of the screen




    However, in order to make the list fully functional there is some configuration to be done.


    Configure the new list

    When a new list is created in O365 SharePoint on-line automatically creates a number of default data fields. These can be viewed in the following way – 

    From the Site Home Page



    Customers’ from the Quick Access Menu.

    The default view will display.


    There is no content as yet and this view will show just one field named ‘Title’.

    By default SharePoint on-line creates seventeen data fields for any new list and these will be populated automatically for any entry in the list.

    To view a list of all data fields click the ‘List' tab in the top left of the screen.


    This will display the library ribbon. Select ‘Modify View’.

    From this list on the settings page you will see all of the default columns (fields). Those with the ‘Display’ checkbox ticked will show on the default view seen in step 2 above. If the checkbox is unticked the data is hidden.




    Utilising this you can choose what meta data you wish to display in the list default view. You can also create new views for specific purposes, this will be covered in a separate article.
                    However, not many of the columns (fields) in the default list are particularly relevant to the business function of recording Customer details, so we will need to create new columns and name them specifically. We can also choose if we want to require the users to enter data, or allow them to leave the field empty.
To create new fields return to the Invoices default view by clicking ‘Invoices’ in the ‘Quick Access’ menu on the left. Then click the ‘Library’ tab in the top left of the screen and from the library ribbon select ‘Library Settings’ towards the right hand end of the ribbon.



This will display the settings page for the Customers list. Around half way down the page the current fields (columns) are listed and below that are some action links, the first of which is ‘Create column’.

Before we create any new columns we need to consider what data we want to store. For this exercise we will create columns to store
 Customer Name
Address 1
Address 2
Address 3
Address4 
Postcode
  
                These few fields will give enough information to allow us to sort the contents of the list to display quite a range of information which will be useful to users in the future.

Start by clicking on ‘Create Column’ 



Then fill in the entries shown above and click ‘OK’ in the far bottom right of the screen.

Repeat the process for the remaining new fields -





Don’t forget to save it by clicking ‘OK’ after each new field.

Return to the default view for Customers by clicking on the ‘Customers’ name in the left hand quick access menu and you will see the new fields under the "Find an Item" box.

Click the "List" tab and select "Modify View" from the ribbon. Deselect the "Display" checkbox for "Title" and check the one for "ID" then return to the default view by clicking "Customers" in the quick launch menu on the left.




The new fields (columns) are now included and you are ready to start importing customer details to the list.


Entering Customer Details

Click on ‘New Item’.


and enter the details as shown above. Then click ‘Save’ 


The entry will appear as shown above. The ‘ID’ column is allocated a unique numeric key for each entry by SharePoint on-line. This cannot be deleted or edited and the ‘ID’ of deleted records are not reused.

Now that we have created a library and a list we can begin to explore interaction and links between the two.


Notes:


1. This assumes that the user has Internet access 
        2. Also that the user has been granted write access to the SharePoint site and library 
        3. If the library has ‘check in/check out’ enabled the user will be prompted to check out on opening and check in on
        closing 
        4. If the library has ‘Approval’ enabled the document will not be visible to other users until ‘Approval’ has been granted 



Labels:

Comments

Post a Comment

Popular posts from this blog

O365: SharePoint List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...
Post a Comment
Read more

The New Computer Age: Infrastructure and the cloud

Most business managers don’t know it but this is very close to the truth. IT teams across the world live in day to day hope that their servers and networks hold together and pray that the disaster recovery schemes will be adequate in the event of catastrophe. IT people are highly professional and, of course, their server networks do deliver. Massive and expensive failure is surprisingly rare, provided that the IT department gets what the IT department needs in terms of budget. But, where budget is restricted, where the IT manager fails to make the business case for upgrade, then performance and security start to become threatened. In addition, a complex IT infrastructure brings with it the penalties of restrictive practise where a department head can’t get the software, services or technology required for a lean department because what is needed will not fit with the current IT infrastructure. So, what’s the answer? Sole Trader - Read more SME - Read more En...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more