If list multi-select choice column contains certain value, auto-populate flag column in related list
I have a SharePoint list called List1 with columns ID (single-line text) and Type (multi-select choice): ID Type ---- ------ ID1 Apple ID2 Apple, Pear ID3 Pear, Banana, Apple ID4 Pear ID5 And a second list called List2 with columns ID (a Lookup column) and Has_Pear (yes/no). I want to automatically populate Has_Pear with "Yes" if the related row in List1 has "Pear" in the Type column. Like this: ID Has_Pear ---- ------ ID1 No ID2 Yes ID3 Yes ID4 Yes ID5 No How can I automatically populate the Has_Pear column?
Excel Desktop App hangs when attempting to open documents from SharePoint to edit
User attempts to open Excel Documents saved in SharePoint by selecting Edit in Desktop App. As the Excel Desktop App begins to open a message displays stating: We have opened this document in Microsoft Excel in your computer. However, the Excel App just hangs without fully opening (see Screenshot). No problem detected when opening the Excel Desktop app directly, Desktop App opens freely. Excel MS365 is up-to-date version 2609 build 16.0.20430 64 Bit (Before reinstall). I have uninstalled the MS365 Office packet and reinstall it directly from the User's Office Portal, to no avail.
SharePoint News Email “Content too large” issue – size limit clarification
Hi, We are currently trying to send a SharePoint News post via email and encountering the following error: “The contents of this page are too big to send in email.” We performed testing to understand the limitation and observed the following: Full newsletter (~5.29 MB) → ❌ Error Pages 1–12 (~3.11 MB) → ❌ Error Pages 1–11 (~2.80 MB) → ✅ Works Slight increase (~2.90 MB) → ❌ Error again ✅ Based on testing: Practical threshold seems around ~2.7–2.8 MB Above this, email rendering fails ❓ Questions: Is there a documented maximum size limit for SharePoint News email content? Is the limit based on: Total content size after rendering? Image count/size? Can this limit be configured or increased? What are the recommended best practices for image-heavy newsletters? ✅ Current understanding: It appears that the limitation is due to HTML email rendering size rather than just file size Any clarification or official guidance would be appreciated. Thanks.Hub Site association approval request fails with 403 Forbidden (previously working, regression)
Sites configured to require approval before joining our Hub Site are failing the association request with an HTTP 403 Forbidden error[browser DevTools Network tab}. This same workflow was functioning correctly as of [early August 2026]. Hub sites that do not require join approval continue to associate successfully — the failure is isolated specifically to the approval-required path. Steps to Reproduce As a site owner, go to Site Settings → Site Information (or Site Contents → hub association) on a site that is not yet associated with the hub. Attempt to associate it with [Hub Site URL], which has RequiresJoinApproval set to $true. Observe that the request fails immediately (or fails when the approver attempts to approve it — specify which point in the workflow fails). Repeat the same steps against a hub site that does not require approval — association succeeds without error. Expected Behavior The association request should be submitted and routed to the configured approver(s) for review, consistent with behavior observed as recently. Actual Behavior Request fails with HTTP 403 Forbidden. [browser DevTools Network tab - attached the HAR file for reference] Error Details HTTP Status: 403 Forbidden [browser DevTools Network tab - JoinHubSite(@v1)?@v1] Troubleshooting Already Performed Confirmed association without approval works (isolates the issue to the approval workflow specifically)Confused about public CDN and if its required to host custom fonts
We would like to add custom fonts for our Intranet using SharePoint online. I see that to use the brand center you must enable a public CDN. We are concerned that our assets could be accessed anonymously when using the public CDN. Is there any way to enable the brand center with only assets stored in SharePoint online and not enable the CDN. Our offices are all based in the same region so CDN is not required.
Custom fonts in SharePoint not working on my tenant (Brand center)
I'm trying to use the brand center to configure custom fonts and themes on my sites but it appears as the setup was not finished properly or something like that as I can't set custom fonts. I tried it first on my dev tenant where everything went according to the documentation but when I configured it on the main tenant something appears to have happened as it won't allow me to set the fonts. I've made some comparisons with the dev tenant, and it appears as if the list controlling the fonts was not created right (it's missing the content types and probably scripts that font list uses) Anyway... I haven't been able to find any way of fixing it nor recreating the site or even delete it so I'm kind of lost with this.Sites with long file path length
I have a big problem to solve with SharePoint online Teams sites where data was migrated from On-Prem file shares and there are more items with a long file path length than we are able to fix. In some directories, it has gotten better but employees didn't listen to us when we told them to start creating less nested folders, shorter file and folder name and to try and fix older directories. In the beginning around 2 years ago, we migrated everything and turned on OneDrive sync and found out quickly how that wasn't going to work for one department, so we then told them to work out of the browser which seemed to solve the problem. Well, not everyone kept working from only the browser and more and more people continued to get OneDrive sync issues. Now I have ran some reports to get the actual file path length for some of the sites. For the biggest site, I show the largest file path length at 397, and I figured 220 would give a good starting point to have OneDrive successfully sync without errors given that OneDrive and File Explorer will add extra characters in the path. Starting at 220 characters, there are more than 61,000 affected files with a path ranging from 220 - 397, and more than 107,000 starting at 200 characters. The first problem to solve is to get the department to stop naming files in this way and stop creating all the nested folders. They need to establish a better naming convention. The second problem to solve is fixing as many of these as possible, but with this many items to correct it seems impossible. Has anyone worked on a SP online site to programmatically fix something like this to reduce the path length? Even trying this with a script sounds impossible, but there has to be something that can be done to help? Right??
