I want to be able to loop through all the documents in a document library (it has thousands of folders) - and for each document, set the value of a custom column depending on the document name.

Question

I want to be able to programmically loop through all the documents in a document library (it has thousands of folders with documents in each folder) - and for each document, set the value of a custom column depending on the document name.
(When we loaded the documents, the name of each file started with a string in brackets and we want to be able to grab this string and put the value into the new column. The documents are already loaded).
I would prefer to user powershell or power automate if thats possible.

Answer 1

Hi @Greg Booth ,

Per my understanding, Powershell cannot meet this requirement. You can try to use Power Automate to test whether this requirement is possible. Since we provide help on SharePoint in this forum, Power Automate is a product independent of SharePoint.

I would suggest you go to the forum dedicated to Power Automate for more professional advice:
Microsoft Power Automate Community

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.