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

Microsoft Teams

Microsoft Teams – Not only but also... What is Teams? Chat, Meetings, Calling, Collaboration | Microsoft Teams That’s the legend that Microsoft uses to head their Google listing. And it does those things really well. But -  There’s more . Teams also delivers a gateway to the fabulous world of SharePoint file storage, SharePoint and Office 365 index and search and Office 365 file security. All without the need for technical knowledge or extensive configuration. All well and good... What exactly does that mean? When you create a new team, simply click the ‘Join or Create a Team’ box at the lower left of the teams window, you launch a new team that has all the necessary attributes. This includes a mailbox, chat, call and video meeting area and a SharePoint file space with a basic library. Move shared documents, of any type, into the library and they are shared with other team members (the share facility is configurable to exclude individuals in the team who do not have sufficient righ...
Post a Comment
Read more

O365: Getting Really Useful Data into SharePoint Libraries

O365: Getting Really Useful Data into SharePoint Libraries See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow ,   Bulk Invoicing  and  Spreadsheet Data A really useful SharePoint Library structure will give you something like this -  Just typing the words 'Credit Card' into the SharePoint search box returns a list of items relating to credit card across the entire Office 365 site. Security Don't worry about users accessing documents that are restricted. If you create or place a document into a Teams Document Library, it will be available to members of that Team by default. However, each document can be locked down to no access, view only or edit. You can also stop sharing any document, or alternatively share only with the members of the team you select. Users with whom the document has not been shared with will not be able to access it. Being More Specific   That's fine if you know which Credit C...
Post a Comment
Read more

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