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 regards
Microsoft Forms: Multiple Choice Type is not showing all answers in SharePoint List
Hi, I have created a Microsoft form which contains a field "Pemohon". This field is a VLOOKUP of the type "Multiple Choice". The entries submitted in this form are reflected in the SharePoint list. After submitting the form, the multiple choices entered in the field are not visible in the SharePoint list. Only the first choice among the multiple entries is visible in the List under that field. Even if I edit the entries in the SharePoint list it is still not showing the multiple entries in that field. Is this a bug? or am I doing anything wrong? Anyone else facing this same issue?Power 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?
Forms
I was looking and all I found were similar questions from as far back as 2019, so assuming no solution has been made, yet? Is any way to get a Form to read/populate dynamic choices for a question from an external source say a SharePoint online list? This would make it easier to manage the list without having to update the form each time new options were added. For example, if I had a form with a question asking for a person to assign that day to that task and the list of people available to pick from changes daily (but is scheduled a month in advance with potential last minute tweaks), I would rather pull a list from a common external source than have to update the form each day or any time a person switches days.Creating a Form from a List
The Forms link at the top of a Microsoft List is awesome -- it lets me create a Form for the current list. I can use all of the great features of Forms to make the list be exactly what I want. What's really disappointing, though, is that there's no way (at least that I can find) to connect my beautiful form to the New button for the list. In the Forms section of the List settings, I can opt for the default form, a Power App form, or an Info Path form. It would be fantastic if I could choose the form that I just created -- FROM THE LIST -- to the list. It seems like an obvious and confusing disconnect. The very presence of a link to Forms suggests that this is the way to customize an intake form for the list. But alas, no. I assume I'm not the first person to fall into this pit! Is it on the roadmap?
