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.