Recent Discussions
Create reference number in SharePoint lists with each new entry
Migrating an Excel table into SP lists, so I can existing reference numbering system, so with each new entry I need this to increase by one. Let's say the current ref number is R5687 how to I ensure that subsequent entries are allocated a reference number, which is one more last the last
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?
SharePoint Button Web Part "Run Flow" Action Only Works in the Default Environment
Hello! I was setting up a new workflow for a customer and encountered a limitation with the button web part's "Run Power Automate Flow" option. Background The SharePoint Button web part has a built-in action type: Run Power Automate Flow, which accepts a Flow ID. This is a clean option for giving users a one-click way to trigger an instant/manual flow directly from a SharePoint page. The Finding When configuring the Button web part with Run Power Automate Flow, it appears that the flow must reside in the Default Power Platform environment for this action to work. Flows in non-default (department-level) environments fail silently with the following error: Could not find flow '<flow-id>'. Testing Approach To isolate the variable, I did the following: Took an existing instant flow and exported it from a department-specific environment, then imported a copy into the Default environment — so the logic was identical. Created two Button web parts on the same SharePoint page: Button A → Flow ID from the department-level environment copy Button B → Flow ID from the Default environment copy Both buttons were configured identically, with the only difference being which environment hosted the flow. Result: ✅ Button B (Default environment) — triggered successfully ❌ Button A (department-specific environment) — returned "Could not find flow '<id>'" The account I used for testing is the same one that created the workflows and also has site collection admin rights, so permissions should be a factor. Related Behavior This appears to be consistent with a known behavior of running an instant flow from a SharePoint list (from the List menu , "Integrate" -> "Flows" -> <workflow name>), where instant flows with manual SharePoint triggers must also reside in the Default environment to function correctly. Both surfaces appear to share the same environment scope constraint when resolving flows by ID from a SharePoint context. Questions for the Community / Microsoft Is this a documented platform constraint for the Button web part's Run Power Automate Flow action? Is this constraint expected to change, or is it by design? Workarounds In this case, I found two decent workarounds: Instead of configuring the Button web part action as Run Power Automate Flow, it can be configured as Open Link, and then use the flow's direct run URL: https://make.powerautomate.com/environments/<environment id>/flows/<flow id>/run Also using the direct run URL, enter that into a navigation link or regular hyperlink on the SharePoint page to launch the workflow run page. Any insight from the community or the product team would be appreciated — especially if there's a documented reference I may have missed. Thanks!Import picklist values for SharePoint List choice field
I have a column in a SharePoint List that uses the choice field type. I'm able to manually enter each choice value by copying/pasting text from an Excel spreadsheet. Is there a way to import a long list of values directly into SharePoint to save time?Store both current employees (AD) and past employees (non-AD) in MS List column?
I have an EMPLOYEE text column in an Excel spreadsheet. I plan to import the spreadsheet as an MS List. The EMPLOYEE spreadsheet column contains both current and past employee names. If I create a new PERSON column in the List to store this data (for clean querying and automation purposes), only the current employees will match up with the Active Directory picklist, not the past employees. If I enter past employees into the PERSON column, the List won't let me save those values since they're invalid. Is there a way to force the past employee names into the PERSON column as broken/unlinked values, such as through a Power Automate flow? Or do I have no choice but to use a TEXT column instead with a custom picklist (manually maintained picklist values)?
Export and Import Modern Sharepoint list
Hi all, I have created a PowerApps custom form on Sharepoint list on our dev environment. What is the best way to import this list to different environment (etc. production)? I would guess is should be done by creating list template and import it to new environment. Does anyone have experience with importing sharepoint list with powerapps custom form? Thanks a lot, PeterImport list from excel/csv people picker field
I have an existing list that I want to export and import into a different site. The issue is, there are several people picker columns on this list and they are consistently being imported as text fields instead of a people picker column. The export is seemingly fine, but the import is not recognizing these columns as their original type - people. Any tips or suggestions?
Clean up missing dependencies - Access Services
We migrated our farm from SharePoint Server 2019 to SharePoint Server Subscription Edition (SE) using the Database Attach method. When running Test-SPContentDatabase against our content database , we receive missing feature errors for deprecated Access Services: 744b5fd3-3b09-4da6-9bd1-de18315b045d and d2b9ec23-526b-42c5-87b6-852bd83e0364. The "Locations :" field in the output is completely blank/null. We removed the feature from our site collections. How can we resolve the issue.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.
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!SP SE Migration: Test-SPContentDatabase reports missing Access Services feature with Null Locations
We are migrating our farm from SharePoint Server 2019 to SharePoint Server Subscription Edition (SE) using the Database Attach method. When running Test-SPContentDatabase against our content database (WSS_Content), we receive missing feature errors for deprecated Access Services: 744b5fd3-3b09-4da6-9bd1-de18315b045d and d2b9ec23-526b-42c5-87b6-852bd83e0364. The Locations : field in the output is completely blank/null. We already deactivated the Access features. The SharePoint Configuration Wizard crashes. How we can completely get rid of it.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.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.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!
Recent Blogs
- In this edition of SharePoint Showcase, we explore how skills work, how to create or install them, and ten practical examples to help SharePoint site owners get started. These examples are not an exh...Jul 28, 2026
- 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
