How 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. P
🔌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.
Help 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!
name 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 PebSet 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? ThanksMigrating 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? Thanks
Map 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.
