Questions tagged [updatelistitems]
A method of the Lists class that adds, deletes, or updates the specified items in a list on the current site.
234 questions
0
votes
0
answers
44
views
use a lookup column result to populate a text column in the same sharepoint 365 list
I have a Sharepoint List (Office 365) with a couple of Lookup Columns. I need the data from one of these columns to populate a new column as text so I can use it in a formula. Is this possible?
For ...
0
votes
0
answers
16
views
Assistance Needed: Extracting Full Modification History from List Items
I need to download the entire history of modifications for the items on my list to identify when the status changed and to obtain those dates for new columns in a table.
I am using this code found by ...
0
votes
0
answers
109
views
how to update SharePoint library file meta data in Power Apps
I have a Document library named "Project Details" with different files and folders with different columns. I have also added some files inside folders, like the one below.
Now, I would like ...
- 21
0
votes
1
answer
138
views
Update lookup column via CSV. Powershell Erro
Using SharePoint 2016
I am trying to update lookup column in a document library via CSV using below PowerShell:
it only updating few and giving below error on rest of the items. The CSV and Doc ...
- 1,214
0
votes
1
answer
335
views
How to add 1 (increment) to the current value of a SharePoint list number field using the rest API
I am implementing a custom solution on SharePoint Online and want to add 1 (increment) to the current value of a specific field number (TotalViews) using rest API.
function UpdateViewsinHow(param)
{
...
- 3
2
votes
1
answer
458
views
Interim Update button on SharePoint List customized PowerApps Form Without Closing Form
I would like to apply some type of interim update without closing a SharePoint form customized in PowerApps. I currently have SubmitForm(MainForm) on the MainForm. The form has several lookup columns ...
- 41
0
votes
1
answer
245
views
Batch Update for 16K Items failing
We are trying to copy contents from one column to the other , However we get request digest error after 6K Items.
Below is the code
$(document).ready(function () {
$("#btnSubmit").click(...
- 37
0
votes
2
answers
4k
views
Power Automate filter by 'Modified' date and update returned items
I have what I thought was going to be a simple scenario to solve:
Multiple SharePoint Lists, each with 40 000+ items in it
Running queries based on different columns and export to Excel to provide MI
...
0
votes
1
answer
3k
views
Getting Error while updating multi user filed using power automate
I am trying to update the list item using power automate "Update Item" action. The list item has a multiuser mandatory field and I am setting below claims array to the field after clicking &...
- 497
0
votes
2
answers
447
views
Guide on how to use the "Update List Item Action" for a SharePoint 2010 Workflow in SPD
This is my first time asking a question on here, so please bare with me on this.
I am creating a tool to collect averages based on a 1 to 5 scale over 4 different lists, and then collaborate those ...
0
votes
1
answer
98
views
SharePoint 2013 SPServices UpdateListItems 403 FORBIDDEN
I have been using the SPServices UpdateListItems code below for several years on an on-premise SharePoint 2013 Enterprise server without any issue. However, we recently migrated to a new cloud-based ...
- 190
0
votes
2
answers
6k
views
Capture static date & time when list item "status" column changed to "6-Completed"
Using a Sharepoint List to capture issues and tasks and need to be able to determine how long each item has spent in a specific "status".
"Status" column has choices as below;
1-...
- 1
0
votes
0
answers
192
views
Update all items in SharePoint list daily with SPD 2013 workflow
There may be several solutions to this (common) problem, but I do not seem to find one that works, or they are too complicated.
I have a list with a calculated column "Status" that returns a ...
- 1
0
votes
1
answer
2k
views
Create and Update Patch Formula for Power Apps
How to update using patch in SharePoint list from edit form?
Using below patch function. but, its creating new record every time.
When I select an item from the gallery and edit it, creates a new item ...
- 57
0
votes
1
answer
350
views
calculated column missing in designer workflow dropdown
I have a calculated column in a list and I want to update that column value from SharePoint designer workflow but when I am trying to update the field in workflow, calculated column is not showing up ...
- 451
0
votes
2
answers
3k
views
Microsoft flow to trigger email when condition is met
I am working on a microsoft flow where it is supposed to trigger email when the fields of a sharepoint list item -
If 'Mail to be sent to Maths' is 'Yes' and 'IsmailsentMaths' is 'No' then trigger ...
- 79
0
votes
0
answers
273
views
SystemUpdate() inside my remote event receive will raise "Access denied. You do not have permission to perform this action or access this resource."
I have the following code inside my remote event receiver (which run on item added):-
using (ClientContext context = TokenHelper.CreateRemoteEventReceiverClientContext(properties))
{
...
1
vote
2
answers
2k
views
SharePoint Online - Possible to update ID column value in a list for an existing item?
In SharePoint Online, Is there a way to update the ID column(for an existing item) in a list with our value?
We have a SharePoint list where I want to update the ID column value with my own value. I ...
- 1,522
0
votes
3
answers
376
views
SPListItem field resets to null after calling Update
I use SharePoint 2013 with the following code:
SPListItem listItem;
...
listItem["MyCol"] = " "; // Space character.
Console.WriteLine($"listItem[\"MyCol\"] = {listItem["MyCol"]}"); // Here i see ...
0
votes
1
answer
1k
views
Update People picker value using javascript
My function is :
function UpdatePerform() {
var clientContext = new SP.ClientContext(_spPageContextInfo.webAbsoluteUrl);
var oList = clientContext.get_web().get_lists().getByTitle(...
- 513
0
votes
1
answer
559
views
Updating List item from Event Receiver of another List
According to my requirement, I've 2 Lists within the same site List A and List B.
Below are the columns in List A:
User [PeoplePicker], City [dropdown (2 choices)], Company [dropdown (5 choices)], ...
1
vote
1
answer
6k
views
how to udpate using patch powerapps
How to update using patch in SharePoint list from edit form?
Using below patch function. but, its creating new record every time.
Patch(test, Defaults('test'),
{
ReasonforLateSubmission: ...
- 149
0
votes
2
answers
368
views
migrate Access database to Sharepoint and preserve ID column
I would like to migrate access databases to SharePoint Online, and sometimes the built-in migration wizard fails. I can create the missing tables and relink them with a macro, but I have trouble ...
- 916
1
vote
1
answer
40
views
ListItem.Update() triggers validation of all properties
I need to do a scheduled or manually trigger update on some hidden properties of files and folders.
The items all have different content types with different properties, but the hidden properties are ...
- 11
0
votes
1
answer
360
views
Send an email to multiple contacts, asking to confirm information that we have on SharePoint list
I am trying to send an automated custom email (via Flow or directly via SharePoint; no SharePoint Designer, PowerApps, or anything of the like). We can only use SharePoint Online. These emails would ...
1
vote
1
answer
649
views
Make column look at Active Directory and auto populate - SharePoint Designer 2013
I'm using SharePoint Designer 2013 and I have a list that I created from an excel spreadsheet that have several columns and rows. One Column is labeled as "Assigned To", it may have some data ...
- 115
0
votes
1
answer
1k
views
Powershell script to update list column from another column Conditional
Any help is greatly appreciated. Here is the scenario:
I have a powershell script which I am using from another post on stackexchange.
I have two fields in a list, the script copies the value from ...
- 3
4
votes
1
answer
3k
views
Pass file name having space to update operation using REST API
I am using on premise SharePoint server 2016.I am using rest api to update a list.I have a list having space in it's name so while passing this name it causes problem.Is it possible to pass file name ...
- 77
1
vote
2
answers
156
views
Update 1st row always of sharepoint list
I am using REST API to update in custom list of SharePoint Server. It is a dashboard and displays result as per logged in user. Is it possible to update 1st row always using REST API irrespective of ...
- 77
1
vote
1
answer
3k
views
Update SharePoint list via C#
I'm trying to update a SharePoint list via C#
So first I check if my item already exists, if it is, I add his id in my lUpdate variable.
So my code works, it goes in the loop (for the update and the ...
- 47
2
votes
2
answers
501
views
Column validation for past dates
Looking at implementing column or list validation for a date field to stop them from entering past dates
The validation should do the following
Validate only there is a value in the column
Validate ...
- 153
0
votes
1
answer
791
views
403: Forbidden when trying to update item properties with SharePoint API
In my .NET Core API I'm trying to update a document library item property with the SharePoint API. I already succeeded to get the document library item by id and by filter. When I try to update an ...
- 101
0
votes
2
answers
132
views
Run a SP D workflow each day - with step by step
I want a SP D workflow to run each day, that will update a SPO List.
Is there any articles that gives the step by step process to achieve this? I found many posts but stuck at somewhere
environment: ...
- 3,500
0
votes
1
answer
1k
views
SharePoint Rest API Patch request to update list item not working
I have an application build up in SharePoint 2013. In one of the custom list form, we are trying to update list item using Rest API call with type Patch.
Few users are getting a response {"...
- 1,473
1
vote
1
answer
518
views
Button, updating a list item at the Display Page
I am trying to create a button on the Display Page where it will update a value (Open, Close, Cancel), either redirecting them back to the Display Page or just taking them back to the List Page.
They ...
- 317
0
votes
1
answer
57
views
Sharepoint 2010 - refresh list job
I need to refresh all my lists in server daily.
To refresh one list I use this powershell:
$web = Get-SPWeb http://Server/ListLocation
$list = $web.Lists["ListA"]
foreach ($item in $list.Items)
{
...
0
votes
2
answers
50
views
Error from workflow to update a list when value in another list changes
I created a workflow to update a list (Rooms) when another list (People) is changed. I want to assign a value in the Room column in People list and have the value in column LastName be added to the ...
- 101
1
vote
1
answer
137
views
Does Flow support SP site column lookups?
I was thinking of using Flow in SharePoint to update a list item, seemed simple enough. Then I noticed none of my lookups were showing.
Hmmm, my lookups are driven by site columns, could that be the ...
- 403
0
votes
1
answer
494
views
Update another field with an id of a lookup column
I have a list with around 1000 columns and I need to be a able to prepopulate another field with a lookupid of another lookup field on the same list
I am getting error when I use:
var ...
- 4,326
0
votes
1
answer
538
views
How to update list with _vti_bin/lists.asmx?
I want to use the updatelist ot updatelistitem function from here. I want to add a counter to the page. And i want to increase it with code. I thought this way would useful for me. I did not find any ...
- 651
0
votes
1
answer
95
views
SharePoint Online update list item
I have custom list in one site collection which have multi line field (RichText Field). It have images path for that site collection.
Now when I migrate this list to another site collection. Path for ...
- 1,548
1
vote
2
answers
1k
views
how to loop through item id and update items via JSOM - SharePoint Online
Here is my snippet code below.My aim is to simply loop through item ids and update the list in batches. I need help with using CSOM to do this
I need this as currently when i send a batch of over 800 ...
- 4,326
1
vote
0
answers
498
views
batch updating processing with csom (Timeout issue)
I have just over 800 records i'm trying to update but I keep getting timeout error despite the fact i'm setting the timeout to indefinite like below:-
clientContext.RequestTimeout = -1
see my snippet ...
- 4,326
1
vote
1
answer
5k
views
add attachments with javascript on item edit
I'm using SP Online. I have the following code to update a list item. I added this code in a script editor inside EditForm.aspx. It works fine and I'm able to update several fields, but If user adds ...
- 319
0
votes
1
answer
904
views
Update Multiple List items on change
I have two lists and I am trying to get one to update based on a change from the other, when the titles both match.
Document Library A has a few columns including a date that is updated manually.
...
0
votes
3
answers
3k
views
Batch update In SharePoint List Using JSOM/CSOM
I'm trying to update a field using CSOM. It works for few items but when i try t on items over 700 items i'm getting the error below:-
"The request message is too big. The server does not allow ...
- 4,326
0
votes
1
answer
41
views
Update another item in same Library
I have a SharePoint 2013 Library with 2 content types assigned:
Document Set
Document
Both have a (non-shared) choice field called "Stage" with the following Choices:
Stage 1
Stage 2
Stage 3
The ...
user43832
0
votes
2
answers
349
views
Updating secondary list item based on primary list item change
As the title should suggest, I'm trying to get SharePoint to automatically update List B item whenever a list item in List A is changed.
In this case, when an item is created in List A it also ...
1
vote
2
answers
2k
views
Couldn't update list item in SP 2013 using Rest
I am trying to update a field in my list but I keep getting this error:
"A type named 'SP.Data.ttcuAnnListItem' could not be resolved by the
model. When a model is available, each type name must ...
0
votes
2
answers
146
views
Updating Field in Another List when creating new Item in other List
I'm new to SharePoint so maybe the question is stupid.
My Problem is, that I have Lists with Publications and Projects. A Publication requires an Project.
When I create an Publication I want that ...
- 3