Forum Widgets
Latest Discussions
SPFX call gets error "interaction required" after turning on function's System Assigned Identity
I have an spfx web part that is connected an Azure Function. All was working until I turned on the System Assigned Identity for the function. Below is my configuration while it was working: Function app: contoso-fn App Service authentication enabled Unauthenticated requests get a 302 HTTP code Microsoft is the identity provider, with app registration "contoso-fn-auth" It allows token audiences from api://<id-contoso-fn-auth> and from <my-tenant>.sharepoint.com Allowed client applications include 08e18876-6177-487e-b8b5-cf950c1e598c and <id-contoso-fn-auth> CORS: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte and https://<my-tenant>.sharepoint.com App registration "contoso-fn-auth" (used above when setting up identity provider) Authentication > Web > Redirect URI: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte ID tokens issued only accounts in the tenant can access this API API permissions > contoso-fn-auth > user_impersonation ; Delegated; Status: granted for tenant Expose an API: Scopes api://<id-contoso-fn-auth>/user_impersonation The code in the SPFX to request the function is something like this: this.context.aadHttpClientFactory .getClient('<id-contoso-fn-auth') .then((client: AadHttpClient): void => { client.get(<url-to-the-fn>/api/upload)...}); In the SharePoint Admin Center, under Advanced > API Access, the user_impersonation permission is approved for contoso-fn. I then changed the Function app identity, turning on "system assigned", as I needed the function to authenticate against the Azure Blob Client, and now I'm getting the following error: interaction_required: Seamless single sign on failed for the user. This can happen if the user is unable to access on premises AD or intranet zone is not configured correctly I read something about turning on the function's system assigned identity affecting how I requests tokens using the aadHttpClientFactory, but I haven't been too successful in finding how to solve the issue (including internet search and asking several LLMs). I don't need my function to have user context (I could send that from the spfx) but I need this to work without any redirects. I would appreciate help to be able to call the function from the spfx seamlessly, while keeping the function secured with Microsoft identity. (porting from a https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte, as requested)
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.
Getting error when trying to get user access token in SPfx solution using MSAL
Referring https://github.com/microsoft/CopilotStudioSamples/tree/main/SharePointSSOComponent and tried to implement it. Getting error when trying to get user access token using MSAL. The Error is: Unsafe attempt to initiate navigation for frame with origin 'https://XXXX.sharepoint.com' from frame with URL 'https://login.microsoftonline.com/XXXXXXXX-595d-472c-8248-0dc58f852d61/oaut…04MDZhLTc4NTFlOGEzNWJjNSIsIm1ldGEiOnsiaW50ZXJhY3Rpb25UeXBlIjoic2lsZW50In19'. The frame attempting navigation of the top-level window is sandboxed, but the flag of 'allow-top-navigation' or 'allow-top-navigation-by-user-activation' is not set. Issue is intermittent and usually occurs when running on localRename a document stored inside a SharePoint document library using Office Dev PnP
How to rename a document/file stored inside a documentlibrary using Office Dev PnP? I haven't found a cmdlet for it. Specifically I want to rename the OneNote Notebook called "Team Site Notebook" that's generated for each team site to a name which corresponds to the site title, e.g. "{SiteTitle} Notebook". If that's not possible, the alternative solution would be to create a new OneNote Notebook which corresponds to the site title, e.g. "{SiteTitle} Notebook". If you have a solution for that, that's also great.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
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 environment
