Automatically email supplier when their certificate expires
Good afternoon. I have set myself a challenge and really could do with some help. I have a list of suppliers like below. I have expiry dates set up, with a colour formatting to show any date past the current date. On the end of the row, there is an email address of the company contact. I want SharePoint to automatically email that person as soon as it turns red/expires. What is the simplest way of doing this? I have looked at Flows etc, and online on video tutorials, but some of the guides are old and out of date or very complex and I am a novice. Is anyone kindly, can give me a step-by-step guide on how to do this, as this would be just awesome and finally bring my company into the 21st century! Thanks in advance.
SharePoint List Web Parts - New UX
Hey everyone, I am hoping I can get some assistance on the following request. My organization's using SharePoint to manage multiple processes, but am confused with a new UX update that's come in the last few days. Please look at the following example, which is a list with a modern calendar view: For all of my lists, that are used as a web part on a different Site Page, have been given an ability to add a 'New Item', by selecting the title name, which's very frustrating as all of our list processes already have their own system to collect information and it seems as though I cannot turn off this functionality. Any help would be very much appreciated.
default time in the Date and Time column
Is there is possibility to change the default Time in the Date and Time column globally? Example: That is the default - 12 AM 00 is that possible to change that for anything? even 12PM:00? So all records under would get something different than 12 AM 00 by default?Cannot drag or move any web part around once placed inside a 'flexible' section
I am working with sharepoint and have been advised to use this 'flexible' section for more freedom with placement on the grid. Once a text web part or any web part is dragged from the toolbox onto this flexible section, it becomes immobile. Neither the 'Move' cursor state nor the 'Move web part' handle on said web part allows the web part itself to be moved in any way inside this section. Screen captures included below for clarity. This behaviour persists with any web part dragged out of the sharepoint toolbox onto this flexible section.
Issues with SharePoint Product Catalog (Classic)
Is it a known issue for search-based web parts (content search web part or search box, refiners and results) to be interfering with a page layout integrated with catalog item reuse snippets in SharePoint Online (classic)? Due to the limitation in creating a product catalog site in modern experience, we went down the path of creating a classic version of product catalog in SharePoint Online. For a year and a half, the product catalog has been working fine until recently while there were no new changes made to the page or the page layout. The page used to surface catalog item content based on the product tag in the URL (https://[tenantname].sharepoint.com/sites/products/overview.aspx?myproduct=apple) as well as search-based content. Upon investigating the issues, it appears that the catalog item reuse snippets on the page layout and the search-based web parts both are interfering with each other's. If we removed search-based web parts from the page, the catalog item content then surfaces. If the search-based web parts are re-added, the catalog item content then disappears. Has anyone experienced this issue?
Dynamic Mandatory Fields
In a SharePoint library, I have folders which are = a. Admin b. Events c. Furniture and Moves d. Janitorial and Maintenance e. Parking and Transportation f. Shipping and Receiving g. Supplies and Equipment h. Waste and Recycling I have Meta data across the library whose data type are all choices and are: a. Document Type = Contract, Financial, planning b. Building = Gym, Garage, Heating c. Asset Category = Office, Playground d. Fiscal Year = FY23, FY24, FY25, FY26, FY27 e. Vendor = Maple Leaf, Canadian Tire, Home Depot f. Status = Active, Pending, Not Active g. Retention Label = 3 years, 5 years h. Service Type = Admin, Events, Furniture and Moves, Janitorial and Maintenance, Parking and Transportation, Shipping and Receiving, Supplies and Equipment, Waste and Recycling Service Type and Retention Label are mandatory fields, with the Rule below for all the files in the various folders: IF Folder Name = Admin, then Service Type = Admin and Retention Label = 5 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Events, then Service Type = Events and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year, Building and Vendor IF Folder Name = Furniture and Moves, then Service Type = Furniture and Moves and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Building IF Folder Name = Janitorial and Maintenance, then Service Type = Janitorial and Maintenance and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Parking and Transportation, then Service Type = Parking and Transportation and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Shipping and Receiving, then Service Type = Shipping and Receiving and Retention Label = 3 years; the mandatory fields should be Document Type, Status IF Folder Name = Supplies and Equipment, then Service Type = Supplies and Equipment and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Waste and Recycling, then Service Type = Waste and Recycling and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Vendor I have used Column Default Value Settings for SharePoint to display Auto-Display the Service Type and Retention Label, but I cannot seem to perform the conditional mandatory fields using Validations setting for the other requirements. Please helpSharePoint Online Site Deletion blocked by Retention Policy although no content is retained
Hi everyone, I'm trying to understand whether this behavior is expected or if other organizations are experiencing the same issue. Environment SharePoint Online (Microsoft 365) Microsoft Purview Retention Policy Retention duration: 180 days Trigger: based on last modified date After retention period: Do nothing The intention of the policy is not to automatically delete content. We only want to prevent deletion for 180 days and allow deletion afterwards. Microsoft previously explained to us that retention applies to the content/items, not to the container (the SharePoint site itself). Problem We are currently unable to delete SharePoint sites. When attempting to delete a site from the SharePoint Admin Center we receive the following message: This site can't be deleted at this time because it is blocked by a compliance policy. What we already checked For the affected site: CompliancePolicyIds = empty ArchiveStatus = NotArchived SensitivityLabel = empty The Preservation Hold Library is empty: Preservation Hold Library => Items = 0 We also inspected the internal DLC properties of the site and found entries such as: dlc_sitehaspolicy dlc_sitehasexpirationpolicy dlc_webhasexpirationpolicy Even after clearing these values for testing purposes, the site still could not be deleted. Important Observation If we explicitly exclude the site from the retention policy, deletion becomes possible. This makes it appear that the retention policy is blocking deletion of the site container itself, even though our understanding was that retention should only protect retained content and not permanently prevent deletion of the entire SharePoint site. Has anyone else observed this behavior? Additional OneDrive Issue We are seeing a similar problem with unlicensed OneDrive accounts. Many of these OneDrive sites: are already archived are shown as blocked by retention/compliance cannot be deleted remain present for years For example: ArchiveStatus = FullyArchived CompliancePolicyIds = empty The accounts appear in the list of unlicensed OneDrive accounts, but we are unable to permanently remove them while the retention policy is in effect. Has anyone found a practical way to clean up or remove these orphaned/unlicensed OneDrive sites when a tenant-wide retention policy is configured? Questions Has anyone seen a situation where: CompliancePolicyIds is empty the Preservation Hold Library is empty but site deletion is still blocked by a compliance policy? Does a retention policy configured as: Retain for 180 days Then Do nothing intentionally block deletion of the entire SharePoint site container? Is it expected that excluding a site from the retention policy immediately makes deletion possible? How are other organizations handling site lifecycle management when tenant-wide retention policies are enabled? Has anyone experienced similar issues with unlicensed OneDrive accounts that cannot be deleted because of retention/compliance requirements? Any experiences, recommendations, or explanations would be greatly appreciated. Thanks!
