Questions tagged [microsoft-lists]
The microsoft-lists tag has no usage guidance.
53 questions
0
votes
0
answers
2
views
SharePoint modern view, JSON, Change the height of gallery cards dynamically
We would like to adjust the height of each card dynamically to the content of each card (see screenshot below). I already tried with "height": "auto", but the cards overlaps after ...
0
votes
1
answer
20
views
MS Lists Validation Setting - how to create a formula
I am using =[FAY Date<=[Clearance Date] and is working but I do not know how to include [FAY Date<=[Contract End].
How do I combine both into one formula to use in MS List Validation Setting. ...
0
votes
1
answer
25
views
Calculating a Due Date based of criteria and returning a due date, excluding weekends
I have three columns on my SharePoint list:
Request Type
Date Received
Due Date
There are SLAs surrounding the request type which drive when the item is due.
For ease of simplicity:
Request Type (...
- 1
2
votes
1
answer
46
views
How to hide purple outline for users currently viewing a list?
It looks like List views have been updated by Microsoft and now when a user is currently viewing an item, a purple outline appears with the user's name telling the whole world that they're looking at ...
- 161
1
vote
1
answer
197
views
SPFx CommandBar buttons and Context Menu are not working with Microsoft List look and feel in SharePoint Online site
We have SPFx commandBar buttons and context menu deployed in the SharePoint Online site developed using SPFx solution. We have deployed them in site under site app catalog and CDN is also implemented. ...
- 7,247
0
votes
1
answer
18
views
Calculated column in MS Lists not ordering correctly?
I am trying to get a MS Lists calculated column to order numbers correctly (which subsequently is an issue in the PowerBI report that I pull using DirectQuery).
The column is to track Risk Weighting (...
- 3
0
votes
1
answer
141
views
Thumbnail/Image column broke after disabling attachments
I am currently experiencing an issue with a SharePoint list that contains a thumbnail column. After disabling the attachments for this list, I found that I could no longer access the images in the ...
- 3
0
votes
1
answer
145
views
How would I calculate the days remaining from a date column
I have created a Microsoft List and I have a date expiry column and a days remaining column. I want a simple calculation to show the days remaining from the expiry, if its already expired, I just want ...
- 3
0
votes
1
answer
46
views
Calculated column in MS Lists not returning any output?
I'm trying to populate a simple Calculated Column in MS Lists to provide a Risk Assessment outcome.
I've tried this in Excel and it works fine, but whenever I save the Calculated Column in Lists / ...
- 3
1
vote
1
answer
36
views
SharePoint / Teams Date Column Restriction using Validation Syntax Question
I have two date columns in a SharePoint List. I am trying to figure out the proper syntax for use in the Validation box.
For the first, I want to restrict the date entered to only accept today's date ...
- 11
0
votes
1
answer
19
views
How would I change the colour of the background of a cell based on the set days past
I've had a look at implementing the following:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "...
- 3
0
votes
1
answer
19
views
Microsoft List text string validation
I'm whipping up a List and am hoping to use a number field to force any user to only input two single digit numbers, a decimal, then two single digits - eg "12.34". I feel like its a dumb ...
- 1
0
votes
0
answers
117
views
Paste error in grid view when copying value into a SharePoint list lookup column
I have a question regarding lookup columns on microsoft lists. I used to be able to copy and paste information into the lookup column as long as the written value matched the registered options in the ...
- 1
1
vote
1
answer
292
views
Calculated column based on another column
I'm trying to create a calculated column based on a status column. The status column is a multi choice column (but I can change in a text column).
For example: if the status is "xxxx", I'd ...
1
vote
1
answer
165
views
List Column Validation dependant on another column
I am using a Microsoft List for employees to request their leave (annual / sick leave).
I have a column called 'Leave Start Date' where they enter the start date of their leave. It currently has a ...
- 11
0
votes
0
answers
125
views
SharePoint list gallery view preview link
I've been having some trouble with SharePoint list's gallery view for a while now.
I create items from a power automate flow that gets an image link from OneDrive. Now, the image loads fine on ...
- 1
0
votes
0
answers
47
views
I need to show the results of a calculated field on the NEW ITEM Sharepoint list form...thoughts?
So, I have a calculated field that is calculated based on how other columns are populate on the NEW ITEM SharePoint list form.
I am new but I understand that calculated field will not show on the form....
0
votes
1
answer
122
views
How do I create a "Card" column type in a Microsoft List?
I really can use your help on this. I have decided as part of my efforts to solve a different problem to make a copy of a Microsoft List to a work platform that is not shared as a dashboard and ...
- 101
0
votes
1
answer
190
views
How do I make the ID column un-editable (again) in a Microsoft List?
Microsoft List is the evolved version of SharePoint List. I am working with Microsoft List before ever touching SharePoint List. So I do not know what features are carried over from the SharePoint ...
- 101
0
votes
0
answers
22
views
Display list views in a web part list
on a modern sharepoint page, i need to display differents views of my list. My list is customized in json with "hideselection:true"
For every view of my list, i created a web part list and ...
- 13
0
votes
0
answers
34
views
Calcuate a Due Date based on 3 Business Days
I would just need to calculate a Due Date column based on 3 business days from an Activity Date for a SharePoint List column.
For instance I could do =[Activity Date]+3, but this formula would not be ...
1
vote
2
answers
2k
views
Is Microsoft List and SharePoint lists the same thing
I always create SharePoint sites and add SharePoint list. inside the SharePoint lists i add custom content types , create power apps and power automate to automate the lists.
now today i came across ...
0
votes
1
answer
491
views
Align tiles horizontally in sharepoint list in a view formatting
the tiles of this json display vertically, one under the other, i can't figure how to display them horizontally, one on the right of the other. Is it related to "flex-direction" ? Thxs`
{
&...
- 13
0
votes
0
answers
571
views
Why I am getting "Cannot load a resource from a ResourceScope that has been disposed" error while editing an item in SharePoint list?
I tried to edit an item in SharePoint list from information panel and it gave me below error
Any idea why this error is generated?
Note : My site has enough available storage and all stage recycle ...
- 8,489
1
vote
1
answer
117
views
Icon Progress Bar JSON formatting not displaying in my view
I've tried inserting this nice JSON Icon Progress Bar in my list view (thanks to this so useful page) but it does not display.
As I am in a view formatting, I have changed the fields @currentField by $...
- 13
2
votes
1
answer
402
views
Make One column in Microsoft List editable for all employees all other will be read only
I have created a Asset Management List in Microsoft List with multiple columns.
I want the users to give only edit access to one column while all other will be in read only mode.
How can it be ...
- 21
0
votes
1
answer
109
views
MIcrosoft List Conditional Formatting - JSON
I'll start by saying that I do not know JSON!
I have a Microsoft List that tracks contracts. I am trying to shade the cells in this column based on date criteria and how far away from the current ...
- 1
1
vote
1
answer
3k
views
Microsoft Lists UI in SharePoint List UI instead of modern SPO UI
From a few days, some list from sites have interface like Microsoft Lists instead of the modern SharePoint view interface.
The view/ui/ux/interface isn't a big deal, but I lost all navigation in my ...
1
vote
1
answer
916
views
Date formula in calculated column - valid
I have a Microsoft list with two relevant columns 'ACTION Status' and 'Due Date'. I am looking for 'ACTION Status' to return Text values based on the 'Due Date' column values. I an using the following ...
- 11
1
vote
1
answer
24
views
I need to calculate a Date only when there are Term days
I need to Calculate a Term Deadline based on the expiration date BUT only when there are Term Days.
My current formula for "Term Deadline:
=[Expiration Date]-[Term Days]
The problem is that the ...
- 13
0
votes
1
answer
724
views
Hide "Show Header and Navigation" Arrows & Other Upper Right Icons
In a Modern List View, I am looking for a way to hide some or all, via JSON, of the upper right corner icons for "All Items" view selector, "Open the Filters Pane", "Open the ...
- 157
0
votes
1
answer
158
views
Change the status of a item in a List if thay already is in the list
I have a list in sharepoint that we fill in the exceptions for a specific case. So in that list I have the status "Under review", "Approved", "Rejected".
To change this ...
1
vote
2
answers
953
views
SharePoint List Conditional Formatting Within a Range of Another Column
I have a list where I'm recording the scores of three reviewers. Each score needs to be within 10 of both of the other two scores. I'd like scores that are outside of that range (too far from one ...
- 13
0
votes
0
answers
32
views
Setting input value in modern experience with javascript
I'm trying to automate the adding of a list entry in sharepoint online lists with modern UI and plain JS.
Setting the value works fine using:
// Stolen from StackOverflow ;)
const inputTypes = [
...
1
vote
1
answer
122
views
How can I count of duplicated data in Microsoft List
I have the below data in Microsoft List, I need count of repeated IDs.
Emp ID SERIAL_NO MAKE Emp Id repeated Count
Emp1 FVFH36FZQ05N APPLE MAC
Emp2 PW039DX5 LENOVO
Emp2 ...
- 11
0
votes
1
answer
364
views
Email notification when someone add a new member to a task in a Microsoft List
I'm a beginner in Power Automate and I need someone support in the following topic?
I found this online, it's kind of similar with my topic but I don't know what to adjust
https://www.office365notes....
1
vote
1
answer
507
views
Creating a calculated field to show 'Red' 'Amber' or 'Green' based on a due date column
I am trying to create a calculated column to return "Red" "Amber" or "Green" based on a due date.
I have a date column called "Due Date" and I am trying to add ...
- 11
1
vote
1
answer
691
views
Calculated column with IF condition
I'm writing from Italy. I have a list of 5 columns: one of them is called "available" and it's a yes/no column.
Another column is a text column called "last name". I want to create ...
- 13
2
votes
1
answer
1k
views
Functional rating in custom grid view using JSON formatting
In SharePoint Lists you can add a fully functional rating column. With "functional" I mean that you can both see the ratings (value and stars) of every list item and you can click on a star ...
1
vote
2
answers
26
views
Calculated Column IF MsLists
I'm trying to move one of our old spreadsheets onto MS Lists. There is a formula in there which is:
=IF(AND(E2=0),"0",IF(AND(E2>=6.5,E2<=8),1,2))
I've tried a few variations through ...
- 11
0
votes
1
answer
2k
views
When an item is created in a list, get link to item (in WebViewList mode)
Using the SharePoint connector action:
When an item is created
It is possible to get a dynamic value named:
Link to item
You can then, for example, use this link in a notification email.
By default, ...
- 244
2
votes
2
answers
990
views
View/edit rows in SharePoint List that only relevant to the specific team
I'm trying to create a SharePoint List in my organization. The list is created centrally, which allows different teams to view and edit the rows that only relevant to them.
There is a column which ...
0
votes
1
answer
6k
views
What format do Microsoft Lists require date/time column values to be in when adding them from Power Automate?
I want to add the current date/time to a date/time column.
What format do Microsoft Lists require date/time column values to be in when adding them from Power Automate?
I am using the Convert time ...
- 244
0
votes
1
answer
414
views
When executing a flow from a button in a list column, how do you hide the button when more than one item is selected?
I have a flow whose trigger is the SharePoint trigger named:
For a selected file
The default behavior of this trigger is that when a file is selected, the flow is available under the Automate menu.
By ...
- 244
0
votes
1
answer
1k
views
Dynamic URL generated by JSON column formatting breaks on ampersand character
I am using JSON column formatting to generate a dynamic URL based on the value in another column.
The dynamic URL is a link to a document library which is filtered by the value in the other column.
{
...
- 244
0
votes
0
answers
42
views
How to ensure the same column width on the search results page in a Microsoft List?
The URL of my list is in this format:
https://tenant-name.sharepoint.com/sites/site-name/Lists/list-name/AllItems.aspx?env=WebViewList
Using the ?env=WebViewList suffix on the URL enforces the modern ...
- 244
0
votes
1
answer
174
views
Partial Word Search in Lists
We are currently working on moving our internal website to SharePoint. In our current website, we have a searchable phone list. The user can start typing the name (partial word search), click Search, ...
0
votes
2
answers
4k
views
SharePoint List Order - drag and drop?
Is there an easy way to order list items in SharePoint Online? I just would like to, for example, swap two rows.
Is there an easy way to do this/drag and drop maybe?
Is ordering strictly done by ...
- 115
0
votes
1
answer
758
views
Possible bug in Microsoft List Form formatting interface - field order is not respected
This question is in regards to List Form formatting:
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration
The order of the fields specified in the JSON I ...
- 244
1
vote
1
answer
7k
views
How to add subtasks in Microsoft lists/SharePoint
I am new to SharePoint and I am trying to create a comprehensive task management platform using SharePoint but I am unable to add subtasks and most of the resources that I have seen online say that I ...
- 11