I need to update a column in a SharePoint list using Integration Service. I am using the “For Each List Item” activity to iterate through each item in the list and then an “Assign” action to modify the column I want. However, after using the “Update Single Item” action, the list does not change in SharePoint.
I also tried using the “Get List Items” action followed by the “Update Single Item,” but I encountered an error: “The caller doesn’t have permission to perform the action.” This is puzzling because I can manually change the column in SharePoint, and in the Integration Service, I have the Sites.ReadWrite.All permission.
Sometimes the column names externally what you see, internally will not be same.
You need to pass exact internal name when update is being done by API’s or integration services like Example: “Status” or “Status0”
You will keep trying to Status but its internally like Status0
Kindly refer below post on same. Also verify the column names you are using. Use get list info to retrieve column info and check the internal name and display name of the column you are trying to use. And check which one are using and are you using it correctly. Try with both and see which one works(I think display name would work here).
I have successfully updated the columns, but I can only do this using the single update item activity inside the ‘For Each List Item’ loop. I didn’t encounter any issues during this process; however, I noticed that the columns do not visually update in SharePoint immediately after running the activity in UiPath. This led me to believe there might be a problem.
It seems that it takes some time for the columns to update in SharePoint.
I will close the topic.