Recent Discussions
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.Changing the License Type and Key of a SharePoint Subscription Farm
Hi everyone, I need some assistance with a licensing issue on a brand new SharePoint Subscription Edition farm. I have 6 servers total 4 Application/Search servers + 2 Web Front End/Distributed Cache servers and current state of farm is Fresh installation no custom code or solutions, no production content web apps configured yet. The Problem: During setup, our systems team accidentally provided a SharePoint Standard Edition product key, which I used during farm creation. We actually require Enterprise Edition, but I am unable to convert the license type through Central Administration. Issue 1: When I go to Central Administration > Upgrade and Migration > Convert farm license type, the Product Key text field and the OK button are both completely grayed out and disabled. Issue 2: When I go to Central Administration > Upgrade and Migration > Enable Enterprise Features and enter our Enterprise key, the process fails with an Unknown Error / SkuUpgradeJob timer job exception ("Post setup configuration failed when attempting post setup configuration task -cmd services -install -cmd installfeatures"). What I Have Tried So Far: Running PSConfig CLI: Ran psconfig.exe -cmd sku -upgrade -key from an elevated Command Prompt. It fails during the installfeatures phase. PowerShell Feature Activation: Attempted to run Enable-SPFeature -Identity PremiumFarm -Force in the SharePoint Management Shell, but feature provisioning fails because the underlying SKU definition hasn't switched. Service Account Privilege Adjustments: Tried restarting the SharePoint Timer Service (SPTimerV4) and changing its logon account to Local System / Local Admin to rule out file permission issues on the 16-Hive directory, but hit SQL permission/authentication blocks. Clearing Timer Jobs and Restarts: Cleared stuck or failed SkuUpgradeJob instances under Timer Job Status, restarted the SharePoint Administration Service and Timer Service across all servers, and performed iisreset. Since this is a completely fresh farm with no customization or data loss risk, what is the cleanest way to force the farm to accept the Enterprise product key without having to completely unjoin and rebuild the 6 servers? Any suggestions or workarounds would be greatly appreciated!
M365 Developer E5 Sandbox provisioning failed despite active Visual Studio Enterprise subscription
Hi everyone, I'm looking for some help with an issue I'm facing while setting up a Microsoft 365 Developer E5 sandbox. I have an active Visual Studio Enterprise subscription (valid until 2029), and it is successfully linked to my Microsoft 365 Developer Program account. What happened I joined the Microsoft 365 Developer Program. I selected Instant Sandbox. I entered the required information and selected my Visual Studio Enterprise subscription. The portal initially displayed the following message: "It's taking longer than expected. Your setup is being processed. There is no action required from you at this time." After waiting for nearly 24 hours, the dashboard changed to: "You don't currently qualify for a Microsoft 365 Developer Program sandbox subscription." What I've verified Visual Studio Enterprise subscription is active and linked to my Developer Program account. A developer tenant appears to have been created. I can access the tenant through the Microsoft Entra Admin Center. An Azure subscription named similar to devProgram_... is visible. In the Microsoft 365 Admin Center (Billing → Your products), only Microsoft Entra ID Free is listed. No Microsoft 365 E5 Developer subscription was provisioned. No sample users or Microsoft 365 workloads (Exchange, Teams, SharePoint, etc.) appear to have been created. My understanding It appears that the developer tenant was created successfully, but the Microsoft 365 Developer E5 sandbox provisioning either failed or never completed. As a result, I don't have a usable Microsoft 365 developer environment for testing Declarative Agents and MCP integrations. Has anyone experienced this before? Is there a way to retry the E5 provisioning without creating a new Developer Program account? Is there anything I can check on my side? Does this require intervention from the Microsoft Developer Program team? Any guidance would be greatly appreciated. Thank you!
SharePoint SE - Distributed cache service is not enabled in this deployment.
Hi everyone, I have been struggling for a few weeks now with a Distributed Cache issue in my SharePoint farm. The service configuration seems completely out of sync between my two Web Front Ends (WFEs). 1 Root Cause / History: Originally, the Distributed Cache was working perfectly. However, after a Windows Update, both of our original WFE servers broke completely (we couldn't repair them using DISM). Because of this, we built two brand new WFE servers to replace them. Crucially, because the old servers were broken, we performed the steps in this order: 1. We built and added the two new WFE servers to the farm first. 2. After adding the new ones, we removed the two broken ones using the Configuration Wizard, and subsequently deleted them from Central Administration since they were still showing up. Because the old servers were never gracefully decoupled from the Distributed Cache before they died and were removed, the internal Distributed Cache configuration in the SharePoint configuration database is now corrupted. 2 Environment & Farm Topology: • SharePoint Version: SharePoint Subscription Edition (SE) • OS: Windows Server 2025 • Database: SQL Server 2025 • Topology: 2 Web Application servers (App servers) and 2 brand new Web Front End servers (Server 1 and Server 2). • Note: All required Distributed Cache firewall ports (22233, 22234, 22235, 22236) are completely open on both servers. 3 The Current Symptoms on the New WFEs: • Server 1: The Windows Configuration Wizard runs and completes successfully. However, in Central Administration, the Distributed Cache service status for this server is stuck on "Error Stopping". • Server 2: Distributed Cache does not work at all. Running Get-SPCacheHost prompts for a HostName, indicating it cannot find the host in the cache configuration. • Cache Health Error: Running Get-SPCacheClusterHealth fails completely with: ErrorCode<ERRCAdmin040>:SubStatus<ES0001>:Failed to connect to hosts in the cluster • Health Analyzer Errors: 1. "Distributed cache service is not enabled in this deployment." 2. "Server role configuration isn't correct." (Specifically flagging Server 2). 4 What I Have Tried So Far: 1. Cleaned up old servers from Config: I exported the cache cluster config (Export-SPCacheClusterConfig), manually removed the two old, decommissioned servers from the XML file, and imported it back. 2. Repair via Central Admin: Tried to use the built-in repair and fix options in CA, but without success. 3. Attempted Fix from Microsoft Learn: I followed the steps outlined in this Microsoft Learn thread regarding a renamed server issue: [https://learn.microsoft.com/en-ie/answers/questions/5907941/distributed-cache-not-working-on-a-renamed-sharepo] 4. Forced Deletion on Server 2: Because Remove-SPDistributedCacheServiceInstance failed with a cacheHostInfo is null error, I used PowerShell to force-delete the service instance object on Server 2: PowerShell $instanceName = "SPDistributedCacheService Name=SPCache" $serviceInstance = Get-SPServiceInstance | ? { ($_.Service.ToString()) -eq $instanceName -and ($_.Server.Name) -eq "Server02" } $serviceInstance.Delete() 5. Re-adding Server 2: When I now try to re-add the instance on Server 2 using Add-SPDistributedCacheServiceInstance, it fails with: ErrorCode<HostAlreadyPresent>:SubStatus<ES0001>:Host name Server02 is already present in cluster configuration. 6. Configuration Wizard on Server 2: Running the SharePoint Configuration Wizard (PSConfig) on Server 2 fails with: An exception of type System.InvalidOperationException was thrown. Additional exception information: cacheHostInfo is null. 7. Farm Rejoin: I completely removed Server 2 from the SharePoint farm and added it back again. Unfortunately, this did not resolve the Distributed Cache mismatch. 5 Summary of the Problem: Server 1 is stuck on "Error Stopping" in CA. Server 2 is completely disconnected from the cache cluster (Failed to connect to hosts in the cluster). SharePoint throws HostAlreadyPresent when trying to add Server 2, but throws cacheHostInfo is null when trying to configure or remove it, while complaining that Server 2's role configuration is incorrect. Any help would be greatly 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?Rest API Error:"The parameter Members does not exist in method AddTenantTheme"
Using the following code. $colorPairs = @{ "themePrimary" = "#003538"; "themeLighterAlt" = "#cbe6e7"; "themeLighter" = "#a1cfd1"; "themeLight" = "#7cb8bb"; "themeTertiary" = "#5ba2a5"; "themeSecondary" = "#3f8c90"; "themeDarkAlt" = "#28767a"; "themeDark" = "#166064"; "themeDarker" = "#094b4e"; "neutralLighterAlt" = "#f8f8f8"; "neutralLighter" = "#f4f4f4"; "neutralLight" = "#eaeaea"; "neutralQuaternaryAlt" = "#dadada"; "neutralQuaternary" = "#d0d0d0"; "neutralTertiaryAlt" = "#c8c8c8"; "neutralTertiary" = "#98a9da"; "neutralSecondary" = "#4863b4"; "neutralPrimaryAlt" = "#113191"; "neutralPrimary" = "#002081"; "neutralDark" = "#001963"; "black" = "#001249"; "white" = "#ffffff"; } $content = @{ "name" = "MyCustomTheme" "themeJson" = $jsonBody } | ConvertTo-Json $apiUrl = "https://<<domain>>-admin.sharepoint.com/_api/thememanager/AddTenantTheme" Invoke-PnPSPRestMethod -Url $apiUrl -Method "Post" -Content $content Tried many different combinations but kept getting Invoke-PnPSPRestMethod: {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The parameter Members does not exist in method AddTenantTheme."}}} Wondering if somebody can run this code successfully and let me know what I am missing.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?Storing and organizing performance review data - SharePoint lists or something else?
My team has been asked to move our performance review records from a legacy HR system into something within M365. Someone suggested SharePoint lists but I'm worried about permissions (employees shouldnt see each others reviews), workflow complexity, and whether it'll scale. We have about 400 employees. Is SharePoint the right tool for this or should I be looking at something purpose-built that integrates with our M365 environment?
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 helpFlow Action - Convert Word Document to PDF
I'm trying to use the Convert Word Document to PDF action in a Flow. There are three parameters that have to be entered: Location - the SharePoint Site Document Library - Library where the document is located. File - The document to convert The parameter that I'm having an issue with is the File. The flow works if I choose the specific document from the library but I want it to be dynamic so that when the user starts a Flow on the document it will convert that one, so I don't want to hardcode the document name. For the File property I'm using the property from a previous step with the file name called File name with extension. When I run the flow I get an error, "There was an error accessing the file. Please try again or select a different file." Can I not use dynamic content for the File property? Thanks
I have trouble with phone number and Microsoft Authentication when login. Where can I find support?
Hello, Currently, I am unable to log in to my email address removed for privacy reasons account. I have the password. I have a backup email address, but when I try to log in, at the authentication step, I don't have the option to receive the OTP code via email. I can only choose to have it sent to my phone number or the Microsoft Authentication app. But when I tried sending it to the phone number, I got the following error: Error Code: 399287 Request Id: 4d13566b-7aa4-4b3f-a03b-0c9416841000 Correlation Id: 019f785d-514f-7eaa-b1a3-ee66302634ae Timestamp: 2026-07-19T03:13:40Z Also, I can't access the Microsoft Authentication app because I've changed devices multiple times. I couldn't find the support form, so I replied to this email. With the admin account password and backup email, how can I log into the admin panel? Sincerely, ThangSharePoint 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!
Format Power BI report in SharePoint page
Hey everyone, I have a wide and short Power BI report that is 2500 by 350 and I am trying to embed it in a SharePoint page. The problem is that when I embed it there is a ton of negative space below the report. I tried formatting the web part but there are only two display ratios (16:9 and 4:3). Is there a way to shorten the web part or reduce the negative space below the report.
Recent Blogs
- By Sujay Kumar Jauhar, Spriha Chandrayan, Natasha Gaitonde, Zhen Lei, Reed Pankhurst, Anush Sankaran, Amrit Shandilya, Ryen W. White Organizations put their most important content in OneDrive and S...Jul 21, 2026
- Copilot in SharePoint helps you do more with your content — ask questions, run workflows, and create sites, pages, interactive reports, and Office files using natural language. June was a big month: ...Jul 16, 2026
