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? Thanks62Views0likes13CommentsSharepoint comment permissions by users
Hi, Is it possible to restrict specific user accounts from being able to add comment on pages?Solvedb_oconnorFeb 14, 2025Copper Contributor3.6KViews0likes5CommentsSharepoint central IT management best practices
Hi, At my company, we would like to use our corporate SPO infra more and more to diminish our local storage needs and foster collaboration but the problem is that we are having a huge sprawl and we don't have any control of what is being published like confidential stuff, documents with personal data in them, DBs etc. Is there a paper with Central IT SPO management best practices that can help us controlling/avoiding this type of situations? Thanks/Brgds jcjcasqueiroFeb 14, 2025Brass Contributor8Views0likes0CommentsExport or compile wiki pages into a PDF or Word
Hi, I am looking to start using SPO wiki as our document management solution. This means that articles will now take form of a wiki page. Often we create configuration guides (to be used internally) (similarly to Confluence). I was planning to suggest the use of wiki for this same effect. The key dependency there is that we need: the ability of creating different level of sub-pages; the ability to export a document (which can be collection of wiki pages at different levels) into a pdf or word Can this be achieved in Sharepoint Wiki and if yes how? Thanks XavierDsouzafyiRuka_ZillFeb 14, 2025Brass Contributor18Views0likes2CommentsColumn formatting editProps stopped working
Hi, We use custom column formatting to add a pen icon next to the document name. When clicking on the pen, the edit form opens. Today we noticed this stopped working. Did anything change? What can we do to fix this? Thanks in advance. Kind regards, SDBRSDBR1455Feb 14, 2025Copper Contributor252Views2likes6CommentsDate 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.jensjakobsen1966Feb 14, 2025Brass Contributor171KViews1like18CommentsMicrosoft 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 14, 2025Occasional Reader45Views1like7CommentsPagination using SharePoint online rest API to get listitems.
The only implementation I see is by using Odata.nextlink. Does pagination support page number pagination by any chance? I have not been able to find any concrete documentation regarding skip,Skiptoken since what i see its only recommended using odata.nextlink. How do we achieve page number pagination?SurajRautDevFeb 14, 2025Copper Contributor20Views0likes0CommentsHow to patch attachments into a SharePoint list
I have a new form (Form1) that has all my fields contained. I can patch these fields into a new record and it works fine. Now I want to patch a second form (Form2), which contains attachments, into the same record. I have found several advise pages that say to use "Form2.Updates" in my patch function. i.e. Patch(SharePointList,Defaults(SharePointList),{FieldName: DataCardValue1.Text},Form2.Updates Here is the code: Patch( 'SOW Requests', Defaults('SOW Requests'), {SOW_Name: DataCardValue27.Text}, {'Estimated Cost':Value(DataCardValue14.Text)}, Form3.Updates ) The "Form3.Updates" is showing as an error. Any suggestions?JimJ2380Feb 14, 2025Copper Contributor231Views0likes1CommentMigrating 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 Contributor17Views0likes2Comments
Resources
Tags
- SharePoint Online17,657 Topics
- Document Library3,038 Topics
- Lists2,975 Topics
- Sites2,439 Topics
- admin2,171 Topics
- sharepoint server1,979 Topics
- Permissions1,902 Topics
- files1,619 Topics
- developer1,511 Topics
- microsoft lists1,450 Topics