New answers tagged list
1
Assign Contribute permissions to users.
Contribute permission level:
Enables users to manage personal views, edit items and user information, delete versions in existing lists and document libraries, and add, remove, and update personal Web Parts.
For more information about SharePoint permissions levels, check this: User permissions and permission levels ...
0
CreateDate should be a Date column, then should set with a date object in JavaScript, please modify as below:
<script type="text/javascript">
function CreateListItem() {
var context = SP.ClientContext.get_current();
var list = context.get_web().get_lists().getByTitle('CustomList');
var ...
0
This is the expected behavior in SharePoint online modern experience.
In order add the reference to the column in list inside the embed web part, you have to show that column in the list view. Hiding the column from list view will not work in this case (The same behavior also applies when using JSON column/view formatting in SharePoint).
Check more ...
3
Try using this:
"additionalRowClass": "=if([$Deleted] == 'Deleted', 'sp-field-strikeThrough sp-css-color-red', if([$Modified] < @now && [$Modified] >= @now - 86400000, 'ms-bgColor-gray50', if([$Modified] < @now && [$Modified] >= @now - 259200000, 'ms-bgColor-gray20' , '')))"
This will first check if [$Deleted] ...
1
From SharePoint modern experience list view, after making required changes:
Click on Switch view options dropdown at the top right corner.
Select Set current view as default.
Solution 2 - From classic view settings:
Click on Switch view options dropdown at the top right corner.
Select Edit current view.
Check Make this the default view checkbox
Click OK
...
0
You can add multiple classes in additionalRowClass property in above JSON as per your requirement.
For example, to change the color of rows with gray background to blue, you need to add ms-fontColor-blue class to the first condition, like:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
&...
1
Unfortunately, you cannot restrict the users from resizing the column width in list view.
Also, as per my observation, if someone changes the width of the column in list view, it will be changed for the particular user only. It will not affect the list view for other users.
View for User 1:
View for User 2:
0
Please the following steps:
1.Create a Calculated column named "Project Health" and use the below formula:
=IF(OR(Scope="RED",Time="RED",Resources="RED",Budget="RED"),"RED",IF(OR(Scope="YELLOW",Time="YELLOW",Resources="YELLOW",Budget="YELLOW"),"YELLOW&...
1
Do you mean custom list view?
I don't think it's possible to reuse a custom list view in all lists and sites.
0
Use this formula:
=IF(OR([Scope]="RED", [Time]="RED", [Resources]="RED", [Budget]="RED"), "RED", IF(OR([Scope]="YELLOW", [Time]="YELLOW", [Resources]="YELLOW", [Budget]="YELLOW"), "YELLOW", IF(OR([Scope]="GREEN", [Time]="GREEN", [Resources]=...
0
Solution 1:
You can change the order of column in list view by selecting the column header and then moving it to left/right.
Check below documentation for more information: Change the column order in a list or library
Note: After changing the order, Save view as from view selection dropdown (save with same name).
Solution 2:
Go to SharePoint list.
Click on ...
0
You can also create a list from another list( as long as you only need the metadata/column names and types. This solution will not copy the values existing in the list) :
New: list
Create a list: From existing list
Select a teams or site: Choose a list from Site. (this site). Here you select the list you wanted to copy.
Give new name. Create
I am ...
1
Use any of the below formula, it should work for you:
=LEFT([OriginalID], LEN([OriginalID])-3)
OR
=LEFT([OriginalID], INT(FIND("-", [OriginalID])-1))
Output:
Microsoft documentation:
LEFT function
LEN function
FIND function
1
It seems the formula shall be like =LEFT([OriginalID],LEN([OriginalID])-3)
The parentheses are not in the right position
1
To update SharePoint list item, you need to pass the item ID to REST endpoint like:
_spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('c')/items(1)"
Where 1 is ID of SharePoint list item.
References:
Working with lists and list items with REST
CRUD Operations On A SharePoint List Using REST API
0
The requirements described in your pseudo code can be accomplished using OR statement as shown below:
=IF(OR([column 1]="item 1",[column 1]="item 2",[column 1]="item 3"),"category 1",IF(OR([column 1]="item 4",[column 1]="item 5"),"category 2","category 3"))
0
If all you columns are single text column, then FIND() or SEARCH() shall be enough. It may not work for some circumstances. So Would you like to share us more information about these columns, what type are they?
If you are using SharePoint Online, I often suggest using Power Automate(Flow) to set the column value as it is more flexible and easy to set & ...
1
Try something like below:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now - 86400000, 'ms-bgColor-gray120', if([$Modified] < @now && [$Modified] >= @now - 259200000, 'sp-field-...
0
Here is a sample script for your reference:
#parameters
$SiteUrl = "<SiteUrl>"
$Username = "<Account>"
$Password = "<Password>"
$ImportCsv = "C:\Temp\Columns.csv"
$ListName = "<ListName>"
#Connect to PnPOnline
$cred = New-Object -TypeName System.Management.Automation.PSCredential -...
0
One more thing to mention about the script. Get-PnPList returns all the lists and libraries. If you want to return only document libraries, please use
$DocumentLibraries = Get-PnPList | Where-Object {$_.BaseTemplate -eq 101 -and $_.Hidden -eq $false}
0
@Graeme Johnson:
I’m going only with what you put in your question and comment.
With Microsoft Flow / Power Automate, you could create a ‘button flow’ that is triggered by a user on a page whereby you have both the button for the flow (and, optionally, maybe also a view of the actual list itself)
The flow would follow something approximating the logic below:
...
0
I've tested the below PnP PowerShell script:
Import-Module -Name SharePointPnPPowerShellOnline -Verbose
#Site Variable; replace with actual site url
$SiteURL = "https://mytenant.sharepoint.com/sites/testSite/"
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -UseWebLogin
#Another way to connect
#$cred= Get-Credential
#Connect-PnPOnline -...
0
You can create list columns in SharePoint online using PnP PowerShell.
It's hard to get the ready made script for all types of columns. However, if you understand the cmdlet, it is not difficult to create large number of columns in loop.
Related references/scripts:
Create And Remove List And Fields In SharePoint Site Using PnP Powershell
Add-PnPField: ...
0
I've seen very bad things happening when special characters are involved in a column name. Using < and % in a column name is a really bad idea.
But that's not the cause of your issue. You never mention the data type of the column [LVR<70%] but since you test against "YES" and "NO" I assume it's a Yes/No field.
While SharePoint ...
0
This is not possible using SharePoint out of the box capabilities as there is no configuration setting to hide the count of grouping.
Documentation: Use grouping to modify a SharePoint view
You will need custom solution for this using SharePoint framework.
One way to achieve this is using Application customizer SPFx extension to inject custom CSS in your ...
0
You can implement your design through MS Flow and JSON.
Please the following steps:
Step1.Create a Choice column named "Status" in your list
Step2.Create a MS Flow for your list
a) Add a Trigger "When an item is created or modified"
b) Add an Action "Get item"
c) Add an Action "Send an email (V2)"
d) Add a Control &...
0
Just a reminder ahead, the task would be a bit complicated for a new user to SharePoint.
Different options are available based on the version of SharePoint you are using:
For SharePoint Server, you can customize the list form using InfoPath. Apply rule to the Text column control so that it returns the demanded texts when condition is met.
References: ...
0
This seems to be a many-to-many relationship and you need three lists:
Customers
Assets
AssetReservation
AssetReservation will have two lookup columns, one pointing to Customers and the other to Assets. It will have [Booking] or [Reservation] date plus any other columns as needed by the business requirements.
Customers list (simplified): LastName and ...
0
I do not believe that is correct. We are on SP Online and still have the option to customize forms using InfoPath but it no longer works when we try to publish in new lists. Existing lists that have previously been customized do still work. I think MS broke something.
0
It is not feasible to create a lookup column to get information from subsite using out of box feature in SharePoint Online.
0
$web is null here. we need modification.
$site = Get-SPSite http://site
$listTemplates = $site.GetCustomListTemplates($site.RootWeb)
$Web=Get-SPWeb http://weburl #(DestinationWeb)
$web.Lists.Add("Your new list", "", $listTemplates["ListTemplateName"])
$web.update()
$web.Dispose()
0
The most straightforward way will be using the list view configuration. Go list settings>view, click on the view you want to edit.
I assume the work prds column to be a number column, then you can simply use the group by function to filter your list into groups based on Employee. Then use the total function to calculate the sum of a number column.
A test ...
1
This the expected behavior since InfoPath doesn't supported customize forms in Event List or Library.
As you said, PowerApps is only available for modern experience lists, not classic lists.
Currently, we could customize the new and edit form of calendar in SharePoint designer.
Refer to following article:
https://social.technet.microsoft.com/wiki/contents/...
0
Please following steps:
Add a Trigger "When an item is created or modified"
Add an Action "Initialize variable"
Add an Action "Append to an array variable"
Add an Action "Updated item"
0
Those statistics are only kept for 90 days by default. You can update the value with PowerShell.
https://social.technet.microsoft.com/Forums/office/en-US/1cd8d0e1-82f7-4472-be77-de02ded1ebf0/sharepoint-2013-audit-log-and-max-period-for-retention?forum=sharepointgeneral
0
So it is not the CSS that is the issue, change the SharePoint list web app from <Current View> to <Summary View>
0
In order to update a user field, you have to supply an object with the user claims
{
"claims": "userclaims"
}
In order to do the same for a multiselect field, you have to supply the object in an array
[
{
"claims": "user1claims"
},
{
"claims": "user2claims"
}
]
If you are only ...
0
You could create a lookup column in the quality department list to show data in the production department list.
1.Production department list.
2.Quality department list
3.Lookup column.
4.Result.
0
That is not a silly question. It's actually a good idea not to duplicate data if it's being used as a lookup for more than one department. What version of SharePoint are you using? Is this data on the same farm? Same site / site collection or different? The answer would depend on where the source and target sites are... Even if they are on different farms, ...
0
Microsoft list only with a title column by default, in order to allow users to customize the list to the maximum extent.
1
Microsoft recommend the following for managing large lists and libraries:
Index columns
Index the column that you wish to use to filter the view.
Use the modern experience
The modern list view lazy loads data as you scroll down. This may not be helpful for filtered views but provides a better experience in large lists.
More information:
Manage large lists ...
1
This is simply how Microsoft Lists works. If you believe it should be harnessing Site Content Types when creating new lists, then you can raise this on the user voice for SharePoint or Microsoft 365:
SharePoint UserVoice
Office 365 UserVoice
0
If there is - in the middle of [Column2], you can use below formula:
=IF([Column1]="Sweden",IF(ISERR(SEARCH("-",[Column2],1)),[Column2],REPLACE([Column2],SEARCH("-",[Column2],1),1,"")),[Column3])
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional ...
0
Yes, you are right. Everyone who will be viewing the data in a Power Apps that is linked to a SharePoint list will need at least View Only permission on the list itself.
You can grant the users with unique permission on the list only, or adjust their permissions in this site if you do not want them to have access to other locations.
0
Please go list settings>Permission for this list, have a check if list has unique permission and the contribute user group has proper permission(at least read) in these lists/libraries
If you have a button saying "delete unique permission" on the left top, it means there are unique permission in that list, use the check permission function to ...
Top 50 recent answers are included
