question

GregBooth-2902 avatar image
0 Votes"
GregBooth-2902 asked ElsieLu-MSFT commented

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.

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.

office-sharepoint-onlineoffice-sharepoint-server-administrationoffice-sharepoint-server-development
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT commented

Hi @GregBooth-2902 ,

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @GregBooth-2902 , is there any update?

0 Votes 0 ·