lists
3133 TopicsSharePoint Online List: Filtered List View Not Refreshing After Change
Before recently, any time a change was made to a list row column that a view filter was based on, the items in view would automatically refresh to show the changes. Now the list view doesn't update unless the user refreshes the page in their browser. This is a consistent issue across all lists in the tenant. Our organization has SharePoint lists with a 'Status' column that impacts what items are shown in a view and its hurting productivity when these views aren't updating with new items unless the page is manually refreshed. Is there a new setting that is impacting the ability for filtered views to auto-refresh?13Views0likes0CommentsSorting a SharePoint List alphabetically it Swedish
Hi! I'm working on a ShrePoint site for my organisation and have run into an issue with a SharePoint list. The entire site is in Swedish and I've run inte issues when Grouping/Sorting. In the list i have a column (lets call it "Letter") that uses a formula =LEFT(Title) to extract the first letter from the Title of each list item for the purpose of being able to group by letter. So the list is first grouped by "Letter" and the Sorted alphabetically by "Title". The issue is how SharePoint handles "alphabetical order" of the Swedish alphabet. The Swedish alphabet is the same as English, but with 3 additional letters, "Å", "Ä" and "Ö". While they could be considered A's and O's with diacritics, in Swedish they are considered their own letters. And alphabetically they come after Z. I want my list sorted "A, B, C, ... X, Y, Z, Å, Ä, Ö", but SharePoint sometimes sorts it "A, Ä, Å, B, ... N, O, Ö, P, Q, ..., X, Y, Z" The strange thing, however, is that this problem only arises when i load the list on a SharePoint page as a Web part. So in short: Problem only occurs when grouping or sorting the column "Letter", and i only occurs when using the list in a web part. Has anyone run into anything similar? I've looked thourgh all the setting i can access for both the site and the list. All Language settings are set to Swedish as well.Solved23Views0likes1CommentSharePoint Threshold Limit Mitigation via Indexing Strategy
To address the SharePoint list/library threshold limit issue, we implemented a structured indexing approach: The document library contains 5000 items distributed across multiple libraries. We created indexes on relevant columns to optimize query performance and enable filtering/sorting without triggering the threshold limit. This indexing strategy allowed us to successfully access and manage the SharePoint site without performance degradation or errors due to the threshold limit. This approach ensures scalability and maintains usability for end users, especially when working with large datasets in SharePoint Online. Anyone has face the similar kind of situation and tried in a different way to fix that, then please share.93Views2likes3CommentsModernizing Legacy Intranets with SharePoint Online
Modernizing Legacy Intranets with SharePoint Online: A Strategic Guide In today’s fast-paced digital landscape, legacy intranets often become bottlenecks rather than enablers of productivity.Outdated interfaces, limited mobile access, poor search capabilities, and siloed content can hinder collaboration and employee engagement. Enter SharePoint Online—Microsoft’s cloud-based platform that offers a modern, scalable, and secure solution to revamp your intranet experience. Why Modernize? Legacy intranets, typically built on older versions of SharePoint or custom platforms, struggle to meet the evolving needs of hybrid workplaces. Modernizing with SharePoint Online brings: Cloud-first agility: Seamless updates, scalability, and integration with Microsoft 365. Enhanced UX: Responsive design, intuitive navigation, and personalized content. Improved collaboration: Deep integration with Teams, OneDrive, and Viva. Security & compliance: Enterprise-grade governance and data protection. Key Benefits of SharePoint Online Modern Sites & Pages SharePoint Online introduces communication sites and team sites with rich, responsive layouts. These are easy to build and maintain, even for non-technical users. Powerful Search & AI Microsoft Search, powered by AI, delivers personalized and contextual results, making content discovery faster and smarter. Integration with Microsoft Viva Viva Connections brings your intranet into Microsoft Teams, creating a unified employee experience hub. Automation & Workflows With Power Automate and Power Apps, you can digitize forms, approvals, and business processes without writing code. Migration Strategy: From Legacy to Modern Modernization isn’t just a lift-and-shift. It requires a thoughtful approach: 1. Assessment & Planning Audit existing intranet content and usage. Identify what to migrate, archive, or redesign. Define goals aligned with business needs. 2. Information Architecture Redesign Reorganize content using modern taxonomy and metadata. Leverage hub sites for better navigation and governance. 3. Content Modernization Convert classic pages to modern pages. Use modern web parts for dynamic content delivery. 4. User Adoption & Training Engage stakeholders early. Provide training and support to ensure smooth transition. 5. Governance & Security Implement policies for content lifecycle, permissions, and compliance. Use Microsoft Purview for data governance. Real-World Impact Organizations that have modernized their intranets with SharePoint Online report: 30–50% increase in employee engagement Significant reduction in IT overhead Faster onboarding and knowledge sharing Final Thoughts Modernizing your legacy intranet with SharePoint Online is not just a tech upgrade, it’s a strategic move toward a more connected, agile, and empowered organization. With the right planning and execution, your intranet can become a central pillar of digital transformation.15Views0likes0CommentsChange a Choice Column to a Yes/No column
Hi, I've created a SharePoint list from an Excel spreadsheet to use as a data source, and it has imported my data in some instances as Choice columns. However, I want them to be Yes/No columns. Unfortunately the Yes/No option is missing from both the Edit Column menu, and the list of column options when clicking the column from within List Settings. How can I change these columns to Yes/No columns?7.7KViews0likes8CommentsPrevent list form
I have a list with 10 columns. I created a custom view to share this same list with some partners, but they only can see 6 columns. The problem is, I what that guests can only view the list, I dont want then to open the form. The list is already guest only, so, they cant edit the form. The problem is, even they cant edit the form, they can see the data of the other 4 columns on the form. Is there a way to prevent a guest to open the form of a list on the sharepoint? Thank you85Views0likes2CommentsGallery view: horizontal scrolling?
I have a gallery view on a list with grouping. Currently, each group will be shown across multiple rows within the boundaries of the spCardContainer element. I want to display each card within a group on a single "line" with a horizontal scrollbar. I know I have options in CSS using (perhaps) flex-wrap, but I could use some help putting it together in JSON for my formatting. Who can help?17Views0likes0CommentsMaximum value for SharePoint List unique ID
Hi everyone, I have a SharePoint List that gets updated daily. I have 25000-30000 items that get completely deleted every night and then created again with new values and content. So every new item gets a new list ID. I'm a little bit worried because, even though SharePoint lists can store up to 30 Million items, what happens when the unique ID assigned to each item gets "overflowed"? For example, right now the last item's ID is 480368, and as I said before I create 30000 new items every single day , so doing a simple math it would take 1000 days to reach an ID number of 30000000 (if that's possible, I don't even know). What happens when the ID reaches a limit? Would it break the list? Will I be able to keep creating new items? Just to make it completely clear: the list will never reach the 30 million limit. It will always stay on 25000-30000 items. But I'm scared that the ID will break this process in less than 3 years. Thanks for your help!1.5KViews2likes3CommentsSharePoint List calculated column formula using a Lookup column reference
Given: A SharePoint List (SPL) called Contractors with the following columns: ContractorID // Display name of the default ID column ContractorName Another SPL called Reports with the following columns: ReportID // Display name of the default ID column ReportNumber // Calculated column Contractor_ID // Lookup column referring to the ContractorID column of the Contractors SPL The calculated column, ReportNumber, would have a formula similar to: = [ReportID] & "-" & Contractor_ID Question: Does SharePoint Lists support the use of a Lookup column in the formula of a calculated column? If so, I need help on the proper syntax for the formula. (The formula above is not working) Thanks in Advance84KViews1like9CommentsGraph API 1.0 - Listing lists doesn't return all lists (todoTaskList)
Hi, first time posting here, please let me know if I should be doing something differently! I've searched throughout the internet and couldn't find a reason for this. I've got a couple of users running into a problem where the https://learn.microsoft.com/en-us/graph/api/todo-list-lists?view=graph-rest-1.0&tabs=http endpoint only returns one list (Flagged Emails), though these users have and see many other lists in the To Do desktop (macOS) app. I've confirmed in both cases it's the same user that's identified in my app/integration and in the desktop app. They can see the tasks in that list without a problem. There are no errors requesting that list, and asking via `/users/{id|userPrincipalName}/todo/lists` also returns the same response (with that one list). Is there any known situation where this could be happening? Am I missing something obvious? Is there something else I should be trying? I've got many other customers using the To Do integration without a problem. I'm aware "My Day" and a few other special lists aren't returned. Thank you so much!250Views0likes6Comments