microsoft lists
1500 TopicsTitle field in Lists - cannot make the field required
My organization has been using Lists for its time tracking & workplan for a few years. Previously the Title field was required by default when a new list was created. Recently when creating a new list (from an existing list on which the title was a required field), I noticed that the title field is no longer required. There is no option to edit the column to make the title required. Is there any workaround or JSON code that I can use to make this field required for my users? Thank you.9Views0likes0CommentsCommandBarProps questions
Hi, I try to remove all SP list view buttons from a list except "New" and "Edit" and using JSON. I have not found a way to remove the "Automate" menu item and the submenu item "Set a reminder" in my view. I havent found a corresponding key for "Set a reminder" item. Here is the code I use: any ideas, how to get rid of the "Automate" menu item or at least of the "Set reminder" sub menu item ?? ciao alex.34Views0likes2CommentsAllow Non-Owner Members to Share Edit Privileges with their own List & Libraries
I manage a SharePoint site where we want members to access only content they need access to. Each member is assigned to a portal based on their location in Entra ID. To allow users to work together on projects we need user to be able to share document libraries and list with edit rights. Right now users can share their own created list and libraries, but the invited users only have read permissions. Is their anyway to set it to where they can also have edit permissions. We don't every user to be a an owner of portal sites.19Views0likes1CommentConnected Sharepoint to a Postgree database
Hello, I would like some help in connecting a PostGree database to SharePoint. I would like to be able to use the data contained in this database in lists. I should point out that I have no particular expertise on the subject. I would gladly accept a step-by-step guide. 😅10Views0likes0CommentsMulti Line Column + Enhance Rich Text Formatting being lost
Hello, say I have a multi line column + rich text enhanced in a SP list. I have a few paragraph with a bold header at the top of each paragraph. When another user goes in and edits the cell, the bolding goes away. and sometimes the paragraph collapse into 1 big paragraph with out my previous spacing. Whats going on here? What can i do to prevent this?24Views0likes1CommentDeleting old rows from a SharePoint list
Hi, I am using a SharePoint site as a database for a desk booking system. The data is held in SharePoint lists. I want to delete old data, i.e. items older that 1 month Is there an easy way to do this?, the list contains thousands of records from the past 4 years. Thank you for your time, Ollie44Views0likes1CommentPerson column value changes after saving
We have a List in our SharePoint with columns for selecting people within our company. A weird thing we found is that, if we select a guy named Anmol, and once we save it, a different name ends up being selected. See gif below. Anmol and Amitjot are different people with the same last name (which I thought I should blur out). I can't find Amitjot in our Azure AD, not even in the deleted user list. This only happens to this Anmol guy as far as we know. I created a new List with a person column to test, which did not have this problem. We mainly use a Power Apps form to populate this List, which also has this problem. Normally, whenever I select a person, it will save to the List, but in the gif when I selected Anmol, it did not save, so I changed the description slightly to trigger the save.69Views0likes3CommentsCalculate Sports Division based on DOB
I have the following excel formula that works fine however I am trying to get to work in a SharePoint list: =IF(ISBLANK(B1),"",MAX(IF(MOD(IF(MONTH(B1)>8,0,1)+(YEAR(NOW())-IF(MONTH(NOW())<9,2,1)-YEAR(B1)),2)>0.5,1,0)+IF(MONTH(B1)>8,0,1)+(YEAR(NOW())-IF(MONTH(NOW())<9,2,1)-YEAR(B1)),6)) Instead of the B1 reference I have a column in the list called DOB. I would like to calculate the division based their DOB. I tried substituting $DOB for B1 but that did not work. If there is a better way to do this other than trying to fit the formula above I'm open to it. Essentially I need to calculate the persons age as of 9/1 of the current year. And based on that calculated age they would fit in the following divisions: Age as of 9/1/23 6U - Age <6 8U - Age 7-8 10U - Age 9-10 12U - Age 11-12 14U - Age 13-14 16U - Age 15-16 18U - Age 17-18 Thank you in advance.Solved709Views0likes3CommentsList and sublist; Is this possible?
We want to make an order list, but an order might have several suborders. As an example, an order is inputted. Say 'Entertainment Set' which consist of a TV, Stereo and extra items. Is it possible to create a sub list of the additional items to track? Say the total price is $1000 and only the stereo ships, can we make it as $200 Stereo shipped and received. I have tried YouTube and Google with no luck.40KViews0likes5CommentsSharePoint List JSON, IF Blank Field Formatting
Hello and thank you very much in advance for your valuable insight. I need to format column [REQUEST FORM] with these conditions: IF column [REQUEST] is not blank then display "REQUEST FORM" with clickable link to form otherwise leave blank I have everything working except for the IF portion. Will you please help me with the JSON formatting? Here is the JSON: Here is the result: Thank you again for your help.104Views0likes4Comments