Deep 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?
Sharepoint List - New Item displays data from previous form submission
Hi All. I have set up a Sharepoint List. I used a customised form using power apps. I have a slight issues that is annoying me. Here is sequence of events: Edit and submit an existing list item using the power apps form. After submitting updates, the list reloads - i would like to create a new list item, so i select "+ Add New Item" button When the form loads, the fields are pre-populated with input from the previous list item Currently, i have to abandon the new item, refresh the brower and try again (this now loads as expected with clear fields). Question: Is there any functionality that will "refresh" the page following a edit to an existing list item rather than a manual refresh. I can see users within the organisation getting frustrated with it if they are not aware they have to manually refresh before adding a new item to the list. Many thanks CallumMicrosoft to do list app on iPhone
Hi all. Can someone please help me. I created a task in the app and then created subtasks but on one of the subtasks I had written over it today (so annoyed at myself). Does anyone how to undo or get it back. The lists help me carry out my daily stuff so really important for me to get it back. The to do list app is on my iPhone. Would really appreciated the help
Hiding custom buttons from SharePoint column
Scenario: I have created an Power Automate instant cloud flow, linked to a custom button on a SharePoint column. The purpose of this automation and button is to send customers a PDF certificate once they have completed their training. The automation and process is working great, but I would like to tidy up the various buttons I have created, so that only one button is visible. My question is....how can I remove the additional custom buttons from the rows in the SharePoint column circled in red below. I either want one button on one row of the column (highlighted yellow). Or to alternatively put the button up on the command bar instead. I know this can be done using custom views and JSON but I have been struggling to do this so far. Any guidance would be much appreciated.
LookUp column shows up as [object Object] for single column in board view
Hi, I have seen similar questions from this topic, but I couldn't really apply to my problem. I have a SharePoint list which one of the lookup columns retrieves data from another list. This new column [Evaluated Property] allows multiple selection from the LookUp column it originates from. When viewed in list mode, the multiple selection LookUp columns results are visible (1st picture). However, when I create a board view, I get [object Object],[object Object]. I figure from other threads here in the discussion group that this can be solved using a JSON custom formatting. However, this did not seem to work. I am unsure how should I do this formatting since I am not familiar with JSON coding. Did anyone face this same issue and could suggest me how to handle this? Regards, LuccaPower Automate and SharePoint List Required field URL
Morning: I have a problem. I am creating an automation based on a SharePoint list. The automation will check for date, and send a notification out when a document needs to be revised, at which point, the Document's status will change form Live to "Due revision". To make that change, i added an Update File and here is the problem The list has "Required" fields one of them is "Document Title" which is a Hyperlink type. this field has 2 parts, URL and Alternative Text. The Alternative text is what displays on the list The problem is, when using Power Automate "Get Items" " Document Title" on the "Update Item" action, then it will display the URL on the list instead of the document name (instead of showing the name of the Document it shows URL) So, is there a way to sort this out (other than changing the filed to not required - since it is an important one) Thank you
