microsoft lists
1725 TopicsID Calculated Column Not Showing
I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box. However, in the actual List item, the vasty majority are showing ID as 0: There does not seem to be a pattern for this, Does anyone have an explanation for this?11Views0likes0CommentsDisable incessant nagware popups
I don't know about everyone else, but I am sick and tired of the nagware pop ups in Word, Excel, PowerPoint, Outlook, etc. Every single product harasses me with pop ups trying to tell me "hey, did you know this feature was here?", "you can do this if you click that", "let me hold your hand through using products you've used for decades even though you don't want daddy Microslop to do that". This is a prime example. I keep getting the same ones again and again and again and everything I've read indicates they should only appear once. But they don't. They keep coming back like a psychotic stalker ex who wants alimony even though you were never married. How do I get this nagware to stop?!57Views0likes1CommentClassic SharePoint features appearing on a Modern Site
I have a modern SharePoint site, with a modern list that has never been associated with classic SharePoint features. But today, two users have experienced intermittent instances of the list appearing in the classic interface. They have not accessed this site before now so I do not believe there should be a cache issue. Does anyone know why this is happening and how it's possible when this site has no association with Classic features? They are using the same browser, same permissions across the site but sometimes the list opens in Classic mode, sometimes it opens in Modern. It also is happening in incognito mode. They are unable to use the site while in Classic Interface at all - the people pickers deny them access ("Error: Sorry, you do not have permission to query for users" and they cannot edit anything because of this error.190Views0likes2CommentsSharePoint List button not working!
Hi all, I have a Property Key Check In/Out list and trying to include a button to auto populate the fields. Using the JSON below, but it isn't working. I've isolated the Status field and that works, but the Person and Date & Time keeps erroring. I checked and double-checked the column settings and the JSON is using the correct Internal names, and the columns are correctly set up to one person only and date and time, and not required. Copilot (you'll be surprised) is absolutely no help. I also tried replacing "null" with '' but still not working. Here's the JSON; { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "style": { "padding": "6px 12px", "border-radius": "6px", "border": "1px solid", "cursor": "pointer", "font-weight": 600, "background-color": "=if([$Status] == 'IN', '#107c10', '#d83b01')", "border-color": "=if([$Status] == 'IN', '#0b6a0b', '#be3700')", "color": "white" }, "attributes": { "title": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')", "aria-label": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')" }, "txtContent": "=if([$Status] == 'IN', 'Check Out', 'Check In')", "customRowAction": { "action": "setValue", "actionInput": { "Status": "=if([$Status] == 'IN', 'OUT', 'IN')", "CheckedOutByColleague": "=if([$Status] == 'IN', me, null)", "WhenCheckedOut": "=if([$Status] == 'IN', @now, null)" } } }Solved147Views1like3CommentsSharePoint List (Not Column) Validation Settings
I have an creating a list that keeps of the amount of hours taken by an employee. I have two columns in this list - Reason & Hours If the Reason column value is 'Paid - Vacation' or 'Unpaid Vacation', then the value of Hours must be greater than 1 and less than 11. I have gone to the List > Settings > Validation settings and tried a few different formulas: =IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE,FALSE),FALSE),TRUE) =IF(AND([Reason]="Paid - Vacation",[Reason]="Unpaid - Vacation"),IF([Hours]>0,IF([Hours]<11,TRUE)),TRUE) I don't get any errors when saving either formula. When I enter another record manually or using the form, the record is entered, but no validation is being made when the [Reason] = "Paid - Vacation" and [Hours] = 45 Can anyone assist with this?Solved82Views0likes1CommentIgnite Blog: Taking Forms to the Next Level with Teams and Power Automate
I hope you are all having a great time at Microsoft Ignite! My name is Chris Hoard, Partner Education Lead at Vuzion here in the UK. I am a Microsoft Certified Trainer Regional Lead (MCT RL) and Office Apps and Services MVP.13KViews5likes3CommentsMicrosoft 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" } }326Views0likes4CommentsUsing meta data from a MS form created in SharePoint in Email
Hi, I've created a Form within SharePoint and I want to add the results to 1) An Approval 2) To Body of Email This is the main part of the Flow and I'm using Compose actions The Names column is a People or Group type. Field = Names The Building Ward Access is a Choice type Field = Building_x002d_Ward_x0020_Access Both have 'Allow Multiple Selections' I'm try just to add the Name or Names and Building / Ward or plural into the body of the Approval and Email. I seem to be getting additional data including @odata I've been using Join expressions, if Statements and nothing seems to be working?? Can someone please assist???43Views0likes0CommentsSharePoint Quick Steps: The New Feature That Supercharges Lists & Libraries
🚀 New SharePoint Feature Alert! Microsoft has just released Quick Steps for SharePoint Lists and Document Libraries — a powerful new capability that helps streamline multi‑step actions into a single click. I just published a new YouTube video where I walk through: ✅ What Quick Steps are ✅ How to create them ✅ Real‑world scenarios to boost productivity ✅ Why this feature is a game‑changer for Microsoft 365 users If you work with SharePoint or manage content in Microsoft 365, this update is definitely worth exploring. 🎥 Watch the video here: https://youtu.be/EgJhN44GxBI #SharePoint #Microsoft365 #Productivity #Collaboration #Automation #SharePointOnline #Lists #DocumentLibrary #GiulianoDeLuca195Views1like0CommentsSharePoint view filtered to Me
Hello! Is it possible to create a view, or JSON format a view, when a field contains my information that is not a people picker field? I have a multiple line of text field where I enter a JSON object with user emails. Is there a way to change the view to only show the line item if that text field contains my email? I have tried using that field with Contains [Me] but that does not work. Presumably as [Me] is for people picker fields. Is there a way to add a filter to the view to look for my email?120Views0likes1Comment