Lists
3024 TopicsHow to set a SharePoint list to be sorted by today's date as the default?
I have a SharePoint list which contains a column DateTime called Datum. How can i sort the list on Today's date. I.o.w: how can i make the row of Today's date on top of the list. Maybe in the JSON-code? Gr. p8Views0likes0CommentsHow to put the today's date as default in the list cell?
I have a SharePoint List with just one column called "CustomDate" with type Date/Time. And i have inserted just one row for displaying the date. I have found code from the Github to display a DateTimePicker from the List cell itself. Only when i click on the cell the DateTimePicker appears with the today's date. But the Today's date is default in the EditField. I know this line has to be customized. But i do not know how: "txtContent": "=toLocaleDateString(Date([$CustomDate]))", "inlineEditField": "[$CustomDate]" How can i make the date default in de editbox? This is the whole code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "div", "style": { "font-size": "12pt", "padding": "5px" }, "txtContent": "=toLocaleDateString(Date([$CustomDate]))", "inlineEditField": "[$CustomDate]" } ] } Gr. P20Views0likes0CommentsMicrsoft Loops Vs SharePoint for building knowledge base
I usually create knowledge bases for the company using SharePoint, because of those main reasons:- we can have hubs and sites linked to the sites, then we can define search hub-scoped ability to add web parts inside pages and show certain content based on their content types each component inside SharePoint can have unique permission including site, lists, libraries, documents, items and folders we can share with internal/external users there is a built-in SharePoint mobile app can customize certain lists using power apps and apply approval and workflow using power automate can have the knowledge as documents or pages or both of them ability to easily move documents between sites apply custom metadata to documents and pages and much more now i want to start a new project for a client, and they mentioned about Microsoft loops, so i am not sure does Microsoft loops provides all of the above features? i checked some documentation and tutorials and seems it more like a single SharePoint page for live collaboration but not for building an enterprise knowledge based ,, am i correct? ThanksSolved49Views0likes2Comments🔌How to work offline with Microsoft Lists [No Internet Connection]
NEW VIDEO N. 151 In this video tutorial, you’ll learn how to work offline with Microsoft Lists, thanks to a sync mechanism that runs on the local device and update all changes performed by the user on the cloud. I’ll walk you through every step of installing Microsoft Lists as a Progressive Web App and working with it offline.16KViews3likes10CommentsHelp Linking SharePoint Lists
Hello SharePoint Community, I've recently been working more with SharePoint lists, but I've hit a roadblock and could use some guidance. What I'm Trying to Achieve I need to create a structure where: Users can create new projects for the company. Each project can have multiple initiatives associated with it. The Challenge Since users manually input data, I can't rely solely on field values to establish links between projects and initiatives. Instead, I need an automatically generated unique ID in SharePoint to connect the lists. (I think this already happens, but I don't know how to use it properly) The Ideal Setup When a user creates a new project, SharePoint should generate a unique ID. There should be a button to add initiatives to the project, ensuring they are correctly linked. Possible Solutions? Is there a way to achieve this natively in SharePoint, perhaps using lookup columns, calculated fields, or even Power Automate? Would Power Apps be a better approach to provide a user-friendly interface for registering projects and their related initiatives? What are the best practices to ensure data consistency and prevent duplication? I’d really appreciate insights from anyone who has tackled a similar scenario. Thanks in advance for your help!70Views0likes6Commentsname of user/group-field is displayed incorrectly: i:0=.f|membership|email address removed for privacy reasons
Hello everyone, on Lists formular, the user/group field is displayed as "i:0=.f|membership|email address removed for privacy reasons" instead of the username. What am I doing wrong or how can I change it? Thanks in advance. Greetings PebSolved2.4KViews0likes5CommentsSet Unique value based on the (CreatedDate & CreatedBy)
We want to create a SharePoint online custom list with these business logic:- Users enter an entry each day to specify their location (which site they are working in).. No one can see other entries, except for an admin group of users. No one can submit twice per day, in other words, the list should enforce a uniqueness based on the CreatedDate + CreatedBy. So I am planning to follow this approach:- First step, is to create a custom list, then check these checkboxes:- Second Step:- then create a SharePoint group , named "View/Edit all items", and create a custom permission level which is a copy of the built-in contribute, with this checkbox checked:- so based on my knowledge, this should cover part of the requirements, for allowing users to only see and edit their own items + allow a group of users who are assigned the new custom permission level to view/edit all items. But what abut preventing the same user from adding 2 entries inside the custom list twice on the same day? i know that using remote event receivers which runs on pre-add and pre-update events are no longer valid and no longer a future proof approach.. so the only option i can think of, is to have a power automate flow that runs when an item is created >> where the flow will get any item which was created on the same day and by the same user (of course excluding the current item), if so to send an email to the user that he added duplicate items + to force deleting the item.. but this will not be a 100% enforce uniqueness but rather a way to inform the user about a duplicate.. so is there a better approach to enforce uniqueness in our case, using calculated columns in a way or another? Also using power automate, i am not sure if this will cover a scenario such as where the flow detect a duplicate >> delete the item >> but then the user restore the item from the recycle bin? Thanks78Views0likes13CommentsDate 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.171KViews1like18CommentsMigrating Excel to Sharepoint list [basic import]
Hi, I have looked on the community for views on this, but I think that my question is high level and probably basic for what I have found so far. Asking here. I am trying to migrate a list from a SaaS tool into SPO List. I can export the list into .csv or .xls format for import in SPO. On our first trials, all seem to work. we found a challenge with the SPO list field types, which we later fix manually after the data is imported and the columns created. The problem that I am facing is that some columns are created with a col type which is not what we need, and we CANNOT edit the col to change the type. Initially I suspected that during the import SPO used a predefined col which can not be changed, but I found more then 1 or 2 cases in the same list. Have you seen this before and what have you done about it? Thanks20Views0likes2CommentsMap Views in SharePoint online
Hi team my first post here... Can someone point me in the direction of the steps to follow to setup SharePoint online so that map views on custom lists display all the locations of list items in a view as pins on a map? There is info on-line showing how to set up Bing maps but they are deprecated with Azure replacing them - I think. So - again, I think - I need to configure map views in my sharepoint on-line site to work with Azure. It looks as though the 'Location' column type is not available in out-of-the-box custom list maintenance in SharePoint on-line. I managed to create a Location type column in my custom list with 'add column' on the right most side of a view - but the longitude and latitude aren't populated when i select the address for each item. Might that be fixed once map integration is in place? My end goal is to display the location of each custom list item on a map. If Azure maps aren't the best way to achieve this then what should I use? Any help much appreciated.127Views0likes3Comments