How to Create a Custom List in SharePoint Online

This tutorial will show you how to create a custom list in Microsoft SharePoint Online. A SharePoint list can help you collect and organize data similar to a spreadsheet. For example, purposes, in this tutorial, I create a custom list to collect data about invoices that need to be recorded centrally so that they can be managed and processed. SharePoint lists are great alternatives to spreadsheets for specific use-cases. You can also implement workflow on a SharePoint list through Microsoft Power Automate.

Part 2 of this tutorial will show you how to add a state-driven workflow to the SharePoint list to send emails to the individuals selected in the list item based on the status of the item.

Timeline
0:00 - Start
1:05 - How to Rename a SharePoint List Column
1:37 - How to Add a Date and Time Column to a List
2:07- How to Make a SharePoint List Column Required
2:36 - How to Add a Currency Column to a List
3:30 - How to Add a Choice Column to a List
4:15 - How to Set a Default Value for a List Column
5:00 - How to Add a Person Column to a List
6:00 - How to Add a Multiple Line Text Column to a List
7:00 - How to Add a New Item to a SharePoint List

-MORE ABOUT ME-

LOOKING FOR TRAINING OR CONSULTING - CONTACT ME AT:

LETS BE FRIENDSI

GOT A VIDEO IDEA? FILL OUT THIS FORM:

SIGN UP FOR MY MONTHLY NEWSLETTER

PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:

OTHER SERVICES THAT I USE:

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

[AbdullahMuhammadEl-Tahawy]

Cool! a quick question, when I create a date & time column it appears as 2 sparate fileds one for time and the other for date, however, I saw other lists when both can be entered from the same filed, how do acheive that ?

[debraallen]

Awesome! I just created my first List as a total newbie 🙂

[bob]

Thank you very much for such as explanation

[scb]

Very useful and finally learned something new

[bel]

Lui, you are a great help. I have a question though, how do you edit already made custom list?

[gman]

Hi Lui. Can you explain Add to all content types a little further? Like when to use it or not.

[v.elizabethrojas]

Hello thank you for you explanation, how I can order this list by status and see how many invoices I have in each of them

[kfossi]

So my list showed up on The navigation bar but how to I add it to a folder that can be accessed in Teams also?

[danieledacaselle]

Hi, thanks for the video! Can I insert a documents folder link in one of the columns?

[jirapornraveewan]

Do the list have audit trail on who edit and what was edit? Is it possible to change back to the previous entry information?

[gabrielacejkova]

Hi, have a little issue. When I create columns, set the rules for it like u and then click on "+ new" template with new item is not created. It is show me the list where i can choose, if i want add link to some file or folder from my PC. Am I supposed to set "+ new" button somehow?

[prayagamahatikaushik]

Hi, one query.
Can we add a list inside any of the documents folder in the site?
Or will all the created lists be visible in the root menu? Like shown here in video.
Thanks!

[arturskrzeta]

Hi, how to autopopulate requester with my name if I add a line?

[eszrcjp]

Hello, one question.
if I insert column "vendor number" between "invoice amount " and "vendor name", however, when I create the new item, the "vendor number" would be at the bottom to be filled. How can I move it from the bottom to be in the middle of " invoice amount" and "vendor name", so that, every line from top to the bottom in the new item would be the same order as the column from left to right.
Thank you so much and look forward to hearing from you.

[xnheypu]

how to you move the list into a folder on inside a document library on the sharepoint site

[flprete]

Hi, great video. One question please: The status is Pending approval right, and who is gonna approve it? The Manager will get an email in order to approve it? Is it sent automatically after clicking on save? And how can I create a list where every time I add a new record, the recipient gets an email. For example, I have to create a Package Delivery list and every time the Front Desk guy gets a package he creates a record in that list and the recipient should get an email warning.

[bzflowerbee]

Can I create a folder on the left and store the list there. Thank you.

[helenmeles]

what is the difference b/n the direct site list and the custom list?

[scb]

Can we also change the background in this page?

[AsrafunNaharAnonna]

Hello there, I was able to create columns but I can't see them in the list when I click '+ new'