In this SharePoint tutorial, we will learn what is a SharePoint Online list? How to create and use a list in SharePoint Online. I will also show you, how to add columns to a SharePoint Online list.
We will also check how to insert, update and delete SharePoint list items. We will cover the below topics:
- What is a list in SharePoint Online?
- How to create a SharePoint Online list
- Create a SharePoint list from a Blank list
- Create a SharePoint list from Excel
- Create a SharePoint list from an existing list
- Create a SharePoint list from a Template
- How to Rename SharePoint Online List title
- How to update SharePoint Online list description
- Add a column to a SharePoint Online list
- SharePoint Online List Column limit
- Rename SharePoint Online List Title column
- How to Change SharePoint Online list column width
- How to favorite a SharePoint Online list
- How to insert an item into the SharePoint Online list
- How to Update an item in the SharePoint Online List
- How to delete an item from the SharePoint Online list
- How to delete multiple items in the SharePoint Online list
- Attach a document to a SharePoint Online list
- SharePoint Online list attachments size limit
- SharePoint Online List Templates
- Show/Hide Columns in a Modern SharePoint Online List
- How to delete a column from a SharePoint online list
- SharePoint online list Remove Title Column
- How to create an index column in SharePoint online list
- SharePoint Online List id
- Export SharePoint online list to excel
- SharePoint online lists Multiple lines of the text character limit
- SharePoint Online list item comments
- SharePoint online list column names escape codes
- How to create an attachment column in SharePoint online list
- Add Folders in SharePoint online list
- SharePoint online list hide folders
- Display attachment name in SharePoint online list
- How to enable the geolocation field in the SharePoint online list
- SharePoint Online list a Collection of information or data, it is used to store information like the first name, last name, email address, etc., We can also add attachments to the SharePoint list.
- We can Share the SharePoint list with the team or an organization or with the users who you have given access.
- Once the SharePoint Online List is created, we can add columns to the list, and also we can filter and sort the list information.
For example, If we are creating an employee list, then we can store the employee attributes like employee name, employee id, employee join date, employee role, etc.,
Read SharePoint Online List Web Part
Let us see how to create a SharePoint Online list, and what are the ways that we can create a SharePoint Online list.
There are four ways that we can create a SharePoint list, they are
- To create a SharePoint list from a Blank list.
- To create a SharePoint list from Excel.
- To create a SharePoint list from an existing list.
- To create a SharePoint list from a Template.
Now let us see how can we create a SharePoint list from a Blank list,
- Open the Modern SharePoint Home page, Select +New and click on the List.
- Select + Blank list to create a list from scratch.
- Now add a SharePoint list Name which is required and also add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
- Select Create, and the SharePoint list will be created.
The below screenshot represents the newly created list from a Blank list.
This is how to create a SharePoint Online list from a Blank list.
Read Power Automate Create SharePoint List
Now let us see how to create a SharePoint list from Excel,
- Open the Modern SharePoint Home page, Select + New, and click on the List.
- Select From Excel option.
- There are two options that we can select an excel file, Either we can upload the excel file from the local system or we can select the excel file available on the current SharePoint site.
- To Upload an excel file from the local system, select the Upload file option, else choose the existing excel file presented on the current site.
- Click Next.
- To import an excel file as a list, make sure that you have created an excel file in the Table format with the columns. If not add a table in the excel file.
- If the excel file is not in the table format then we can see, that the Next button is disabled.
- Once you changed the excel file to the Table format, you can see that the Next button is enabled. Now click on the Next button.
- Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
- Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
- Select Create, and the SharePoint list will be created.
The below screenshot represents the newly created list from an excel file.
This is how we can create a SharePoint list from Excel.
Read Power Automate export SharePoint list to excel and send an email
Now let us see how can we create a SharePoint list from an existing list,
- Open the Modern SharePoint Home page, Select +New and click on the List.
- Select From an existing list option.
- Now select an existing list from the Team or the Site to use the template for the new list. It will copy only the columns and views from the existing list to the newly created list. It will not copy the column items to the new list. Click on the next.
- Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
- Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
- Select Create, and the SharePoint list will be created.
The below image represents the newly created list from an existing list.
This is how we can create a SharePoint list from an existing list.
Read Power Automate delete all items in SharePoint list
Now let us see how can we create a SharePoint list from a Blank list,
- Open the Modern SharePoint Home page, Select +New and click on the List.
- Under Templates choose the template list option that you want to use. In this example, I am going to use the Employee onboarding template list.
- Once you selected the SharePoint template list, click on the Use Template button.
- Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
- Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
- Select Create, and the SharePoint list will be created.
The below picture represents the newly created list from Templates.
This is how we can create a SharePoint list from a Template.
These are the four ways that we can create a modern SharePoint Online list.
Read Convert SharePoint list item to PDF using Flow or Power Automate
Let us see how we can rename the SharePoint Online List title and what are the ways we can rename the SharePoint Online List title,
There are two ways that we can rename the SharePoint online list title, they are
- By Clicking on the List title
- Through List settings
By Clicking on the List title
- Open the SharePoint Online list and click on the List Header.
- A Popup appears to rename the List title, Rename it and Click on the Save button.
In this example, I am going to rename the EmployeeList title to EmployeeListDetails.
- Click on the EmployeeList, change the list title name that you want to display as shown below, and click on the Save button.
In the below screenshot, you can see that the SharePoint Online list title is renamed as EmployeeListDetails.
This is the one way that we can rename the SharePoint Online list title.
Through List settings
- In this example, I am going to rename the SharePoint Online Web Parts title to Modern SharePoint Web Parts
- Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
- Under General settings, click on the List name, description, and navigation option.
- In the Name field, change the list title name that you want to display as shown below, and click on the Save button.
In the below screenshot, you can see that the SharePoint Online list title is renamed like Modern SharePoint Web Parts.
This is another way that we can rename the SharePoint Online list title.
These are the two ways that we can rename the SharePoint online list title.
Read Power Automate update SharePoint list increment integer field
Let us discuss how to view and update the SharePoint Online list description,
We know the description field is optional while creating the SharePoint online list. But later it is possible to newly add the description for the list or we can update the previously added list description.
In this example, I am going to update the TaskList description (below screenshot highlighted in Red).
Follow the below steps to update the SharePoint online list description:
- Open the SharePoint Online list that you want to add or update the list description and click on the Settings Gear Icon and select the List Settings.
- Under General settings, click on the List name, description, and navigation option.
In the Description field, we can newly add the description of the list that we want to display, or else we can update the previously added list description, and click on the Save button to commit your changes.
In the below screenshot, we can the SharePoint Online list description is updated.
This is how we can view and update the SharePoint Online list description.
Read How to Customize SharePoint Modern list form using JSON
Let us see how we can add and edit a column to a SharePoint Online list,
In the SharePoint list column, we can choose the data type of the column that we want. For example, if we want to add two or more options in the column then we can select the Choice as the column type.
Below mentioned are the available Column data types:
- A single line of text
- Multiple lines of text
- Yes/No
- Person/Group
- Choice
- Hyperlink
- Location
- Date and time
- Lookup
- Currency
- Image
Follow the below steps to add a column to a SharePoint Online list
- Open the SharePoint Online list, where you want to add a column. In this example, I am going to add a column to the Employee List.
- Now Select the +Add column and choose the data type of the column.
In the below screenshot, you can see that I have created a column with the choice column type.
- Enter the column name in the Name field which is required. The description field is optional.
- We can add the choices based on our requirements, by default it displays 3 Choices, if we want to add many choices we can add them by selecting the +Add Choice option.
- We can also set the default value for the column, by enabling the More options we can choose the display choices.
- There are two ways that we can display the choices, the one way we can display them is by using the Dropdown menu and the other way is using the Radio buttons we can display the choices.
- By default, it will be displaying the choices using the dropdown menu.
- Click on the Save button to add a column to the SharePoint list.
In the below screenshot, you can see that the EmployeerRole column is added to the SharePoint Online list.
Now select the item and click on the I circled icon to choose the EmployeerRole for the Employees.
In the below screenshot, you can see a new column is added to a SharePoint list.
Once the column is added we can edit the column by selecting the Column settings.
This is how we can add and edit a column to a SharePoint Online list.
Read Power Automate create an HTML table from SharePoint List
Let us see how can we make the field required in the SharePoint Online list,
- Open the SharePoint Online list and select the settings gear icon and click on the List settings as shown below:
In this example, I am going to change the Task Description field as a required field. When we try to add a new item to the SharePoint Online list. In the below screenshot, we can see that the Task Description field is not in the required field.
- In the list setting page, under columns select the field name that you want to change as a required field. Here, I am going to choose the Task Description field.
In the Edit column settings, Select Yes in the Require that this column contains information, scroll down and click on the Ok button to save your changes
Now if you navigate to the SharePoint list, you can see that the Task Description field has changed as a required field.
In the below screenshot, you can see the asterisk symbol in the Task Description field which defines the required field item.
This is how we can make the field required in the SharePoint Online list.
The below-mentioned table represents the SharePoint Server 2013 column limits,
The total count of all columns in a SharePoint list cannot surpass 8000 bytes. Each and every column has a size value detailed in bytes.
| Limit | Maximum Columns | Size per column |
| A single line of text | 255 | 30 bytes |
| Multiple lines of text | 350 | 22 bytes |
| Yes/No | 1000 | 7 bytes |
| Person/Group | 750 | 10 bytes |
| Choice | 255 | 30 bytes |
| Date and time | 550 | 14 bytes |
| Lookup | 750 | 10 bytes |
Let us see how to rename the SharePoint Online list title column and will also see what are the ways that we can rename the SharePoint online list title column,
There are two ways that we can rename the SharePoint Online list column, they are,
- By Clicking on the List title column
- Through List settings
By Clicking on the List title column
- Open the SharePoint Online list and select the title column dropdown.
- Now click on the Column settings and select the Rename option.
In this example, I going to rename the TaskList list title column to Employee Name in the SharePoint Online TaskList.
- A Popup appears to rename the list title column, Rename it and Click on the Save button.
In the below screenshot, you can see that the list title column is renamed as Employees Name.
This is the one way that we can rename the SharePoint Online list title column.
Through List settings
- In this example, I going to rename the EmployeeListDetails list title column to Employee Name in the SharePoint Online TaskList.
- Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
- Under Columns, Select the Title option.
In the Column name field, change the list title column name that you want to display as shown below, and scroll down and select the Ok button to save your changes.
In the below screenshot, you can see that the list title column is renamed as Employees Name.
This is another way that we can rename the SharePoint Online list title column.
These are the two ways that we can rename the SharePoint online list title column.
Read Power Automate update SharePoint list item
Let us see how we can change or increase the SharePoint Online list column width,
We can increase or change the column width of the list. To achieve this, follow the below steps:
- Select Site contents from the SharePoint page, and select the SharePoint Online list that you want to change or increase the column width.
- Expand the column width, using the mouse, the list view will be saved automatically.
This is how we can change or increase the SharePoint Online list column width.
Let us see how we can add, remove and view a SharePoint Online List to favorites,
Add SharePoint online lists to Favorites
- To add a SharePoint list to favorites, Initially Open the SharePoint Online list and Select the Star icon presented next to the SharePoint online list title.
- Once you selected it, it automatically adds the SharePoint list to the favorites.
This is how to add a SharePoint Online list to favorites.
Remove SharePoint online lists from Favorites
- To remove a SharePoint list to favorites, Open the SharePoint Online list and Select the Star icon presented next to the SharePoint online list title.
- Once you selected it, it automatically removes the SharePoint list from the favorites.
This is how to remove a SharePoint Online list from favorites.
View the Favorites SharePoint online lists
- To view the favorites SharePoint online lists, initially log in to Microsoft Office365 using your SharePoint credentials -> Select Office365 App Launcher and then click on the Lists.
Under Favorites, we can view the SharePoint online list which is added as favorites as shown below:
This is how we can view the SharePoint online list which is added as favorites.
This is how we can add, remove and view the SharePoint Online List to favorites.
Read How to customize a SharePoint List form
Let us see how we can insert an item into the SharePoint Online list,
- Open the SharePoint list, Where you want to insert an item, and Select the +New option.
A New item screen appears to insert an item, enter the values and then Click on the Save button. The New item will be inserted into the SharePoint Online list.
In the below screenshot you can see the newly created item is inserted into the SharePoint Online list.
This is how we can insert an item into the SharePoint Online list.
Let us see how we can Update an item into the SharePoint Online list,
There are two ways that we can edit and update an item in the SharePoint Online list, they are
- By selecting the Edit option
- By selecting i circled option
By Selecting the Edit option
- Open the SharePoint Online list and select the item that you want to Update.
- Now click on the Edit option Presented in the toolbar.
In this example, I am going to update an EmployeerRole from PowerApps Developer to the Python Developer for the employee called Shivam Dorga.
Now select an item and click on the Edit option as shown below:
Edit the value that you want to update and click on the Save button to save the changes.
In the below screenshot you can see the selected item is updated and reflected in the SharePoint Online list.
This is one way that we can update an item in the SharePoint online list
By selecting i circled the option
- Open the SharePoint Online list and select the item that you want to Update.
- Now click on the I circled option, in the properties pane we can edit the value that we want to update, it automatically updates the edited value.
In this example, I am going to update an EmployeerRole from Python Developer to the SharePoint Developer for the employee called Sonam.
- Now select the item and click on the I circled option.
- In the properties pane, edit the value that you want to update, it automatically updates the edited value.
In the below screenshot, you can see that the selected item is updated and reflected in the SharePoint Online list.
This is another way that we can update an item into the SharePoint Online list.
These are the two ways that we can update an item into the SharePoint Online list.
Let us see how we can delete an item from the SharePoint Online list,
There are two ways that we can delete an item from the SharePoint Online list, they are
- By selecting the Delete option
- By selecting the Vertical ellipsis option
By selecting the Delete option
- Open the SharePoint Online list and select the item that you want to delete.
- Now click on the Delete option Presented in the toolbar.
In the Confirmation box, Select Delete to remove or delete an item from the list.
In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.
This is one way that we can delete an item from the SharePoint online list
By selecting the Vertical ellipsis option
- Go to the SharePoint Online list and select the item that you want to delete.
- Now click on the Vertical ellipsis option and Select Delete.
In the Confirmation box, Select Delete to remove or delete an item from the list.
In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.
This is another way that we can delete an item from the SharePoint Online list.
These are the two ways that we can delete an item from the SharePoint Online list.
Read How to delete all items from SharePoint list
Let us see how we can delete multiple items from the SharePoint Online list,
There are two ways that we can delete multiple items from the SharePoint Online list, they are
- By selecting the Delete option
- By selecting the Vertical ellipsis option
By selecting the Delete option
- Open the SharePoint Online list and select the items that you want to remove from the list.
- Now click on the Delete option Presented in the toolbar, we can also able to view the selected items count on the toolbar.
In the Confirmation box, Select Delete to remove or delete an item from the list.
In the below screenshot, you can see the selected items are deleted from the SharePoint Online list.
This is one way that we can delete multiple items from the SharePoint online list
By selecting the Vertical ellipsis option
- Go to the SharePoint Online list and select the items that you want to delete or remove from the list.
- Now click on the Vertical ellipsis option and Select Delete.
- In the Confirmation box, Select Delete to remove or delete an item from the list.
In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.
This is another way that we can delete multiple items from the SharePoint Online list.
These are the two ways that we can delete multiple items from the SharePoint Online list.
Read SharePoint Online image column
Let us see how we can attach a document to the SharePoint Online list,
- Open the SharePoint Online list and select the item for which you want to add an attachment file.
- Now click on the Edit option Presented in the toolbar.
- Select the Add attachments option where we can add one or more attachments. We can also remove the attachments by selecting the X icon.
- Click on the Save button to commit your changes.
Once the file is attached you can see the attachment symbol under the Attachments column as shown below:
This is how we can attach a document to the SharePoint Online list.
- The maximum size limit for the files attached to the SharePoint Online list or the Microsoft list is 250 MB.
- The maximum size limit for the files uploaded to the SharePoint Online document library or the Microsoft team’s file tab or one drive folders is 250 GB.
- The File path filename cannot include more than 400 characters for one drive and SharePoint.
- A SharePoint list can have a maximum of 30 million items, and a SharePoint document library can have a maximum of 30 million files and folders.
Let us discuss what is list templates and why we use the list templates in the SharePoint Online list templates,
- SharePoint Online list templates help to use the predefined or pre-configured list layouts which include columns and the structure of the data.
- We can customize the pre-configured list as per our necessity.
- We can select any one of the list templates to create a new list from the templates as shown below:
In this example, I am going to select and use the Issue Tracker template list which helps to track and manage the issues. In the below screenshot, you can see that I used the issue tracker template and by default, columns are added to the list.
List Column details
We can also customize the list template columns. The below explains the issue tracker list column details:
| List Column | Column type | Description |
| Issue | Single line text | Issue Name. |
| Issue description | Multi-line text | Issue Description. |
| Priority | Choice | To track the priority of the issues as high, low, and medium. |
| Status | Choice | To track the status of the issues as completed, in progress, and not yet started. |
| Assigned to | Person | assigned to the person to track the issue |
| Data reported | Date and time | Date, when the issue is reported |
| Issue source | Hyperlink | Source URL where the issues are documented |
In the same manner, the remaining SharePoint Online list templates have the list column details, which you can choose based on the requirement and customize the list columns.
This is how we can use and work with the list templates in SharePoint Online.
Let us see how we can Show /Hide Columns in the modern SharePoint online list,
Show a Column in the Modern SharePoint
- Open the SharePoint list, Expand the Column and click on the Column settings, and select the show/hide Columns option.
- Now it will redirect to the edit view columns properties pane.
- Here we can select or choose the columns that we want to display in the SharePoint Online List view.
In this example, I have selected the ID and Created columns to be shown in the SharePoint online list.
- We can also reorder the items by easily dragging and dropping columns in the position we want to display, else we can use Move up and Move down the columns using up and down buttons.
- Select Apply to save your changes, so that they will reflect on your modern SharePoint online list.
In the below screenshot, you can see that the ID and Created columns are displayed in the SharePoint Online list.
This is how we can Show a Column in the Modern SharePoint online list.
Hide a Column in the Modern SharePoint
- Open the SharePoint list, Expand the Column and click on the Column settings, and select the show/hide Columns option.
- Now it will redirect to the edit view columns properties pane.
- Now uncheck the columns that you don’t want to display in the SharePoint Online List view.
In this example, I have unchecked the EmployeeCode and Attachments columns to be hidden in the SharePoint online list.
- We can also reorder the items by easily dragging and dropping columns in the position we want to display, else we can use up and down buttons next to each column.
- Select Apply to save your changes, so that they will reflect on your modern SharePoint online list.
In the below screenshot, you can see that the employee code and Attachments columns are hidden in the SharePoint Online list.
This is how we can hide a Column in the Modern SharePoint list.
This is how we can Show / Hide Columns in the modern SharePoint online list.
Let us see how we can delete a column in the modern SharePoint online list,
- Open the SharePoint list, Expand the Column that you want to delete or remove from the list and click on the Column settings, and select the Edit option.
In this example, I am going to delete the EmployeeRole column as shown below:
- An Edit column window appears, click on the Delete option presented at the bottom.
- In the Confirmation box, select Delete, it will remove or delete the column with data available on that column.
In the below screenshot, you can see that the EmployeerRole column was deleted.
This is how we can delete a column in the modern SharePoint online list.
Let us see how we can remove the title column from the SharePoint Online list,
- Once the SharePoint list is created by default the Title Column appears as the Required field as shown below:
In this example, we are going to see how we can remove the required title column from the List. Follow the below steps to achieve this:
Step:1
Open the SharePoint online list, select the settings gear icon and click on the List Settings.
Step:2
Select Advanced Settings, under the General Settings on the list settings page.
Step:3
In the Advanced settings page, enable the Allow management of content types to yes. Scroll to the bottom and click on the Ok button to save the changes.
Step:4
Now you can see, that the Content Types are added to the list settings page, Select Item under the Content-Type.
Step:5
In the List Content Type page, under Columns, select the Title presented.
Step:6
- In the Change Content-Type Column page, in the Column settings, select the Hidden option and Click on the OK button to commit the changes.
- You can also make the title column optional, for that select the optional option.
Step:7
Now Open the SharePoint list, and try to add a new item. You can see that the Required Title Column is disappeared in the SharePoint Online list as below:
This is how we can remove the title column from the SharePoint Online list.
Let us see how we can create an index column in the SharePoint Online list,
- When we are using a Large SharePoint List we can apply indexing in a column, it adds more privilege when we use filters. And also it supports the List view threshold limits when the 5000 data or items are retrieved from the SharePoint list.
- We can index to a maximum of 20 columns per list or Library. We cannot index for all types of columns.
- Automatic index design when sorting in the modern SharePoint is restricted to lists and libraries with shorter than 20,000 items.
The below-mentioned table represents the supported and unsupported column types:
| Column Index Supported Column types | Column Index UnSupported Column types |
| A single line of text | Multiple lines of text |
| Choice (single value) | Choice (multi-valued) |
| Number | Calculated |
| Currency | Hyperlink or Picture |
| Date and Time | Custom Columns |
| Person or Group (single value) | Person or Group (multi-valued) |
| Managed Metadata | External data |
| Yes/No | |
| Lookup |
Follow the below steps to create an index column in SharePoint online list:
- Open the SharePoint online list, select the settings gear icon and click on the List Settings.
- In the list settings page, under columns, Select the Indexed Columns option.
- On the Indexed Columns page, click on the Create a new index option.
- Now In the Edit index, select the column for which you want to apply the column indexing, and Click on the Create button.
- In this example, I have selected the EndDate Column to apply column indexing.
In the below screenshot, you can see that the Column indexing has been applied to the EndDate Column.
This is how we can create an index column in the modern SharePoint online list.
Let us see how we can find the List-Id for the Modern SharePoint Online List.
- Open the SharePoint online list for which you want to find the List id, select the settings gear icon and click on the List Settings.
In this example, I am going to find the List id for the Task List that I have created on my SharePoint site.
- Copy the URL, you can see some text after List= which defines the List-Id.
- Now Remove “%7B” from the starting of the List id. And also remove “%7D” from the end of the List id.
- If %2 is presented in the List id, then replace it with a hyphen.
For this example, List id is 62eb7cf7-6544-4241-a866-a42ebb5ad5b6.
This is how we can find the List-Id for the Modern SharePoint Online List
Let us see how we can export the SharePoint Online list to excel,
- Open the SharePoint online list that you want to export, Expand the export option available in the toolbar.
- Now select to Export to Excel option, and the SharePoint list will be downloaded as the Excel File.
- Once you open the excel file, you can see the columns and data presented in the list will also be presented in the excel file.
This is how we can export the SharePoint Online list to excel.
- In the Modern SharePoint, multiple lines of text can store a maximum of 63,999 characters.
- So we don’t want to enable the option to save more than 255 characters in the SharePoint online list in Multiple lines of text column.
- We can also assign the specific text that is to be displayed like Plain text or Rich text like Bold, Italics, text alignments, and hyperlinks, and also we can append changes to the existing text.
- The user needs permission to add or delete list item comments and the editing comments are not available currently.
Let us discuss how we can add, reply and delete the selected list items comments in the SharePoint Online list,
- Open the SharePoint Online list and select the item for which you like to add a comment.
- Once the item is selected from the list you can see the Comment icon appears in the toolbar.
- At a time we can add comments for a single item in the SharePoint list, and we cannot select multiple items to add a comment to the list.
- If you don’t see the comments option once the item is selected, then the admin would have a disabled commenting section.
Add a Comment
Let us see how we can add a comment for the selected item in the SharePoint online list,
- Open the SharePoint Online list and select the item for which you want to add a comment.
- Select the Comment icon that appears in the toolbar, once the item is selected from the list.
- On the right-hand side, the comments pane appears where we can type the comment in the Comment box and Click Enter or select the send icon.
In the below screenshot, you can see that the comment is added as expected.
This is how we can add a comment for the selected item in the SharePoint online list.
View and Reply to Comments
Let us see how we can view and reply to a comment for the selected item in the SharePoint online list,
- Open the SharePoint Online list and select the item for which you want to add a reply comment.
- Select the Comment icon that appears in the toolbar, once the item is selected from the list.
- In the Comments pane, type the comment that you add as a reply comment in the Comment box and Click Enter or select the send icon.
- To hide or Show the comment pane, select the comments icon that appears at the top of the comments pane.
This is how we can view and reply to a comment for the selected item in the SharePoint online list.
Delete a Comment
Let us see how we can delete a comment for the selected item in the SharePoint online list,
- In the comments pane, Select the comment that you want to delete, and click on the delete icon to delete it.
- We cannot delete multiple comments, at a time we can delete a single comment only.
- In the confirmation box, select Delete to remove or delete the comment.
In the below screenshot, you can see that the comment is deleted.
This is how we can delete a comment for the selected item in the SharePoint online list.
Use @mention in comments to mention someone
Let us see how we can mention the user in a comment for the selected item in the SharePoint online list,
- In the Comments pane, we can use @ sign to mention someone in the comment. The mentioned user will receive an email notification with a link to the mentioned comment.
- Mention @ and pick the name that you want to mention in the comment.
In this example, I have mentioned the User2 as shown below:
Once you Send the Comment, a pop-up appears to Grant access to the comment. The mentioned user will receive an email notification with a link to the mentioned comment
This is how we can mention the user in a comment for the selected item in the SharePoint online list.
This is how we can add, reply and delete the selected list items comments in the SharePoint Online list.
When we try to create a new column in the modern SharePoint list, by default we can see two things they are,
- Column Internal Name
- Column Display Name
It is possible to change the Column display name and it is not possible to change the column’s internal name.
In a Modern SharePoint list, we don’t need to encode the list column names escape codes, by default it removes the space for the column internal name.
For example, Before creating a column, if we leave spaces in between in the column name, the empty spaces will be encoded as %20 in the column internal name. After the Updation, when we create a column with spaces in the Column name, In a Modern SharePoint list, we don’t need to encode the list column names escape codes, by default it removes the space for the column internal name.
Let us see how can we create an attachment column in the modern SharePoint online list,
- Open the SharePoint list Where you want to add or create an attachment column in the SharePoint Online list.
- For example, In the below screenshot, you can see that there is no attachment column in the SharePoint online list.
- Once the SharePoint online list is opened, Expand any one of the columns and click on the column settings, and Select Show/Hide columns option as shown below:
In the Edit view columns, Search for Attachments, select the Attachments checkbox, and click on the Apply button to save your changes.
Now in the below screenshot, you can see that the Attachments column is added.
This is how can we create an attachment column in the modern SharePoint online list.
Let us see how we can add folders to the SharePoint Online list,
- Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
Select Advanced Settings, under the General Settings on the list settings page.
In the Advanced settings page, enable the Make a New Folder to yes. Scroll to the bottom and click on the Ok button to save the changes.
Now you can see the Folder option is Presented, under the + New option.
Select the Folder option to Create a folder and click on the Create button.
Here in the below screenshot, you can see that the folder is created in the modern SharePoint list.
You can see that the folder is created in the modern SharePoint list, where we can add some list items inside the folder.
This is how we can add folders to the SharePoint Online list.
Let us discuss how we can hide folders in the SharePoint list and display all the items presented inside the folder,
Yes, it is possible, to hide the folders and display the items in the SharePoint Online list.
- Open the SharePoint Online list for which you want to hide the folders and click on the Settings Gear Icon and select the List Settings.
In this example, you can see I have added the Employee called Tanya inside the Sample Folder in the SharePoint Online list.
In the list settings page, select the All items under the Views option as shown below:
- Now in the View settings page, expand the Folders and Select the Show all items without folders option.
- Click the Ok button to save your changes.
Now in the below screenshot, you can see the Sample Folder is hidden or disappeared and the item is displayed in the SharePoint Online list.
This is how we can hide folders in the SharePoint list and display all the items presented inside the folder.
No, it is not possible to display the attachment name in the SharePoint Online List.
- In the Modern SharePoint Online list, Currently, there is no option to display the attachments name.
- Only we can see the paper click icon in the attachments column when the file is attached for the list items.
Let us see how we can enable the geolocation field in the SharePoint online list,
- We can add the geolocation field column in the SharePoint online list as well as the SharePoint online library.
- SharePoint location column permits us to add location data from the Bing map.
- SharePoint location column includes fields such as city, Street address, religion or country, state, postal code, and Name.
- In the list view, we can also sort, filter, or even search with the location data such as address, city, street, state, etc.
Follow the below steps to enable the geolocation field in the SharePoint Online list:
- Open the SharePoint Online list, Select +Add Column to add the location field column.
- Enter the Name of the Location column in the Name field, and you can add a description that is optional.
- We can also select the linked columns to be displayed in the current view. In this example, I have selected the linked columns as Street Address, City, State, and Postal Code.
- Then click on the Save button.
In the below screenshot, you can see that the Employee Location is created with the selected linked columns.
- Now Select +New to add a new item to the SharePoint Online list. You can see in the Employee Location field, we can add the location in the text box.
- We can also use the Use this location option to detect the current location.
Once the Location is Selected, Click on the Save button.
In the below screenshot, you can see that the new item is added with the Employee location and the selected linked columns like city, state, postal code, etc.,
This is how we can enable the geolocation field in the SharePoint online list.
- A SharePoint list can have a maximum of 30 million items, and a SharePoint document library can have a maximum of 30 million files and folders.
- The File path filename cannot include more than 400 characters for one drive and SharePoint.
Let us see, how to change the width of the list view column in SharePoint 2013 using SharePoint designer 2013. We will also see, how to increase the SharePoint list title column width using jQuery.
Recently in a business requirement, we got to increase the width of a SharePoint list view column.
Here I have a SharePoint list that has one column named as “CreatedByFirstName” the width is a bit bigger and it looks like the below:
Now Open your SharePoint site using the designer. Open the particular list and then in the list settings page, select the particular view, right-click and then edit the file in advanced mode.
Once it will open in advanced mode, From the ribbon select the Design tab in the LIST VIEW TOOLS section. And then click on Customize XSLT -> Customize Entire View as shown in the fig below. If you are not able to see the LIST VIEW TOOLS tab then, you can follow the List View Tools tab missing in the SharePoint designer 2013 article.
Then in the whole file search for the below text.
<th nowrap="nowrap" scope="col"Above to the line, you will see the below similar kind of line based on your column name.
<xsl:template name="FieldRef_header.CreatedByEmail" ddwrt:dvt_mode="header"Here the column name is “CreatedByEmail”
Then we need to put the style attribute in the below <th line like below:
<th nowrap="nowrap" scope="col" onmouseover="OnChildColumn(this)" style="width:100px;">I have set the header to be 100px for this column. Similarly, you can define other columns as well.
Then save the page and refresh the view, your width should be displayed like below:
This is how to change sharepoint list column width using SharePoint designer.
Now, we will see how to increase the SharePoint list title width using jQuery. The same jQuery code can be used to increase the list title column in SharePoint 2013/2016/2019 or SharePoint Online.
By default if you will open a list view, the title column width looks like the below:
Open the SharePoint 2013 list view page, here I want to change in the AllItems.aspx page. Then Edit the page and then add a script editor web part. In the Script editor web part, put the below lines of code. Then Save the Page.
Below is the full code to increase the width of the SharePoint list title column using jQuery.
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("TH.ms-vh2:contains('Title')").css("width", "300px");
});
</script>Now the List title column width will look like below:
This is how to adjust column width in sharepoint list without designer.
In this tutorial, we learn everything about the SharePoint Online list. We covered:
- What is a list in SharePoint Online?
- How to create a SharePoint Online list
- Create a SharePoint list from a Blank list
- Create a SharePoint list from Excel
- Create a SharePoint list from an existing list
- Create a SharePoint list from a Template
- How to Rename SharePoint Online List title
- How to update SharePoint Online list description
- Add a column to a SharePoint Online list
- SharePoint Online List Column limit
- Rename SharePoint Online List Title column
- How to Change SharePoint Online list column width
- How to favorite a SharePoint Online list
- How to insert an item into the SharePoint Online list
- How to Update an item in the SharePoint Online List
- How to delete an item from the SharePoint Online list
- How to delete multiple items in the SharePoint Online list
- Attach a document to a SharePoint Online list
- SharePoint Online list attachments size limit
- SharePoint Online List Templates
- Show/Hide Columns in a Modern SharePoint Online List
- How to delete a column from a SharePoint online list
- SharePoint online list Remove Title Column
- How to create an index column in SharePoint online list
- SharePoint Online List id
- Export SharePoint online list to excel
- SharePoint online lists Multiple lines of the text character limit
- SharePoint Online list item comments
- SharePoint online list column names escape codes
- How to create an attachment column in SharePoint online list
- Add Folders in SharePoint online list
- SharePoint online list hide folders
- Display attachment name in SharePoint online list
- How to enable the geolocation field in the SharePoint online list
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com
good presentation