microsoft lists
1707 TopicsDifferent languages in different sites
Hi, My Sharepoint sites are appearing in multi languages and it's really annoying. I have changed my account language in to Japanese once and then changed back to English. However, almost sites still appears in Japanese. Could anyone guide me away to change back to English for all. Thank you,21Views0likes2CommentsMicrosoft Lists, bad links at pictures
About a year ago, I created a list in Microsoft Lists and filled a "Picture" column with photos. It's now located at https://lists.live.com/. The images stopped displaying in March 2025 and several times before that. Only a placeholder image with an ID (e.g., "https://learn-attachment.microsoft.com/api/attachments/5a9a22e9-7005-4772-a54f-9ca6434db3bb?platform=QnA") is shown. The problem occurs in the browser (Chrome), in the Lists desktop application, and in the Android app. I've tried it on three PCs and two mobile devices, and the problem appears the same everywhere. I suspect there's something wrong with the link between the image in the list and the Microsoft server. How can this problem be solved? When clicking on a corrupt picture/link I end in a new browser tab showing this: { "error": { "code": "invalidRequest", "message": "Invalid request" } }11Views0likes0CommentsJSON for list form body
JSON for list form body. Hello all, I am looking to conigure tge layout of the list form into sections, nothing fancy, just section heading with nominated fields. However i would like to also specify fields per row, and if there is a single field on a row iy measures the full width etc. Here is a sample of JSON i am using. Could someone please advise on inclusions to achieve tge above? "sections": [ { "displayname": "", "fields": [ "Title", "Hyperlink" ] }, { "displayname": "", "fields": [ "Title", "Hyperlink" ] }, { "displayname": "Primary Category", "fields": [ "Primary Technical Function" ] }, { "displayname": "Related Categories", "fields": [ "Related Technical Functions", "Related Supporting Functions" ] } ] }25Views0likes2CommentsInvalidRequest 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!34Views0likes1CommentValidation 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 !72Views0likes2CommentsPnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?16Views0likes0CommentsConditional 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. ThanksSolved92Views0likes3CommentsConditional 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.77Views0likes3CommentsSharePoint LISTS - @ mention Comment
Hello all. I have started a TEAMS and Sharepoint and LIST for our user group. Some of the members are outside the organization, and are listed as guests. I have added all the members in TEAMS, Sharepoint and LISTS... The LIST is for us to collaborate. When I use the comment field and use the @ mention for someone who is a guest or outside the organization, their name does not show up to select them. How can I get these folks to work with the @ mention function. Thank you for your help. JulieSolved2KViews0likes3Comments