Microsoft Lists
1553 TopicsAdding an 'Events List' as a List Webpart
Possible at all/is there a workaround? I am trying to put an Events List and a List on one page. The idea is to let users view/add to both on one page. The problem: when adding a list webpart, the events list I need doesn't appear as an option. I searched the forums and did not find a clear solution. Is this possible at all? If I run an automate flow to push entries and changes back and forth to a duplicate list and an events list that would be recursive. Currently have a 'Webpart Tabs' webpart with a placeholder standard list on the top: Titled 'Events List A'. I want to put the actual events list in its place. Happy holidays and thanks!26Views0likes1CommentConditional Formatting using JSON
I have this code which is working great, however, every time I make a change to add in that if it is blank it should be light coral as well - here is the original - { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) == 0, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 10, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) >= 11 && (Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 20, 'LightYellow', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) > 20, 'LightCoral', '')))", "color": "black", "padding": "5px", "border-radius": "5px" } } Here is the new attempt at adding in a null value is also Light Coral. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(isBlank([$Emp_x0020_Returns_x0020_OF306]) || isBlank([$LP_x0020_Sends_x0020_OF306]), 'LightCoral', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 10, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) >= 11 && (Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 20, 'LightYellow', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) > 20 || isBlank([$Emp_x0020_Returns_x0020_OF306]) || isBlank([$LP_x0020_Sends_x0020_OF306]), 'LightCoral', '')))))", "color": "black", "padding": "5px", "border-radius": "5px" } } It just makes everything transparent. Any help would be highly appreciated! Too bad this isn't built in functionality.15Views0likes0CommentsCollect information like a pro – New Microsoft Lists forms experience
The new forms experience in Microsoft Listsis now rolling out for Microsoft 365 work and school. Our goal is to make it easier to collect and gather information directly into your lists – saving you time and effort. Thus, we are excited to launch a new forms experience built right inside Microsoft Lists – rolling out now. Note: This relates to Microsoft 365 roadmap ID: 124865.113KViews23likes144CommentsMicrosoft Lists format Section of related Columns as same color
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display sections for the fields. which looks great when entering as a form. In the web app, for the end user to make it easier to fill out, for each Section I would like to display the same color for the related columns. And for the next section of related columns apply a different colour etc Note some columns have Conditional formatting rules applied eg see screenshot of example done in Excel of Section column layout to achieve How can this be achieved. TIA21Views0likes1CommentNo longer able to move records between lists to archive
We have a very large comples bookings list in sharepoint. Twice a year we have to archive "completed" records so as not to exceed the 5000 threshold. We have always done this in Site Settings > Site Content and Structure. But, there is no longer a "move" option in the actions tab, only copy and delete. We tried copying the records across, but are unable to copy even one record (just get the green spooling wheel). We are unable to move records using PowerAutomate as we far exceed the look-up threshold for PA. Any ideas why we can suddenly no longer "move"...? Many thanks8Views0likes0CommentsStatus Change tracker
#Sharepoint Hello, I have a list with a column " Status" . We have "open" " rejected" " sent to vendor" " closed" Can we track the status changes in Sharepoint and measure how long it takes for each case from the " open " to the "closed " status? We would like to measure performances if this is possible. Best Regards GD.36Views0likes2CommentsMicrosoft Lists form How to color different Sections to make it easy to fill out
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display different sections (areas) for the fields. which looks great when entering as a form. Is there a way to apply color to the different sections to distinguish the different sections to make it easier for the end user to enter. eg see screenshot example layout of Patients template form different sections in different colors How can this be achieved? TIA29Views0likes1CommentIs it possible to restrict what values a user sees in a lookup column in a Document Library
Hi Guys, Need inputs on a particular requirement that I am struggling with in SharePoint Online Document Library. Here is a Document library, where I have a column named "document department". This is a lookup column to a separate list called "Department" The list "Departments" is below. It has various departments (like Finance, Human Resources, Project Delivery etc). It has department name, department shortcode, etc. REQUIREMENT : --------------------- The requirement is that when a document is uploaded to the document library, the users would select the department from the list of departments. At present, if the user belongs to HR department, they can still see and select other departments in this column. This should NOT be the case. The user should only see the department in that dropdown list, which the user belongs to (Example, HR user should only see the HR in the dropdown, and other options should either be grayed out or not visible). How do I achieve this?63Views0likes1CommentJSON Conditioning with multiple IF statements
Hello I am trying to format a date column. The date in the column is a date that someone completed a certification and that certification expires after one year. I am trying to using conditional formatting comparing the date in the column against the current date to show if the certification is still valid, getting close to expiring, or expired. I can't seem to get it to work. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "attributes": { "class": "=if((@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'sp-field-severity--good', if((@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'sp-field-severity--warning', if(@currentField >= @now – 2591999999, 'sp-field-severity--severeWarning', 'sp-field-severity--blocked'))) + ' ms-fontColor-neutralSecondary'" }, "children": [ { "elmType": "span", "style": { "display": "inline-block", "padding": "0 4px" }, "attributes": { "iconName": "=if(@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'CheckMark', if(@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'Error', if(@currentField >= @now – 2591999999, 'Warning', 'ErrorBadge')))" } }, { "elmType": "span", "txtContent": "@currentField" } ] }4Views0likes0Comments