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 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 ...
Post a Comment
Read more

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. ...
Post a Comment
Read more

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 ...
Post a Comment
Read more