I am working with SP On Prem 2019. In one of the document libraries, I have about 440 files which has a metadata field of type 'hyperlink' called 'Main Letter'. This hyperlink field contains link to a document in same library.
Out of 440 Files, there are about 8-9 hyperlinks used for tagging as metadata, sample display text of these hyperlinks are as below:
- Document Revised Update 8
- LCA Updated
- Initial Proposal I
So maybe using PowerShell, I want to grab the rows where 'Main Letter' display text is 'LCA Updated' and update the URL to what I supply in like www.google.com and the same I can do for the remaining 7-8 hyperlink display texts as well.
Can someone please help me with script or flow that I can run, thanks in advance.