Forum Discussion
SP List New Column Default Value
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.
ganeshsanap I have tens of thousands of records.
It's not efficient for me to update these manually as you have demonstrated in your screenshot, it would take me a really long time. Plus, I would have to do this in future whenever any new column is added?
This seems like a real limitation 😕
Can you advise how I would use Power automate flow or PowerShell to achieve what you have demonstrated in your screenshot please?
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.
ganeshsanap Can I run the powershell script from my client PC or does it need to be on a central server? Also, do I need any special SP permissions to run this?
jonboylib You can run PowerShell from your PC. You need Full Control (or site collection administrator) permissions on site where you are making changes.
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.