Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [microsoft-lists]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 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 ...
LunaRian's user avatar
0 votes
0 answers
21 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....
Jason L. Shaw's user avatar
0 votes
1 answer
38 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 ...
xarzu's user avatar
  • 101
0 votes
1 answer
62 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 ...
xarzu's user avatar
  • 101
0 votes
0 answers
16 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 ...
Hervé 's user avatar
0 votes
0 answers
24 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 ...
Mandi Oliver's user avatar
1 vote
2 answers
494 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 ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
115 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` { &...
Hervé 's user avatar
0 votes
0 answers
391 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 ...
Aakash Maurya's user avatar
1 vote
1 answer
77 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 $...
Hervé 's user avatar
2 votes
1 answer
137 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 ...
Abhijeet Dey's user avatar
0 votes
1 answer
45 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 ...
Cliff's user avatar
  • 1
0 votes
0 answers
6 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 ...
Alma's user avatar
  • 1
0 votes
1 answer
2k 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 ...
Karol Kozłowski's user avatar
0 votes
0 answers
136 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)...
Brian Booth's user avatar
1 vote
1 answer
297 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 ...
Chris_C's user avatar
  • 11
1 vote
1 answer
23 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 ...
shoz rocks's user avatar
0 votes
1 answer
485 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 ...
ChasEpes's user avatar
  • 109
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 ...
Sandra P's user avatar
0 votes
1 answer
93 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 ...
Gustavo Bento's user avatar
1 vote
2 answers
641 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 ...
Amanda W's user avatar
0 votes
0 answers
27 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 = [ ...
MsListsAutomator's user avatar
1 vote
1 answer
71 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 ...
user107568's user avatar
0 votes
1 answer
170 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....
user107467's user avatar
1 vote
1 answer
390 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 ...
aoife's user avatar
  • 11
1 vote
1 answer
508 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 ...
fabio's user avatar
  • 13
2 votes
1 answer
870 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 ...
dgarciagarcia's user avatar
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 ...
user105711's user avatar
0 votes
1 answer
1k 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, ...
user1063287's user avatar
2 votes
2 answers
772 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 ...
civilized_caveman_sg's user avatar
0 votes
1 answer
4k 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 ...
user1063287's user avatar
0 votes
1 answer
364 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 ...
user1063287's user avatar
0 votes
1 answer
958 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. { ...
user1063287's user avatar
0 votes
0 answers
31 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 ...
user1063287's user avatar
0 votes
1 answer
118 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, ...
user3033348's user avatar
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 ...
headlikearock's user avatar
0 votes
1 answer
549 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 ...
user1063287's user avatar
1 vote
1 answer
6k 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 ...
Shaukat's user avatar
  • 11
0 votes
1 answer
817 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....
user1063287's user avatar
0 votes
1 answer
2k 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 ...
PhilFancy's user avatar
  • 1,107
0 votes
1 answer
10k 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 ...
user2170776's user avatar