I have multiple files which I replace regularly in SharePoint. These files have properties like release number and file name that are not identical and have minor changes each time. Is there a way to automate setting the properties in such a way that the properties can be set and edited in a single text file and some tool can be used to read the text file set the properties as specified for each file?
1
-
Power automate flow or PowerShell can help with such activities. Reading the excel/csv file, match common field in file & document library and updated the properties of matched file in library.Ganesh Sanap - MVP– Ganesh Sanap - MVP2022-08-05 09:20:17 +00:00Commented Aug 5, 2022 at 9:20
Add a comment
|
1 Answer
As per my understanding by reading your question, would suggest to use 'Lookup' columns in doc lib.
You can create a list to store the properties which you want to refer in the doc lib.
Then create one 'Lookup' column in doc lib to refer the properties from list.
By this approach, all the changes which you make into the list will get automatically reflected into the doc lib properties as well. ("Is there a way to automate setting the properties in such a way that the properties can be set and edited in a single text file and some tool can be used to read the text file set the properties as specified for each file?")
