Forum Widgets
Latest Discussions
How to update a multi-choice field of a sharepoint list with ADO
Dear Community, I managed to create a VBscript to access a Sharepoint-List, get a recordset, add a line and fields etc. with ADO. One thing that I can't get to work is how to set or update a multiple choice field. When I get a recordset from an existing line the value is a string with the choices separated with ;#. However when I try to set the same line to a new record it fails. What is the proper way to do that? Here some sample code, the constants need to set to the actual sharepoint site/list/id. I created a test sharepoint list with the default Title column and one 'Options' column with a choice / Checkboxes with the choices: Event Problem Change With the below code a new record is created with the Title but with an empty Options field. Who can help me do that? Thanks ahead for your help! Public Const strSPCustomerBatchListName = "MyListName" Public Const strSPSite = "https://MySharepointSite" Public Const strSPCustomerBatchListID = "the connection ID" Dim cnt As ADODB.Connection Dim rst As ADODB.Recordset Dim mySQL As String 'set connection Set cnt = New ADODB.Connection Set rst = New ADODB.Recordset 'sql select statement mySQL = "SELECT * FROM [" & strSPCustomerBatchListName & "] WHERE [ID] = 1;" 'open connection With cnt .ConnectionString = _ "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=" & strSPSite & ";LIST={" & strSPCustomerBatchListID & "};" .Open End With 'open table / recordset rst.Open mySQL, cnt, adOpenDynamic, adLockOptimistic rst.AddNew rst.Fields("Title").Value = "Test3" rst.Fields("Options").Value = ";#Event;#Change;#" rst.Update 'close recordset/connection and clean memory If CBool(rst.State And adStateOpen) = True Then rst.Close Set rst = Nothing If CBool(cnt.State And adStateOpen) = True Then cnt.Close Set cnt = Nothing
Accessing endpoints published to Entra Application Proxy from SPFx
We have an on-premises web service (hosted in IIS) published through Entra Application Proxy. When attempting to access the published endpoints from a SharePoint (SPFx) web part, we encounter CORS errors (302 Found). Accessing these endpoints directly from a browser address bar works as expected. In IIS, the Access-Control-Allow-Origin response header is set to * (wildcard). We have also tried specifying a particular domain, but that did not resolve the issue. Pre-authentication is enabled in Entra Application Proxy. Has anyone successfully connected to endpoints behind Entra Application Proxy from an SPFx web part? Any insights or solutions would be greatly appreciated.
Can’t save docx after clearing a mapped field
Hi everyone, I've got a problem on a project for one of my clients that I can't solve, so I've come to ask for your expertise ! Context SharePoint Online document library .docx files with Quick Parts mapped to library columns (Choice, Date, etc.) Flow uses “Populate a Microsoft Word template”, which only accepts .docx Issue When a user clears a mapped field and hits Save, Word blocks the upload :“Correct the invalid or missing required properties.” Tried (no fit) .docm + VBA to delete empty node → works, but Populate rejects .docm Blank Choice option → fine for Choice, fails for Date fields Question Has anyone found a parameter or a trick that allows when editing a Word with Quick Parts linked to SharePoint Online fields to be cleared without validation errors ? Thanks ! Charles
Retrieve Term Navigation Properties using REST API
I've set up a Term set in the global term store and enabled Navigation so I can add URLs for each of the Terms. Note that I'm not going to use the Term set navigation in my site - it's only there to try and retrieve it from my SPFx webpart. Note that I can get all the terms under my Term set - just not the navigation properties. Below is what I'm trying to get the navigation properties: https://TENANT.sharepoint.com/_api/v2.1/termStore/sets/TERMSETGUID/terms/TERMGUID/properties But I get: "The property 'properties' is null or does not exist". Also, expand doesn't seem to work at all. I'm not looking to use pnpjs or even graph if I can help it. Any ideas welcome.
SharePoint Online Threshold Limits – Critical Impact and Architectural Guidance Request
Dear Microsoft Support Team, We are the central IT service provider managing a productive SharePoint Online environment for one of our enterprise customers. As part of a migration project (merger), we encountered a significant issue related to the exceeding of Microsoft-recommended thresholds in SharePoint Online. The resulting impact disrupted critical business operations. We kindly request confirmation, technical explanation, and the most up-to-date Microsoft recommendations (including sources) regarding the following topics: Threshold Clarification What are the current Microsoft-recommended maximum limits for: Total number of files/folders in a document library Total number of files/folders within a single folder or path Maximum number of items to maintain functional permission management Maximum number of items that allow stable OneDrive synchronization Technical Impact Questions What are the consequences when the 100,000-item threshold is exceeded within a folder path, especially when changing access paths (e.g., department name changes)? What are the technical causes of the extended "re-synchronization" process triggered by path changes? Architectural Guidance How should a Site Collection or library be structured to ensure: Scalability for enterprise use Effective permission control even with over 1 million files Smooth OneDrive sync functionality Future-proofing against disruptive changes (e.g., metadata updates, path modifications) Known Thresholds / Internal Guidelines: Maximum per library: 30 million items (Source: Microsoft Docs) Permission management limit: 100,000 items (breaking inheritance not possible beyond this) OneDrive sync limit: 300,000 items (Source: Microsoft Docs) Help is needed: Recommendations on how to architect large-scale document libraries Best practices to avoid the aforementioned issues Clear indication of the thresholds that must not be exceeded in an enterprise-grade SPO environmentSet AssociatedOwnerGroup for a web using REST
I am building sub-sites under a site collection via FLOW/Power Automate, and we need to know how to make the default owners group for the site. We can build the SharePoint groups and assign users, but how do you set the property: AssociatedOwnerGroup Anyone have a sample POST? https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245638(v=office.15)?redirectedfrom=MSDN These 2 threads are not helpful and don't answer the question: https://social.technet.microsoft.com/Forums/en-US/09288617-90d8-410a-88b2-30c3d77f0dc6/how-do-you-set-associatedownergroup-for-a-web-using-rest-api?forum=sharepointdevelopment https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aa435402-ef15-4b6e-9b10-965861e93f50/how-to-set-associatedownergroup-with-rest-api-in-sharepoint-2013?forum=sharepointdevelopment
Sharepoint Issue ? - Error moving a file to a doc library with lookup column ( Sharepoint Online )
Hi all ! It seems it is not possible to move a document to a document library containing lookup fields. This seems amazing to me so I must be failing at some point ... Anybody can confirm that or give some help ? Step to reproduce : - create a simple list with some items - create a document library - add a lookup column using the simple list - move a document to this new library ( REST call or site interface ) => we get the following error : "This operation is not supported"Sharepoint Basic auth authentication effect SharePointOnlineCredentials?
I'm wondering if the announcement of Basic auth deprecation for SP online mentioned here https://learn.microsoft.com/en-us/sharepoint/technical-reference/basic-auth-is-being-deprecated affects the use of the SharePointOnlineCredentials method of logging in via .net CSOM APIs. I'm aware it takes username and password but I thought it was actually classified as a form of Claims Based Authentication not basic. I know on the client side, newer CSOM libs don't include that structure any more. But that doesn't mean the server will no longer accept that means of login. The object I'm talking about is https://learn.microsoft.com/en-us/dotnet/api/microsoft.sharepoint.client.sharepointonlinecredentials.-ctor?view=sharepoint-csom&devlangs=csharp&f1url=%3FappId%3DDev16IDEF1%26l%3DEN-US%26k%3Dk(Microsoft.SharePoint.Client.SharePointOnlineCredentials.%23ctor)%3Bk(TargetFrameworkMoniker-.NETFramework%2CVersion%3Dv4.8)%3Bk(DevLang-csharp)%26rd%3Dtrue And the means of using it would be like this SharePointOnlineCredentials creds = new SharePointOnlineCredentials(sUserName, securePassword); ClientContext ctx.Credentials = creds; string authCooke = creds.GetAuthenticationCookie(Sharepointuri);
