Setting Up Conditional Formatting in Microsoft Lists
Microsoft Lists is a powerful tool for organizing, tracking, and managing information. But beyond just storing data, Lists also lets you visually highlight important details using conditional formatting — a feature that can make your lists more intuitive and actionable at a glance. In this post, we’ll walk through what conditional formatting is, why it’s useful, and how you can set it up step by step. https://dellenny.com/setting-up-conditional-formatting-in-microsoft-lists/Why Is SharePoint’s Priority Column Free Text and Not a Choice Field?
While https://bluesite.consulting/en-us/articles/sharepoint-site-template-projecthome-review.html, I noticed something unusual in the work action tracker list—a column setting that seemed out of place. Specifically, the Priority column isn't set up as a typical choice column with selectable options. Instead, the available choices are entered as free text in a single text field (left image) I saw this years ago in the old SharePoint. where options for a choice column are defined within a text field rather than as a standard list of choices (right image). Does anyone know why this might be happening or what could be causing this behavior?
SharePoint 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?
SP 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.Improve 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 #UXDesignDeep Dive into Microsoft Lists Advanced Formatting and Automation
Microsoft Lists has quickly become a powerful tool for teams who want to organize, track, and collaborate on information in a structured way. While many users are comfortable with the basics—creating lists, applying filters, and sharing with teammates—there’s a whole world of advanced formatting and automation that can take your Lists experience to the next level. In this post, we’ll explore how you can transform your Lists into interactive, visually engaging, and automated solutions using advanced JSON formatting and Power Automate. https://dellenny.com/deep-dive-into-microsoft-lists-advanced-formatting-and-automation/
SharePoint 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.Modernizing 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.
Change 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?
