Skip to main content

O365: Link a SharePoint List and a SharePoint Library

O365: Link a SharePoint List and a SharePoint Library

Data in a SharePoint on-line List can be accessed for Library Metadata

See also - Create a SharePoint library and Create a SharePoint List


This means that you can enter reusable data into a list and select it from a drop menu when entering data into another list or library.

In most business scenarios when an invoice is created it will be specific to a customer. If a customer is invoiced many times for different goods or services, it would be necessary to enter the customer details each time an invoice is created or imported into the document library. This chore can be avoided by entering the customer details once into the Customer list and having a drop selection menu to copy the data into the Invoices library.

The Method


If we use the newly created Customer list and Invoicing library as an example.
NB: Click the links for information on creating Libraries and Lists

  1. First we need to modify the Invoices library to add a lookup Select ‘Invoices’ from the quick access menu on the left, click the ‘Library’ tab.




  2. Click ‘Library Settings’ in the ribbon, then click ‘Create Column'



    Configure the column as shown above, then click ‘OK’ in the bottom right of the screen. This will enable selection of the customer details from the Customer list. However as the list already has a ‘Customer’ column the original must either be deleted or hidden. NOTE: In most cases it would be simpler to delete the Original ‘Customers’ column altogether. However, if the list has been in use for some time it may contain valuable data which must not be lost. In this case return to the Invoices Settings screen and double click the old ‘Customers’ column name. This is the original text column that requires manual entry of the customer details. It is set to require data entry

    Check the radio button ‘No’ for ‘Requires that the column contains data’ and click ‘OK at the bottom.

  3. Return to the ‘Invoice’ home page by clicking on ‘Invoice’ in the quick access menu on the left. Select the ‘Library’ tab and click ‘Modify View’. Uncheck the ‘Display’ tick-box for the Column ‘Customers’


    and the new columns will be displayed.

  4. When you import a new invoice document, or edit an existing one you will be able to select the customer from the Customer list via a drop menu.

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.


Need more help? - request a free call back 


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