Questions tagged [microsoft-lists]
The microsoft-lists tag has no usage guidance.
30
questions
0
votes
0
answers
5
views
Create historical data in Microsoftlist
I have created a microsoftlist that shows risk management. Risk level shows probablity (P) times consequence (C). So riskvalue in tertiary 1 is 12. When we are in tertiary 2 the riskvalue will maybe ...
- 1
0
votes
1
answer
424
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 ...
0
votes
0
answers
43
views
MS Lists Calculated Date Column Using Business Days
I'm trying to create calculated date columns in MS Lists that populates an end date by subtracting a # of business days from a start date. The start date can fall on any day of the work week (Mon -Fri)...
1
vote
1
answer
72
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
22
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
247
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 ...
- 103
0
votes
0
answers
6
views
Retrieving multiple data in to another list
I have a SharePoint list "Register" that has a field "Asset"(title) and "Type"(choice). The title is unique and the type will be multiples of the same.
Asset
Type
1212
...
- 11
0
votes
1
answer
51
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 ...
0
votes
0
answers
31
views
Getting Lookup Column Data from SharePoint list to another SharePoint list
I want Sharepoint List A columns (A,B,C) to look up to Sharepoint lists (1,2,3). The columns from List A should pull the data from Sharepoint lists 1,2,3. Rather than manually adding each lookup ...
- 1
1
vote
2
answers
344
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
16
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
28
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
123
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
234
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
283
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
1
vote
1
answer
601
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
23
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
760
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, ...
- 214
2
votes
2
answers
555
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
3k
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 ...
- 214
0
votes
1
answer
324
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 ...
- 214
0
votes
1
answer
731
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.
{
...
- 214
0
votes
0
answers
29
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 ...
- 214
0
votes
1
answer
72
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
2k
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
399
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 ...
- 214
1
vote
1
answer
5k
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
0
votes
1
answer
645
views
How to make column values that are the result of JSON column formatting available in list export and filtering?
I have created two columns of type Single line of text.
They reference a Person column via the following JSON column formatting:
Department
{
"$schema": "https://developer.microsoft....
- 214
0
votes
1
answer
1k
views
List - Change Column value on Button Click
In old versions of SharePoint (classic lists, SP 2013, SP 2016) it was possible to create a button via calculated column that changes the value of a column in this item instantly (example at the end ...
- 1,107
0
votes
1
answer
8k
views
How to set a view of a Microsoft List as the default view
Before SharePoint List became Microsoft list I could set a certain view as the default view.
I have 3 views called: "Rooster", "Overview" and "Vandaag". How can
I set the ...
- 219