microsoft lists
1728 TopicsBulk cleanup of content / documents in SharePoint
Hi, We currently have a few SharePoint sites that have old content / documents in document libraries. These are outdated and some are more than 5 years old. To delete these, we currently need to go to each document library / page (and its subfolders), sort by the date created / modified and then manually delete, which would take some time. Is there a way to bulk delete older content/ documents based on date, either within SharePoint admin or a third party program? (e.g. maybe run a query on a site to list any older content and then check off which page / document to delete). Jason49Views0likes1CommentQuick steps disappear from SharePoint list
I have 4 quick steps set up for my sharepoint list. Each one executes a flow. Twice now they have disappeared. I don't see them when I go to Automate or when I go to manage quick steps. Refreshing the page didn't help. The only way I could get them back was to add a new quick step, save it. Refresh the page and go back into manage quick steps and they were all there again.636Views3likes4CommentsTrying to use Lists as a very basic CRM but having search issues
Hey All, I have a small business I'm considering using Lists to track some very basic client info and build a client database that is accessible to all employees on the company SharePoint site (we use MS 365). Workflow would be something like: Client calls in Receptionist(s) answer If new client, create an entry with first/last name, phone #, email address, their spouse's name (if any) and a Notes section to jot down notes from the call. If current client, receptionist can use search to find client, make new notes, read previous notes, etc That is basically it. I have this set up in Lists right now as a test with just two clients, each with a spouse. When I do a search for the person's name (Bill or Franklin), it returns a result. When I search for their spouses name (Susan), it returns nothing. I've run through the settings, reindexed the list, etc, and I just can't get a simple search to work. Am I attempting to use this correctly? Both name columns are single line fields. TYIA for any input!224Views0likes5CommentsHTML-code breaks displaying of multi-line column with RichText in PowerApp Canvas App
I have a canvas app that works on the basis of a SharePoint list. I work in an environment where a researcher makes a work order, this is then sent to the responsible that has to approve it, then the planner plans it and following that, it is executed. This chain of events is all managed with a SharePoint list that has a status that can be changed. Different people have different permissions to edit items. To manage this, we display the list through a CanvasApp where logic is built to ensure that people with a certain role can only select/edit/see certain items. However, a big part of the canvas app is the description of the work order. In the SP-list this is a multi-line field where RichText is enabled. When the work order description is long, and especially when rich text formatting is used (for example colored text), part of the content is displayed incorrectly. The text gets cut off, part of the HTML formatting code appears in the description itself, and the full content is no longer shown. This is an example of a list item: Which is displayed in the Canvas App like this: What I observed is the following: In the normal SharePoint list view, the description is displayed correctly. But when I click/open the item in singe item view itself in SharePoint, the editor/form also . This issue only occurs for items that are created from the Canvas App. If I create a similar item directly in SharePoint and enter a comparable formatted description there, the problem does not occur. So it seems the issue is related to how the Canvas App saves the rich text content to SharePoint. It must have to do something with the way PowerAutomate parses that HTML code into SP.67Views0likes0CommentsSharePoint List Rule to send email not allowing shared mailbox email address
Hi I have tried to search for an answer to this to no avail. We have a SharePoint list and want to create a rule that sends an email when a new list item is created. Sounds simple but I can't seem to add a SharedMailbox email address only UserMailbox email addresses. We do have a work around where we have created a rule in outlook instead that when the email arrives to the UserMailbox forward it to the correct SharedMailbox but it seems a bit silly that I can't directly add a SharedMailbox to the SharePoint list directly from the below. See below the screenshot of where I am trying to insert the SharedMailbox email address. It doesn't find it and if I add it in manually the create rule button doesn't activate. Am I missing something? Thank you!2.8KViews3likes5CommentsID Calculated Column Not Showing
I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box. However, in the actual List item, the vasty majority are showing ID as 0: There does not seem to be a pattern for this, Does anyone have an explanation for this?68Views0likes0CommentsDisable incessant nagware popups
I don't know about everyone else, but I am sick and tired of the nagware pop ups in Word, Excel, PowerPoint, Outlook, etc. Every single product harasses me with pop ups trying to tell me "hey, did you know this feature was here?", "you can do this if you click that", "let me hold your hand through using products you've used for decades even though you don't want daddy Microslop to do that". This is a prime example. I keep getting the same ones again and again and again and everything I've read indicates they should only appear once. But they don't. They keep coming back like a psychotic stalker ex who wants alimony even though you were never married. How do I get this nagware to stop?!116Views0likes1CommentClassic SharePoint features appearing on a Modern Site
I have a modern SharePoint site, with a modern list that has never been associated with classic SharePoint features. But today, two users have experienced intermittent instances of the list appearing in the classic interface. They have not accessed this site before now so I do not believe there should be a cache issue. Does anyone know why this is happening and how it's possible when this site has no association with Classic features? They are using the same browser, same permissions across the site but sometimes the list opens in Classic mode, sometimes it opens in Modern. It also is happening in incognito mode. They are unable to use the site while in Classic Interface at all - the people pickers deny them access ("Error: Sorry, you do not have permission to query for users" and they cannot edit anything because of this error.357Views0likes2CommentsSharePoint List button not working!
Hi all, I have a Property Key Check In/Out list and trying to include a button to auto populate the fields. Using the JSON below, but it isn't working. I've isolated the Status field and that works, but the Person and Date & Time keeps erroring. I checked and double-checked the column settings and the JSON is using the correct Internal names, and the columns are correctly set up to one person only and date and time, and not required. Copilot (you'll be surprised) is absolutely no help. I also tried replacing "null" with '' but still not working. Here's the JSON; { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "style": { "padding": "6px 12px", "border-radius": "6px", "border": "1px solid", "cursor": "pointer", "font-weight": 600, "background-color": "=if([$Status] == 'IN', '#107c10', '#d83b01')", "border-color": "=if([$Status] == 'IN', '#0b6a0b', '#be3700')", "color": "white" }, "attributes": { "title": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')", "aria-label": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')" }, "txtContent": "=if([$Status] == 'IN', 'Check Out', 'Check In')", "customRowAction": { "action": "setValue", "actionInput": { "Status": "=if([$Status] == 'IN', 'OUT', 'IN')", "CheckedOutByColleague": "=if([$Status] == 'IN', me, null)", "WhenCheckedOut": "=if([$Status] == 'IN', @now, null)" } } }Solved203Views1like3CommentsSharePoint List (Not Column) Validation Settings
I have an creating a list that keeps of the amount of hours taken by an employee. I have two columns in this list - Reason & Hours If the Reason column value is 'Paid - Vacation' or 'Unpaid Vacation', then the value of Hours must be greater than 1 and less than 11. I have gone to the List > Settings > Validation settings and tried a few different formulas: =IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE,FALSE),FALSE),TRUE) =IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE)),TRUE) I don't get any errors when saving either formula. When I enter another record manually or using the form, the record is entered, but no validation is being made when the [Reason] = "Paid - Vacation" and [Hours] = 45 Can anyone assist with this?Solved135Views0likes1Comment