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.
Users unable to determine who has access to document library due to security groups
Greetings, Maybe I went about this the wrong way. Looking for advice on either the proper way we should be moving forward on this or any other comments or insight we should be considering. This is for SharePoint online via Microsoft 365 Business license. Scenario: 1. SharePoint Document Library per department (Each Document Library exists in its own SharePoint site), essentially being used as a company drive. 2. Some users should only officially have access to specific folders in some of the document library. 3. If say a person in accounting has access to some specific folders, and either they are replaced or a new accounting user comes in.... should be able to reference the access the existing person has in order to give the same access to the new user. 4. Common Request: Give UserB the same folder access as UserA. 5. Some users should have access to the entire document libraries while other users only have access to specific subfolders. Current Implementation: 1. In Entra, created Security Groups that tied to specific folders. -- For Example for the accounting folder, only management has access to the entire folder but the accounting staff only have access to specific folders. So like there is a FiscalYear2024 folder, so I created a security group called sec-Accounting-FiscalYear2024 and assigned the members that should only have access to that folder and not the rest of the library. -- My thought behind this was if a new user was replacing the existing user or joining the department, I can just reference the existing user security group membership and copy it to the new user. 2. In the SharePoint document Library, I create a shareLink that is assigned to the security group I made for that access. Then I give that link to the users I assigned the membership to. Current Issue: 1. Aside from the official document sharing/access that is being done from the security groups above. There are occasions where users of a sharepoint need to share specific files or folders to other users. 2. However, they are all panicking and confused because aside from themselves they are unsure who has access to the existing folders/files in the document library. 3. When going to manage permissions of a file/folder, it only shows the group assigned to it but not the members of the group. 4. So since users can't see the members of the group assigned to a folder, they have no idea who has access to that folder and are getting confused. If this was an NTFS drive, it would be super easy for users to see who has access and etc by looking at the properties but I'm stuck behind some limitations of sharepoint I didn't realize existed until I tried to implement certain workflows. Any advice here would be greatly appreciated, as my implementation has turned into a point of frustration for end users. Thank you in advance!
Private drafts stay private even after publishing
If one of our authors makes a private draft and sends it for approval for publishing, it remains private even after approving. The only workaround I can find is to create a new page from scratch, copy the content across and delete the private draft. Surely this isn't how it's meant to work? Am I doing something wrong or is something broken? We are using https://support.microsoft.com/en-gb/office/approval-flow-for-modern-pages-a8b2e689-d4a1-4639-8028-333c0ece30d9.
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.
Can PnP Provisioning preserve SharePoint List GUIDs across environments?
I am using PnP Framework 1.15.1 with the 2022/09 Provisioning Schema to provision SharePoint Online lists. After applying the provisioning template, I noticed that all newly created lists have different SPList.Id (GUID) values compared to the source site. My template contains standard pnp:ListInstance definitions, for example: <pnp:ListInstance Title="Event Types" TemplateType="100" Url="Lists/EventTypes" TemplateFeatureID="00bfea71-de22-43b2-a848-c05709900100"> ... </pnp:ListInstance> I checked the 2022/09 schema and I couldn't find any attribute to specify the list GUID. I also noticed that the provisioning engine registers ListIdToken using createdList.Id, which seems to happen after the list has already been created. My questions are: Is it expected that PnP Provisioning always creates new SharePoint List GUIDs? Is there any supported way to preserve the original SPList.Id during provisioning? Was this ever supported in previous versions of the PnP Provisioning schema or framework? Any official documentation or confirmation from the PnP team would be appreciated.
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, ThangM365 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 – Unknown SQL Exception 18452 occurred. Login failed.
This month we applied OS updates to the DB Server. Site was up. Then we applied OS Updates to App server, site went down and we reverted it. Then we applied OS updates on WFE server. The site is up. However, in WFE when running Get-SPFarm or running PSConfig on the WFE, it throws the following errors: PowerShell / PSConfig: “Cannot access the local farm. Verify that the local farm is properly configured…” Configuration Wizard: “Failed to detect if this server is joined to a server farm.” The Error Logs: Checking the Windows Event Viewer on the WFE during a database connection attempt shows: Unknown SQL Exception 18452 occurred. Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. Network connectivity is fully operational. AD Domain trust is healthy. Local machine groups are clean: NT AUTHORITY\SYSTEM is not present inside the local WSS_WPG or IIS_IUSRS groups. DisableLoopbackCheck is already set to 1 in the registry. Any help on how to get the error is greatly appreciated.
Web invoke in power automate says unauthorized but can browse from browser
I am able to browse to this url directly from browser https://my365.crm9.dynamics.com/api/data/v9.2/audits?$filter=objecttypecode%20eq%20%27myissuetable%27%20and%20_objectid_value%20eq%20%271de46d6b-b986-f111-ab0e-001dd80b339b%27&$select=_objectid_value,objecttypecode,changedata,createdon,_userid_value but when i use the invoke http from power automate it says unauthorized. i am using the same account. What is the issue is there anything i need to do so that it works?
SharePoint Multi-geo: accessing a user's home-geo custom SharePoint properties from a different geo
Setup M365 tenant, multi-geo (NAM + EMEA). SharePoint custom user profile properties are synced only in the user’s home geo (their Preferred Data Location). SPFx webparts running on the NAM tenant, using PnP/SP or AadTokenProvider. Goal: when an EMEA user opens a NAM page, read their SharePoint custom properties from the EMEA tenant. Issue 1 — Can’t read profile properties from a different geo-tenant What I’m doing const sp = spfi(emeaTenantUrl).using(SPFx(webpartContext), SPFxToken(webpartContext)); const result = await sp.profiles.getPropertiesFor(basicInfo.data.LoginName); Error Access Denied: This application does not have the required permissions to access profile information. The core problem — token is missing my approved scopes Approved Scopes in webApiPermissionManagement (Office 365 SharePoint Online) in SharePoint Admin Center: Sites.Search.All, AllProfiles.Manage, User.Read, User.Read.All, Files.ReadWrite.All, TermStore.ReadWrite.All, Sites.ReadWrite.All, Sites.FullControl.All. Token issued for the SharePoint resource only contains: Files.ReadWrite.All, M365BillingPlatform.Read.All, Sites.FullControl.All, Sites.ReadWrite.All, TermStore.ReadWrite.All. So AllProfiles.Manage, User.Read.All, Sites.Search.All are not in the token and an unexpected M365BillingPlatform.Read.All is. Also tried calling the SharePoint REST API directly with a token from AadTokenProvider → same Access Denied. Questions Why is the issued token missing my approved scopes (and where is M365BillingPlatform.Read.All coming from)? Is there a supported way to read a user’s SharePoint profile custom properties from a different geo-tenant from an SPFx webpart? Approved Scopes in Admin center Issue 2 — Search query template {User.*} properties not resolving cross-geo What I’m doing A SharePoint Search query in the webpart uses a query template that pulls custom user properties dynamically: {|owstaxidmetadataalltagsinfo:{User.customProperty1}} OR {|owstaxidmetadataalltagsinfo:{User.customProperty2}} The SP object is created the same way as in Issue 1. What’s not working When an EMEA user loads the webpart on the NAM tenant, the {User.*} tokens don’t resolve — the query modification shows the static property name itself instead of the user’s values from EMEA. Question How do I get the query template to resolve {User.customProperty} using the user’s home-geo (EMEA) profile values?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!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?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.
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
