This website uses cookies to ensure you get the best experience on our website.
Learn More

Ultimate Guide to Choose The Best RFP Management Software

Finally you have made up your mind that your company will use RFP Management Software. You want to save time...
Read More
Ultimate Guide to Choose The Best RFP Management Software

Can Intranet Boost Your Digital Workplace?

The digital workplace is a recent trend that will soon be required in the commercial sector. A Digital workplace gives...
Read More
Can Intranet Boost Your Digital Workplace?

Cut Costs And Boost Productivity With Procurement Management

When you have a small team, choosing the tools you want to use daily is as straightforward as knowing what...
Read More
Cut Costs And Boost Productivity With Procurement Management

Why should you migrate from SharePoint 2013

In recent years, Microsoft has played an essential role in SharePoint for enterprise communication and collaboration. Microsoft has revolutionized the...
Read More
Why should you migrate from SharePoint 2013

SharePoint: Your Holy Grail for all Onboarding and Offboarding activities

The Dilemma It is tough to let go of people easily, whether employees, patients, vendors, nurses or students. But that...
Read More
SharePoint: Your Holy Grail for all Onboarding and Offboarding activities

How to create SharePoint list?

A SharePoint list is a collection of data that offers a flexible way for you and your co-workers to organize information. SharePoint list use tables in SQL server databases or excel spreadsheets with columns, fields, or properties. These lists can also contain one or more attached files.

Lists make it easy to create and share information with anyone on your network. They also keep everyone in sync with smart rules and collaboration features. SharePoint owners can customize SharePoint Lists based on their specific business needs.

SharePoint users can create lists in several ways: import from an Excel spreadsheet, migrate from an existing SharePoint list, or leverage the SharePoint templates available. Microsoft SharePoint provides the following eight default list templates.

1. Issue tracker

2. Employee onboarding

3. Events itinerary

4. Asset manager

5. Recruitment tracker

6. Travel requests

7. Work progress tracker

8. Content scheduler

How to Create a list in SharePoint

1. Go to the site collection where you want to create the list.

2. From the top right click on the ‘Gear’ icon and select ‘Site contents’.

Sharepoint Site list

3. From the site contents page click on the ‘+ New ’

Ads New List

4. From the ‘Create a list page, select one of the following options:

a. Blank list: Choose this option to start from scratch. Give your list a Name, Description(optional), and select any other options you want. The list will save to ‘My lists’ unless you choose one of your SharePoint sites or Teams from the ‘Save to’ When you finish selecting options, click ‘Create’.

b. From Excel: Choose this option to create a list based on an Excel spreadsheet.

c. From the existing list: Choose this option to save time and create a new list based on the columns in another SharePoint list. Your new list will start with the same columns but will not have any data.

d. Templates: Select a template, such as an ‘Issue tracker,’ to see what columns the template has. You can then scroll through sample data to see what to include. Select the templates that fit your specific needs. Click the ‘Use Template’ button

Use Template

5. Once you create the list, you can open it. If required, you can add new columns by selecting ‘+’ or ‘+Add column’

Add Column

6. You can share the list with your co-workers. Determine their access level by choosing either “Full control, Edit, or View” permissions.

Share List

7. You can export the list to an excel file.

8. You can integrate the list with Power Apps and Power Automate integration as needed.

Integrate with Microsoft Powerapps

Final thoughts!

SharePoint lists are an important feature that helps organize your work and track key information. It has integration with Microsoft PowerApps, Microsoft Power Automate, and Microsoft Teams which make it more powerful. SharePoint has an iOS and Android app which helps users to work remotely on their list. With these simple steps- you can create SharePoint lists all by yourself.

If you have any questions or doubts regarding Lists, feel free to connect with our Office 365 experts. Email us at [email protected] to request a free consultation.