Recent Discussions
New Calendar List Template
What's the plan with the new Calendar List Template? It's modern look but not linked to Events, no fields, no explanation of its difference from events, no alternative Events list (which is poor but the best we have)... How do I create an SPO Events list? I used to add an Events web part and click "add event;" now the link is disabled. The web part is configured to all events on the site (not a specific list). I can't even copy it from an existing list in another site. There's a migrated SP2013 Events list on the site, but that didn't previously prevent the creation of a new one...
How to extract full SharePoint Site Usage Analytics via API (avg time, device, heatmap)?
Hello everyone, I'm trying to automate the extraction of SharePoint Site Usage Analytics reports, but I'm running into a limitation where the data exposed by Microsoft Graph API does not match the analytics available in the SharePoint UI or the exported Excel report. In the SharePoint site analytics page, I can see metrics such as: Unique viewers Site visits Average time spent per user Usage by device Usage by time (heatmap) Trend charts for the selected period (7 / 30 / 90 days) There is also a Download button that exports an Excel file containing all these analytics. However, when I query Microsoft Graph using the SharePoint usage reports endpoints (for example: getSharePointSiteUsageDetail), the API only returns a subset of the data: { "lastActivityDate": "2026-01-20", "uniqueViewers": "28", "siteVisits": "615", "avgTimeSpentPerUser": null, "byDevice": null, "byTimeHeatmap": null, "fileCount": "759", "activeFileCount": "45", "pageViewCount": "615", "visitedPageCount": "28", "reportRefreshDate": "2026-01-20", "reportPeriodDays": "7" } As you can see: Fields like avgTimeSpentPerUser, byDevice, and byTimeHeatmap are always returned as null. The numeric values (unique viewers, visits, etc.) are also different from what the SharePoint UI shows for the same time range. The Graph data appears to be delayed and aggregated differently compared to the UI. From what I can tell: These metrics seem to exist internally (since the UI and Excel export clearly show them). But they are not exposed through any documented Graph API endpoint. The Excel download does not appear to have a stable or supported API endpoint that can be called programmatically. My questions Is there any supported way to programmatically retrieve the full SharePoint analytics dataset (including avg time, device breakdown and time heatmap)? Is the Excel export endpoint accessible via any supported API? Are these fields intentionally not exposed in Microsoft Graph? If this is not possible today, what is the recommended approach for automating this type of analytics collection? Any clarification or official guidance would be greatly appreciated. Thanks in advance!
User Accounts Not Populating with Filters in Directory with PnP V4
I'm working on building a staff directory for my org. I'm leveraging the PnP Modern Search Web Parts for this directory. I am having issues with 5 user accounts not populating in the Search Results Web Part with the department or office filters applied to the SearchTerms box. I have RefinableString03 set to People:Department and People:SPS-DEPARTMENT. RefinableString09 is set to People:OFFICE and People:SPS-Location. If I set the SearchTerms box to *, the 5 missing user accounts populate along with other accounts that needed filtered out. The location/office and department attributes are set for each of these accounts. They show in the hovercard for each account. It seems that the department and office/location attributes are not being picked up by the SearchTerm filter when the RefinableString03 and or RefinableString09 are applied to the Search Results Web Part. User account attributes are synced from our on-prem AD environment. What piece am I missing here?
Hoe kun je een Excel Werkmap in SharePoint delen en bepaalde informatie verbergen?
Bij een klant van mij wordt in SharePoint door twee personen gewerkt met een gedeelde Excel werkmap. Beide gebruikers kunnen gelijktijdig muteren en ze zien in real time welke aanpassing de collega maakt. Tot zover geen probleem. Nu willen ze de werkmap ook delen met personen buiten hun organisatie. Deze mogen niet muteren, maar ze mogen ook niet alle regels van de werkmap zien. Hoe kan ik dat regelen in SharePoint?
Page Redirection
Hello, I am trying to simulate a migration scenario in SharePoint Online and am running into a limitation I cannot resolve. For demo/testing purposes, I have two SharePoint Online sites (e.g. Old and New). I would like to redirect a small number of individual pages from the old site to corresponding pages in the new site, while the rest of the old site remains unchanged. Example: Redirect https://ps3c.sharepoint.com/sites/Old/SitePages/Test.aspx to https://ps3c.sharepoint.com/sites/New/SitePages/Test.aspx The page is a modern SharePoint page, and the URL itself is fixed for the purpose of the demo (i.e. users or tools open the page directly on *.sharepoint.com). All documentation I could find only describes redirecting entire SharePoint sites, not individual modern pages. Client-side approaches (JavaScript, HTML meta refresh, etc.) also appear to be blocked in modern SharePoint. Is there any supported or recommended way in SharePoint Online to implement page-level redirects for modern pages, or is this currently not supported by design? Kind regardsQuick steps disappear from SharePoint list
I have 4 quick steps set up for my sharepoint list. Each one executes a flow. Twice now they have disappeared. I don't see them when I go to Automate or when I go to manage quick steps. Refreshing the page didn't help. The only way I could get them back was to add a new quick step, save it. Refresh the page and go back into manage quick steps and they were all there again.Intermittent failures when creating new libraries in modern SharePoint
Hi everyone, I’m seeing an issue in our modern SharePoint Online site collection where creating new document libraries has started failing. This site has worked normally for years, but over the past week, most library creation attempts haven't worked. 1) The page briefly flashes or glitches during the creation process. and 2) A non‑ending spinning wheel when I hit "create" or 3) Creation attempts return “Something's not right.” error page. The failures happen across all subsites, in multiple browsers, and I’m a Site Collection Administrator. No permission changes were made recently. Has anyone seen similar intermittent library creation failures in a modern site collection, or know what might cause this kind of inconsistent behavior? Any guidance would be appreciated. Thanks! MeaganAutomated upload competing with users who have a file open in Co-authoring mode
This behavior began approximately mid-December. An automated process uploading/overwriting a file located in SharePoint online was constantly receiving errors when executing. We ran through several scenarios for troubleshooting but in the end, we had found that a user would open the file and leave it open in the background through the working day. This behavior produced some co-authoring lock on the file where people could get in and work on the file at the same time but locked out the automated process that would upload a new version of the file regularly. We fixed the behavior after consulting with the people who were referencing the file, they were gathering data from it and were not updating it in any way. So, we broke the permission inheritance for this file and set it up to be read-only for all users but the process that was uploading the file. This allowed the people to reference the file and undid the locking behavior that we had observed. Now, before the middle of December, this locking mechanism didn't exist. Users could have the file open in edit mode and our automated process to update the file was able to upload and overwrite at the same time without issues. Has anyone else observed this behavior within the last few months? We didn't open up a ticket with Microsoft to get an official answer if something new was perhaps implemented and we're curious if anyone has opened a ticket regarding this behavior. Also, I briefly look through the message center and couldn't find any changes in there that seemed to be related to this change by their titles. The error that was seen from the automated process was: The remote server returned an error: (423) Locked. Any input appreciated - I am definitely curious to hear if others are observing this as well.
PromotedState does not update anymore
I wish to update the promoted status to 0 (page), 1 (unpublished news) or 3 (published news). I was always doing this via SharePoints column formatting. See .json column formatting below. This worked perfectly fine until about this week. Now it doesn't seem to work anymore. Now I tried updating the PromotedState also via PowerAutomate. This also doesn't seem to work... How should I now change the PromotedState. Does someone have any clue how I can update the PromotedState or why the column formatting way of wokring, suddently doesn't work anymore? The json code for column formatting. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "flex-wrap": "nowrap", "display": "flex", "flex-direction": "row" }, "children": [ { "elmType": "div", "txtContent": "=if(@currentField == 0 ,'0 : Page' , if(@currentField == 1, '1 : News (Unpublished)' , if(@currentField == 2 , '2 : News','') ) )", "style": { "box-sizing": "border-box", "padding": "4px 8px 5px 8px", "display": "flex", "border-radius": "16px", "align-items": "center", "overflow": "hidden", "margin": "4px 4px 4px 4px", "border": "1px solid" }, "attributes": { "class": "=if(@currentField == 0 ,'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-white' , if(@currentField == 1, 'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-themeLighter' , if(@currentField == 2 , 'ms-fontColor-white ms-borderColor-themePrimary ms-bgColor-themePrimary','') ) )" } }, { "elmType": "div", "style": { "font-size": "18px", "cursor": "pointer", "padding": "10px", "border-radius": "50%" }, "attributes": { "iconName": "MoreVertical", "class": "ms-fontColor-themePrimary ms-bgColor-themeLighter--hover" }, "customCardProps": { "openOnEvent": "click", "directionalHint": "rightCenter", "isBeakVisible": true, "formatter": { "elmType": "div", "style": { "display": "flex", "flex-direction": "column", "align-items": "flex-start" }, "children": [ { "elmType": "div", "txtContent": "Change to Page (0)", "style": { "padding": "10px 20px 10px 20px", "cursor": "pointer", "width": "200px" }, "attributes": { "class": "ms-bgColor-themeLighter--hover" }, "customRowAction": { "action": "setValue", "actionInput": { "PromotedState": "0" } } }, { "elmType": "div", "txtContent": "Change to unpublished news (1)", "style": { "padding": "10px 20px 10px 20px", "cursor": "pointer", "width": "200px" }, "attributes": { "class": "ms-bgColor-themeLighter--hover" }, "customRowAction": { "action": "setValue", "actionInput": { "PromotedState": "1" } } }, { "elmType": "div", "txtContent": "Change to published news (2)", "style": { "padding": "10px 20px 10px 20px", "cursor": "pointer", "width": "200px" }, "attributes": { "class": "ms-bgColor-themeLighter--hover" }, "customRowAction": { "action": "setValue", "actionInput": { "PromotedState": "2" } } } ] } } } ] } The HTTP SharePoint call to update the PromotedStatus.
Add items Permission level
Hi, I'd like to know a way to set permissions on a list so that users in the SharePoint site - Members group can't see existing items in the list that don't have unique permissions assigned. They can only add new items in this list. Once an item is created, a workflow would be triggered that would add a unique permission only for that item. The problem is that when creating a Permission Level with only the ability to add items, the user loses access to the custom item creation form.
Issue: Date picker / calendar icon disappeared from Page Details pane
Hi everyone, I am reaching out to see if anyone else is experiencing a recent issue with the Date field in SharePoint Online. Since yesterday (January 15th), the calendar icon / date picker has disappeared from the Page Details pane when editing properties for News pages. Here are the details of the issue: The Problem: When clicking on a Date column in the Page Details pane, the calendar selector no longer pops up. Manual Entry: It is still possible to type the date manually, but the visual interface is gone. Comparison: Interestingly, the date picker works perfectly fine when using "Edit in grid view" in the Site Pages library. The issue seems specific to the side property pane (Details pane). Browsers tested: I have reproduced the issue on both Microsoft Edge and Google Chrome (latest versions), even after clearing the cache. Is this a known bug following a recent update, or is there a new UI setting I might have missed? Has anyone seen a similar report in the M365 Service Health dashboard? Thanks in advance for your help!Microsoft Lists, bad links at pictures
About a year ago, I created a list in Microsoft Lists and filled a "Picture" column with photos. It's now located at https://lists.live.com/. The images stopped displaying in March 2025 and several times before that. Only a placeholder image with an ID (e.g., "https://learn-attachment.microsoft.com/api/attachments/5a9a22e9-7005-4772-a54f-9ca6434db3bb?platform=QnA") is shown. The problem occurs in the browser (Chrome), in the Lists desktop application, and in the Android app. I've tried it on three PCs and two mobile devices, and the problem appears the same everywhere. I suspect there's something wrong with the link between the image in the list and the Microsoft server. How can this problem be solved? When clicking on a corrupt picture/link I end in a new browser tab showing this: { "error": { "code": "invalidRequest", "message": "Invalid request" } }
Different languages in different sites
Hi, My Sharepoint sites are appearing in multi languages and it's really annoying. I have changed my account language in to Japanese once and then changed back to English. However, almost sites still appears in Japanese. Could anyone guide me away to change back to English for all. Thank you,
Restrict shareing files in a document library to members of that document library
Hi, I have a site with multiple document libraries, lets call them Accounts, Managers and General. Each document library has removed inheritance and the Members and Visitors groups removed and a security group added with edit permission. e.g. SP_Managers group Is there a way for me to be able to restrict sharing links to files to only users that already have access to the document library? i.e. someone in the Managers library can only share a link with others with access to that document library. In my current case, if someone in the managers library (who is a member of the SP_Managers security group to get access) shares a file with a general user (not in the security group), that general user can not only access the shared document but, can now see the Managers Document library listed in SharePoint (Not any content) which I don't want to happen. Another option may be to make it so the top level folder isn't visible to non members even if a file is shared (I don't know if that is possible either) but the restricting of sharing would be a better soloution. Thanks for any advice IanJSON for list form body
JSON for list form body. Hello all, I am looking to conigure tge layout of the list form into sections, nothing fancy, just section heading with nominated fields. However i would like to also specify fields per row, and if there is a single field on a row iy measures the full width etc. Here is a sample of JSON i am using. Could someone please advise on inclusions to achieve tge above? "sections": [ { "displayname": "", "fields": [ "Title", "Hyperlink" ] }, { "displayname": "", "fields": [ "Title", "Hyperlink" ] }, { "displayname": "Primary Category", "fields": [ "Primary Technical Function" ] }, { "displayname": "Related Categories", "fields": [ "Related Technical Functions", "Related Supporting Functions" ] } ] }
SharePoint Classic Templates
Hello community! So we all know that classic sites need to be converted to modern sites, however, if you have a site that was built on a classic template (but has since been converted to a modern site), do you really need to do anything else? I could honestly give less of a crap what happens to classic templates, I just want to make sure that my site which was originally built on a classic template isn't in jeopardy. My knee-jerk reaction is "no" because otherwise there would be thousands upon thousands of sites that likely break. Thoughts, feelings, and opinions appreciated. Thanks!Order of Server Shutdown and Restart in SharePoint Farm
Hello, I'm planing to restart my company Sharepoint 2019 farm, and i need to know if there is an order to respect in shutdown and starting the servers. The farm is composed of Two Database server in Failover cluster, App Server, Web Frontal Server, Search server and Office Online server. Thank youPnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?
Events
Join us for a global digital event to celebrate the 25th birthday of SharePoint!
Gear up for an exciting look at SharePoint’s historic moments along with an exclusive look ahead to the next chapter...
Online
Recent Blogs
- For nearly 25 years, SharePoint has powered how organizations connect, collaborate, and manage knowledge at scale. Today, more than a billion people rely on SharePoint every month to store content, s...Jan 14, 2026
- Register now for the Microsoft 365 Archive + Preservica Webinar January 28, 10:00 AM PT / 6:00 PM GMT Join us for this free webinar on January 28th, 2026 featuring Microsoft 365 Archive and Preser...Dec 19, 2025
