Forum Discussion
SP List New Column Default Value
I have an existing list with thousands of records. I now need to add a new column, data type choice (car/bike).
When I add this new column I need it to contain one of the choices by default (car). However when the column is added all the cells are blank.
How can I set a default value of 'car' in each of the rows , I'd rather not have to update thousands of rows manually.
In the column setting I have already set the default value to 'car'.
I do not want a calculated value, it should be editable by users.
-
jonboylib I would recommend using PowerShell of large number of list items. Here's reference for using PowerShell to update existing list items: How to Update List Items in SharePoint using PowerShell?
If you want to do it using flow, you can use power automate flow like:
You can also turn ON pagination in "Get items" action settings to fetch multiple items like:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like .
