Conditional formatting in lists using JSON condition is between numbers
I'm trying to use JSON to conditional format a color based on the number in the cell. This code works if the number is one in the cell. I would like to apply the same color if the number is 2 or less and also apply a different color if the number is between 3 and 5. I've tried replacing the "1" above with "=IF (<=2)" and "=IF(@currentField <=2)" with no luck. ThanksConditional 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.
InvalidRequest Error for Attachments in Personal Microsoft Lists
Hello Community, I’m experiencing a persistent issue with Microsoft Lists (personal account, accessed via web on Windows 11 using Microsoft Edge). Problem: All attachments in my personal Lists return the following error when clicked: {"error":{"code":"invalidRequest","message":"Invalid request"}} This happens for both my oldest and recently uploaded attachments. This does NOT happen to NEW list items as of today and onwards I verified that attachments were successfully uploaded at the time, but now none are accessible. Age of my uploads stretch from 2023 to this time Environment: Windows 11 (fully updated) Microsoft Edge (latest version) Lists accessed via web (not the app) Personal Microsoft account (not work/school) No recent migration, rename, or permissions changes. Steps Tried: Renamed the list (removed special character “ø” from the name). Uploaded new attachments Checked that both my sub-items are inaccessible (attachment and personal attachment fields used separately from item to item. No double uploads) Checked OneDrive and Recycle Bin — no attachments visible. No access to “Site contents” since this is a personal account. Questions: Is this a known issue with personal Lists attachments? Are attachments stored in a hidden folder in OneDrive/SharePoint for personal accounts? If so, what is the usual path? Is there any way to recover these attachments or fix the invalidRequest error? Impact: I used Lists to manage and store receipts, and now all attachments appear broken. This is critical for my workflow. Any guidance or escalation would be greatly appreciated!Linking a specific OneNote page to a Sharepoint List
Hello, I am trying to link a OneNote page in a Sharepoint list via the Hyperlink field. So basically users would copy the link to the OneNote (shared) page in the URL field of Sharepoint. However, I keep getting an error when I save the list with the page URL in (it works well before saving!). I can link the general notebook, but not a specific page (which is what I am interested in). I read it might be linked to a limitation in the number of characters that Sharepoint accepts as URL? Can somebody help me on this? Many thanks! Kind regards Valeria
Validation rule for postal code is being ignored
In the SharePoint list, there is a column “Country” and a column “Postal Code.” A validation rule has been configured in the list validation settings to ensure that when the country “Germany” is selected, only postal codes with exactly 5 digits can be saved. Currently, this validation rule is being completely ignored. Regardless of whether the postal code contains fewer, more, or no digits at all, the entry can always be saved. The validation does not take effect. Expected Behavior: When Germany is selected in the Country field, the entry should only be saved if the postal code contains exactly 5 numeric characters. If the input is invalid, an appropriate error message should appear and prevent saving. Actual Behavior: The validation rule is ignored. All inputs — including invalid postal codes — are saved. No error message is displayed. Impact: Incorrect or incomplete data is stored in the list. Manual corrections are required afterward, causing additional effort and increasing the risk of errors. The english version of formule we used =IF([Land]="Deutschland", IF(LEN([Postleitzahl])=5, 1, 0)) Why doesn't the validation work? Thank you in advance for your comments !
