Skip to main content

O365: Create a SharePoint-On-Line Library

O365 is a tremendous resource. It can serve a business better when SharePoint on-line libraries are used as a repository for files and documents on which collaboration is required.

 Instead of circulating documents for input by different users, simply save them to a SharePoint library where selected personnel can access them for update.
Creating a library is a simple process which needs no technical expertise greater than the ability to use a computer. For this exercise we will create and start to populate a library for storing invoice documents. 


Select the Site 


An O365 domain can contain many sites. Libraries and Lists within a site can be made to interact with one another so data can be readily shared across the site and recycled. For example, if we choose to create a Customer List within a site and we populate the list with customer names and addresses we can allow other libraries and lists within the site to access and use the name and address data.
So, the first job is to select which site we will use, or create a new site (this option will be covered in another article).

 
Create the Library.


  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 libraries. 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 ‘Document Library’ from the top of the list.
  7.  A dialogue will ask for a name for the new library, enter ‘Invoices’ and click create. 
  8. The new ‘Invoices’ library appears in the list and it will also be shown in the ‘Quick Access Menu’ on the left of the screen



   
That’s all it takes to create a library. However, in order to make the library fully functional there is some configuration to be done.

 Configure the new Library.

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

  1.  From the site home page

  2. Select ‘Invoices’ from the Quick Access Menu.


    There is no content as yet and this view will show just four fields. These are ‘Type Icon’, ‘Name’, ‘Date Modified’ and ‘Modified By’. These are metadata fields. By default SharePoint on-line creates twenty-one metadata fields for any new library and these will be populated automatically for any item checked into the library.

  3. To view a list of all metadata fields click the ‘Library’ tab in the top left of the screen.


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

  4.  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 library 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 Invoicing, 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.

  5.  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 Invoices library. 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.

    The Value of the Invoice.
    The Status of the Invoice.
    The Order Number against which the Invoice has been raised.
    The Customer.

    These few fields will give enough information to allow us to sort the contents of the library 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 ‘Status’ field, this time using the ‘Choice menu’ option. Don’t forget to save it by clicking ‘OK’.
    Repeat again another twice for the ‘Order Number’ and ‘Customer’ fields, selecting ‘Single line of text’ in each case.

  6.  Return to the default view for Invoices by clicking on the ‘Invoices’ name in the left hand quick access menu and you will see


The new fields (columns) for Value, Status, Order Number and Customer are now included and you are ready to start importing invoice documents to the library.


Importing Documents

A SharePoint on-line library can store documents in a wide variety of file formats. For this exercise we will store PDF prints. The invoice PDFs can either be scanned documents or documents printed to PDF from your own in-house business applications. Most accounts packages will allow a print to PDF function, as will MS Word and Excel, alternatively you can install a PDF print driver and use that to create the files. 

  1.  Return to the default view for Invoices by clicking on the ‘Invoices’ name in the left hand quick access menu and select ‘Upload’



  2.  Browse to the invoice PDF file, select it and click ‘OK’




  3.  Complete the metadata fields as shown below and click ‘Check in’



  4. The newly imported invoice will appear in the Invoices library. 





  5.  The ‘Modified’ column will initially show ‘A few seconds ago’, this will change to display the specific time of modification and in later days will show the date of the modification (date and time will display if you hover over the date). The metadata entries can be edited by clicking on the ellipses (…) icon. However, SharePoint on-line will always track the date/time and the user of the last modification.


  6.  Once there are a number of items in the library the display can be sorted and filtered on any column to show selected items only. For instance, if the ‘Status’ column is filtered to show only ‘Submitted’ items the display will deliver a quick return of all outstanding invoices. Similarly the library can be filtered to display only invoice belonging to a particular customer.

     

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 prompter to check 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.

<a href="https://twitter.com/ffox09423516?ref_src=twsrc%5Etfw" class="twitter-follow-button" data-show-count="false">Follow @ffox09423516</a><script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>Follow us on Twitter

Comments

Popular posts from this blog

O365: SharePoint Searching in Office 365 and Teams

 O365: SharePoint Searching in Office 365 and Teams See also -  Other Office 365 Posts Earlier posts have discussed the huge advantages of centralising documents, files and communications in SharePoint and Office 365. One of the strongest functions in Office 365 is the ability to search all content so that locating data is easy. However, the search tools in Office 365 are not always obvious. Teams Search Teams is becoming really popular, not least due to the fact that it makes SharePoint very easy to deploy, use and control. At the top of each Teams General Tab is a search box This is multi function. Type / into the box and you will see a list of commands that will perform all sorts of Teams functions    The /Files option will return files you have recently accessed. Great, if the file or document you are looking for is actually in the recent file list. What if the information you require is in an older file, or in a different location? Location Search Also in Teams ...

O365: Getting the best out of SharePoint

O365: Getting the best out of SharePoint See also - Libraries , Lists , Linking List and Library Simplicity Anyone who has read my earlier posts on creating, populating and joining data containers like Libraries and Lists in Office 365 SharePoint will know how simple it is. Giving a little thought to what data or information you want to keep and what you will use it for in the future is the hard part. Once you have that, building the lists and libraries is as easy as creating a spreadsheet.  But, a SharePoint list or library is far more flexible and effective than a spreadsheet can ever be. Shadow IT This is the name given by IT departments to the practice of hiving off chunks of corporate data into silo data stores controlled and maintained by individuals. A mobile phone contacts list is a great example. The same data might be held in a dozen or more separate phones and the data might never be synchronised. Personal spreadsheet lists can fall into the same category. Data from any ...

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...