Lists
3037 TopicsImport excel into existing list (with data already in it)
Hi, Is it possible to import data from an excel sheet into a SharePoint list that already contains data in it? Basically I just want to add to the list that's already in SharePoint without overwriting the existing lines or having to create a new list each time. Thanks!Solved585KViews1like52CommentsAuto-Increment Number Field in a SharePoint List
I need to create an auto-increment field with a standard amount of digits. The format needs to be like this T000001, T000002, T000003, ......T000010, etc (7 Digits). When it gets to the 10th record it should not do this T0000010 (8 digits). I tried using the popular, often referenced solution (link below). This method does not work as I hoped. If you put it in a format like this T1000, when it gets to the 10th item it does this T100010 rather than T10010. Here is the popular solution I already tried: https://www.epmpartners.com.au/blog/how-to-create-an-auto-incrementing-number-field-in-a-sharepoint-list/Solved331KViews1like26CommentsHow To Add A Calendar To A SharePoint Online Site
This Sharepoint tutorial will demonstrate how you can add a calendar to a SharePoint Online site. The approach used in this tutorial creates a Sharepoint List and applies a calendar view to it. The list can then be added to pages on the Sharepoint Online site and can also be added to channels in Microsoft Teams. One major limitation with this approach is that the calendar cannot be synchronized with Microsoft Outlook as with the legacy calendar webpart. How To Add A Calendar To A SharePoint Online Site224KViews1like0CommentsIntroducing "Request sign-off" - an approval flow that requires no set up
We are happy to announce a new feature in SharePoint called "Request sign-off". The goal is to provide you an easy way to send an item for approval to someone else. This feature enables an open approval process that allows you to easily record whether or not a document or list item was approved or not. There is no setup required. Request sign-off makes use of SharePoint's integration with Microsoft Flow. You can use it by selecting a file or list item (but not a folder), and then pulling down the Flow menu in the modern library or list UI, and selecting "Request sign-off". This flow will appear alongside any other custom flow that you or others may have added to the library. Once it is invoked, Request sign-off will create a new text column in your library called "Sign-off status". This column will record the state of your request. It works just like any other text column, you can sort, filter or group by it to organize your library. On invocation, this will tell you that it will send an approval request on your behalf, and ask your consent. Once this is provided, you can pick one or more approvers, and write a message to them for your approval request. If you add more than one approver, any one of them can approve your request: The person you sent the approval to will receive an approval request. This will be an actionable message on clients that support it (meaning you can approve it directly from within Outlook). The approver can also provide some comments along with their decision. There will also be a link included that lets the approver view the item in question: The sign-off status column is then updated with the decision, and the person who sent the approval request will receive an email with the comments: By saving you the trouble of setting up a flow and creating a new column to track status, we hope that this feature will make it easy to add a lightweight approval process to your libraries and lists. We expect this feature to start rolling out to our customers in targeted release (previously called first release) after April 9. Barring any issues we will continue to roll it out to the rest of our customers in two phases late April and early May.Date format needs to be DD/MM/YYYY
Hi When you create a new date column in SharePoint, the default format is MM/DD/YYYY. However, I live in a country where we use DD/MM/YYYY, and changing in the default format into that is not approved by SharePoint - look at the screendump.174KViews1like18CommentsRole of "Title" Column in SharePoint Lists - Can't change column type?
When I start a new list in Sharepoint, I always get a "Title" column and I can't change the type from the default "Text" type. What is the role of the "Title" column? I'd like my first column to be a date column but can't seem to figure out how to make that happen. Thanks for any help.165KViews0likes16CommentsOrganisation Chart in O365/ SharePoint
We're currently looking at having an organisational chart for our company, which display the structure of teams etc. and individual staff info. Ideally we want this to be accessible via our SharePoint intranet, either as a link or embedded frame. Does anyone know of an 'out of the box' solution for this? I know there is the O365 People app, which is basically pulling from AD/ the address book, however it doesn't show a chart when you click on an individual. So if there is an O365 solution that would be good, or if anyone knows a 3rd party software that does the job that would also be good to know. Any help would be much appreciated! Michael Butterfield Rugby Borough Council156KViews4likes52CommentsAll you need to know about Commenting in SharePoint / Microsoft Lists
Microsoft introduced a new feature of Commenting in SharePoint Online lists and Microsoft lists. Using this feature users will be able to add and delete comments on list items. Users can view all comments on a list item and filter between views that show comments or activity related to an item in details pane. Microsoft rolled out this feature to all SharePoint Online tenants in December 2020 release, see Microsoft 365 Roadmap. Check this articles for more information and step by step tutorials: All you need to know about Commenting in Lists How to Enable/Disable the commenting in SharePoint Online/Microsoft Lists Enable/Disable the comments for individual SharePoint Online/Microsoft List Working with SharePoint Online/Microsoft List Comments using JSON Formatting GET SharePoint list item comments using REST API Add Comments on list item using SharePoint REST API Delete Comments from list item using SharePoint REST APISolved139KViews3likes37CommentsSave list as template on modern team site
Wonder if anyone can advise how I can create a list in a modern sharepoint team site from a template that I saved from a classic team site. I don't see any option from within powershell settings. I have been getting my head around all the various sharepoint resources and have been creating lists etc on my classic team site for now but our users are starting to use the modern team sites created from Office 365 groups and I really would like to have them use some of the list templates I've created. Any help appreciated.104KViews1like26Comments