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.
Not able to edit items in list due to too many versions.
I have a sharepoint list and some of the items cannot be edited because of the number of versions. I have the versioning set at 50, but some of these uneditable items somehow got up to over 10,000. Any ideas on how to resolve or how they got so high? Thanks
SharePoint Online Subsite Feature - Is it going to deprecate
Hi Team, When will MS deprecate subsite feature from SPO? and what will happen to the existing subsites if deprecated? Also, could you please share SPO roadmap for subsite. Note that we are aware of flat structure and its recommendation from MS. Thanks & Regards, Shanthi.
SharePoint Search by Date
We have several business-critical Date columns that users need to filter by in search. Created and Modified provided by KQL are not enough. We’re limited to a tiny pool of RefinableDate properties, and there’s no UI to create new Date managed properties. This forces us into app-side filtering instead of leveraging the search index. Is there any workaround for this? Does Microsoft have any plans to modernize managed property creation for dates? It's completely unacceptable to have only 12 Refinable Dates for the entire tenant!MRT Layout Custom - how to become crazy 😭
Hi community, I'm currently trying to customize the search result layout in SharePoint. The JSON layout I created works correctly for SharePoint pages, but I would like to use the exact same layout for files, especially for: all files tagged as “procédures”, or files coming from a specific document library. Here are my current settings: The issue is not related to mapped properties. The refinable properties are working, and my verticals return the correct results when using this query. The problem is only with the layout, which does not apply to file results. Has anyone already faced this limitation or knows what might block the layout from rendering on file results? Thanks for your help!Not able to recreate Teams Sharepoint site after perm deleting.
I'm trying to rename a Sharepoint site to a site that I permananetly deleted but I keep getting Write-Locked. {"odata.error":{"code":"-105","message":{"lang":"en-US","value":"This site address can't be changed.\r\nThis | site is write | locked.\r\n"},"MultiGeoService.ExceptionType":"MultiGeoServiceException","MultiGeoService.ExceptionContext":"{\"Errors\":[{\"ErrorCode\":-105,\"ErrorMessage\":\"This site is write locked.\"}],\"Warnings\":[]}"}} I'm using this command to rename the site Rename-PnPTenantSite -Identity $teamsURL -NewSiteUrl $updatedteamsUrl -Wait
Documents uploading to Sharepoint althoughI didn't set it up
Yesterday I began receiving email updates telling me that the Word documents I was working on have been uploaded to Sharepoint. This happens every time I insert a comment into the file. This only began to happen yesterday. I have never used Sharepoint, and only learned about the "Share" option when I searched Help to find ways to turn it off. I didn't turn it on deliberately. So I googled for instructions on how to stop this, and none of the instructions I found matched what I saw when I tried to turn it off in either the document or FIle Explorer. I just went into Word and clicked Help to identify the version I'm using, but they removed "About Word" from the Help menu, so the version isn't where it belongs anymore. I don't know where they put it, and it might not matter anyway. It's probably the latest version, in fact, this might have happened with a recent upgrade, I don't know. If my documents upload to Sharepoint, they're private, right? I'm a writer and I don't want my stuff going out there without me controlling things. Where does Sharepoint keep my files? I no longer have access to OneDrive because I was shut out one day when when my internet carrier switched my signal to another city, and I clicked "No" when Microsoft asked me if I was the one signing in from that city. They immediately locked me out of everything. I can't even get codes by text anymore. I got Outlook and microsoft.com back by signing in with my thumbprint on my phone, but it didn't help me with OneDrive, and I couldn't get support, so I've been unable to access it for months. If Sharepoint is happening on OneDrive, I might be in trouble. How do I stop uploading files to Sharepoint, and stop these annoying emails whenever I add a comment to a file? Thanks!Nested formula not working
I have been using the below formula in a SharePoint Column, to find the most recent year column that 'comprehensive' is mentioned and have that year value returned to the calculated column - it is suddenly not working - or if I reset it, it works for less than a minute and then converts to only one year '2024'. If I reduce the number of years/columns in the formula to only two it works properly and the results stay. Any ideas what the problem is? =IF(NOT(ISERROR(FIND("comprehensive",[2024]))),"2024",IF(NOT(ISERROR(FIND("comprehensive",[2023]))),"2023",IF(NOT(ISERROR(FIND("comprehensive",[2022]))),"2022",IF(NOT(ISERROR(FIND("comprehensive",[2021]))),"2021","No Review")))) Thanks in advance and I am not an expert in anything IT but I am trying to use this to track work in my team. Cheers KarenHow to create a glossary page in Microsoft Lists [SharePoint]
The new Glossary View in Microsoft Lists comes directly from the community, and Federico Sapia is its author (Thanks for sharing). This view is absolutely easy to implement requires a list with 4 starting columns. In a few clicks you can have a view that allows you to explore and navigate the elements of a list by taking advantage of the letters of the alphabet in the header making it even easier to filter and group. #Teams #SharePoint #Microsoft365 #MPVbuzz #MicrosoftLists #Lists
Making Home Page a Template to Be Used Across Sites
Our team is looking for help with reusing a customized SharePoint page. I created a home page on a SharePoint Teams site (not a Communication site) and would like to save it as a template so we can apply it to other sites across the tenant. The page includes layout sections and various web parts, and ideally we want to replicate the same setup on other SharePoint sites. What’s the best and supported way to export or save this page as a reusable template and apply it to other modern SharePoint sites? We are open to using PnP PowerShell or other supported tools, but we’ve run into authentication issues when trying to connect via app registration. Would appreciate step-by-step guidance or a recommended approach. Thank you!
