Forum Widgets
Latest Discussions
Set 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? Thanks43Views0likes10CommentsMigrating 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? ThanksRuka_ZillFeb 13, 2025Brass Contributor13Views0likes2CommentsHow we can handle sub-departments when using document sets
We want to implement a document set to store our departments documents, currently we need to start with those departments and sub-departments:- IT (Development sub-department + Project management sub-department) Marketing (Customer sub-department + Internal sub-department) Finance (Private sub-department + Public sub-department) PMO (Private sub-department + Public management sub-department) so now i am planning to create 4 document sets:- IT Marketing Finance PMO and 4 content types which have built-in documents content type as its parent:- IT Document Marketing Document Fiance Document PMO Document and define those custom content types inside the related document set content type based on the related department. so for example the IT Document content type will be defined inside the IT document set as so on.. but what i am not sure about is how we can implement the sub-departments? should they be completely separate document sets? or we can define sub-document sets to be defined inside another parent document set? any advice? Thanksjohnjohn-PeterFeb 13, 2025Iron Contributor13Views0likes1CommentMicrosoft Lists not allowing creation of new item
For more than a few days now when clicking on the [+ Add New Item] button it does nothing. Looking at the Console I see it producing the error shown below. I've tried incognito mode with no help on Edge and Chrome on Win 11pro... 5 other users on different machines are experiencing the same thing. Anyone else experiencing this or know if this is a known issue being worked on? Thanks!PGOFeb 13, 2025Occasional Reader25Views0likes5CommentsSharePoint property panel allow us to change a Shared document set column
I have a document set content type named DS123, and it contains 2 custom columns D1 & D2 as follow:- then i created a content type named "D" which contain a custom column named "D3":- and define it inside the document set content type + i define the D1 as a shared column, as follow:- now i created a document set folder based on the DS123 , then i added a document inside it based on the "D" content type. then i selected the document, where i will get those columns (D1 -the shared column- & D3), as follow:- but the modification i do inside the D1 columns will not get applied, unlike the modification to the D3 column.. so what is the reason? is this that the D1 is a shared column from the document set? if this is the case, then how we can disable the field inside the property panel? Thanksjohnjohn-PeterFeb 13, 2025Iron Contributor9Views0likes0CommentsModern PnP Search Web parts
Hi, I've recently built a SharePoint Online based People Finder Tool for my Company using the Modern PnP Search Web Parts. It is working fine, apart from one annoying glitch that I can't seem to find a solution to. If a colleague searches for another colleague by last name (e.g. Smith, Wilson) it returns results as expected. But if a colleagues searches for another colleague using a last name that is also a common English word (e.g. Black, Brown, Snow, Blow, White) it returns no results. Unless a comma is placed after the name (i.e. Black, or Snow,) in which case it returns results as expected. The same behaviour isn't happening on a Teams search, so it's specific to the PnP Web Part for some reason. I am tearing my hair out trying to find a cause and/or solution. If anyone has come across it and can help it will be very much appreciated. Thanks in advance.Matt9915Feb 13, 2025Copper Contributor9Views0likes0CommentsHelp Needed: Calculating Difference Between Two Date Columns in MS Lists
Hi everyone, I'm having trouble calculating the difference between two date columns in Microsoft Lists. Every time I try to use a formula, I get the following error: Sorry, something went wrong. The formula contains a syntax error or is not supported. Here are some of the (AI-generated) formulas I've tried: Basic Difference Calculation: =IF(ISBLANK([End Date]) OR ISBLANK([Start Date]), "", [End Date] - [Start Date]) =IF([End Date] >= [Start Date], [End Date] - [Start Date], "") Using DATEDIF Function:=IF(ISBLANK([End Date]) OR ISBLANK([Start Date]), "", IF(DATEDIF([Start Date], [End Date], "d") < 0, "", DATEDIF([Start Date], [End Date], "d"))) Checking for Valid Numbers:=IF(AND(ISNUMBER([End Date]), ISNUMBER([Start Date])), IF([End Date] - [Start Date] < 0, "", [End Date] - [Start Date]), "") Simple Blank Check:=IF(ISBLANK([End Date]), "Empty", "Filled") Despite trying these formulas, I keep encountering the same error. Both [End Date] and [Start Date] are date fields. Has anyone else experienced this issue or have any suggestions on how to resolve it? Any help would be greatly appreciated! Thanks in advance!vchrnkFeb 13, 2025Occasional Reader19Views0likes3CommentsMap 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.GC005Feb 13, 2025Copper Contributor116Views0likes3CommentsWorkflow task list
Hi, I'm aware that SharePoint Designer will be retired next year in April. A customer of mine wants to keep his SharePoint Office 365 site with a number of workflow tasks list. Will these task lists still be available or are these "task lists" also removed when SharePoint Designer retires ? Will I still be able to create a new SharePoint task list once SharePoint Designer is retired ? Thank you, MarcMarc NemegeerFeb 13, 2025Brass Contributor23Views0likes1Comment
Resources
Tags
- SharePoint Online17,654 Topics
- Document Library3,037 Topics
- Lists2,975 Topics
- Sites2,439 Topics
- admin2,170 Topics
- sharepoint server1,979 Topics
- Permissions1,902 Topics
- files1,619 Topics
- developer1,511 Topics
- microsoft lists1,450 Topics