Lists
3136 TopicsCan't switch off grid view
We've a number of pages (about 90) We have a couple of views on each page (different for each one) from a main List This works for most of the pages/views we have. However some have defaulted to Grid View and we can't switch it off How can we get rid of this? we don't want grid view only the link to the Canvas App form to enter information. We've no idea why it's appeared and we can't get rid of it. Does anyone have any idea how we can revert these to the default view. Thanks26Views0likes1CommentAI- based Post Sorting
I have developed a Post and Comment module inside SPFx. where i have 3 sharepoint list:- Posts Comments Reaction here is the SPFX, with 2 posts and the first post has 2 comments:- Currently the Posts and their Comments will be shown sorted by the created date , here is the method to show the posts:- async getPostsPage(pageSize: number = 10, afterId?: number) { let url = `${this.siteUrl}/_api/web/lists/getByTitle('SocialPosts')/items` + `?$select=Id,Title,Body,Created,Author/Id,Author/Title,LikeCount,CommentCount` + `&$expand=Author&$orderby=Id desc&$top=${pageSize}`; if (afterId) url += `&$filter=Id lt ${afterId}`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map(v => ({ Id: v.Id, Title: v.Title, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, CommentCount: v.CommentCount || 0 })) as import('../Models/Models').Post[]; } and the comments:- // ---------- Comments ---------- async getComments(postId: number): Promise<Comment[]> { const url = this.commentsUrl() + `?$select=Id,Body,Created,Author/Id,Author/Title,LikeCount,Post/Id,PostId` + `&$expand=Author,Post&$filter=PostId eq ${postId}&$orderby=Created asc`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map((v) => ({ Id: v.Id, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, PostId: v.PostId ?? v.Post?.Id, })); } but the client is asking us if there is a way to order the items using AI algorithm so it show the most relevant posts and comments first? which approach i can follow? to allow order items inside SPFx using AI algorithm instead of Created date?? any advice?12Views0likes0CommentsGlitch when creating Sharepoint list from Excel
I've been trying to create a Sharepoint list from an Excel spreadsheet, and I keep having a problem with one column. The column contains mostly numbers, but they are not formatted very consistently. Some records have additional characters like #, / or -, which is not a problem for me. However, if I choose "Number" as the data type for that column in Sharepoint, I get errors on the records that contain non-numeric characters, and the entire list isn't converted. If I first convert the column to Text or General format in Excel, then choose "single line of text" as my Sharepoint data type, the list isn't created at all. After a few seconds it says that the process is 100% complete, but no list is created. Any ideas would be greatly appreciated. Thanks.9.9KViews3likes8CommentsSharePoint 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?48Views0likes1CommentSP List Description - not visible to list user
Hiya, I am using a modern SP list, and I would like the overall SP list description to show under the list name for users to have as guidance on their updates. I have added the description to the list settings, but it doesn't seem to do anything. I have also looked through list settings to see if it am missing something... Is this possible? what am I not doing? Any help would be appreciated.8.4KViews0likes7CommentsImprove Microsoft Lists UX: Open Lookup Details in a Panel with JSON Column Formatting
🚀 Enhance Microsoft Lists UX with JSON Column Formatting! Have you ever clicked on a Lookup column in Microsoft Lists and ended up opening multiple tabs? There’s a better way! In my latest video, I show you how to open related item details in a panel on the same page using JSON column formatting. This simple tweak improves navigation, saves time, and creates a smoother user experience. ✅ What you’ll learn: ✔ Apply JSON formatting to Lookup columns ✔ Open details in a side panel without leaving the page ✔ Boost productivity in Microsoft Lists 🎥 Watch the full tutorial here: https://youtu.be/yKoNRY_Orhc #MicrosoftLists #Microsoft365 #JSONFormatting #Productivity #UXDesign11Views0likes0CommentsSorting 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.Solved44Views0likes2CommentsSharePoint 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.106Views2likes3CommentsModernizing 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.23Views0likes0CommentsChange 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.8KViews0likes8Comments