Conditional formatting in SharePoint lists using JSON
I have my conditional formatting working if I only refer to one number. As can be seen in the image below if the cell I want to format has the number "1" in it the formatting works. I would like the same formatting to work if for example the number was less than "2" or between 3 and 5. I've tried several options with starting with "=if...", but it either breaks the conditional formatting or doesn't make a change. I have been able to find an example that matches the attributes. Full disclosure the conditional formatting continues so I can apply different colors to other individual numbers. I'm hoping the if I resolve on the set of numbers the others will follow the same framework.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/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/
Microsoft 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
Lists: Threshold error with filtered view (<5000 items)
Hi, I have a SPO List with ~40000 entries. To work with it I created a view which gives me less than 100 entries at a time. I can set a filter on a field called "localID" and also modifying the URL to have a different localID works for me (owner of the SPO site). However, other owner of the site are NOT able to use the list nor the filtered view. They get the famous threshold error. The permissions are not changed and are still the same as on the site level. Anyone else encountered this behaviour and how did you overcome it? Best regardsPower Automate Flow moving Attachments in Email to MS List - can it get a Email as an attachment?
Created a Flow to get Emails from Outlook using Graph API to extract all metadata into columns in a MS List including attachments of the Email into a column in the MS List with the name as a hyperlink in the same site as the list; but when there is another Email as an attachment it does not come into the MS List. Is there such a limitation in MS Flow where it cannot get the Email attached in an Email as an Attachment?Article on Migration of file share to SharePoint Site
I wrote an article on LinkedIn https://www.linkedin.com/pulse/migrate-your-file-share-content-microsoft-365-site-ikechukwu-elendu-7qg6f on how to migrate file share to a SharePoint site from your on-premises PC Please look at it and give me your honest feedback. Thanks a lot.
How to hide "Updated 1 item" in SP Online Document Library Web Part.
Hi, I added a Document library web part to a page and selected the folder that I needed for that web part. I also selected the "Video Gallery" view which was formatted using JSON. However, when someone clicks the Like/Unlike button, a notification appears saying "Updated 1 item" as shown below. Is there a way to hide this notification?Lists; What Happens to the "Assigned To" Data?
In Microsoft Lists, there is a column entitled "Assigned To." I can add a member user's name; I don't know if I can enter a guest user's name. I entered my own username to test the result of entering data in this field. Nothing seems to have happened. I received no e-mail; I received no notice in Teams or ToDo or Planner. What is supposed to happen when I add someone's name there? (And could I use it for externals? For obvious reasons, I don't want to just test that.)
