I am working with SharePoint on prem 2019 and in one of the document libraries, I have a field called 'Trust' of type choice, this library contains about 7000 files. Now we have to convert this choice field into a lookup column and I am aware its not doable OOTB.
So we added all choice values for Trust field into a list (titled 'Trust List') on the same subsite where the library resides. Then created a site lookup column 'TrustName' that points to the title field of Trust list and added it to the library as well.
Now I need to find a solution to sort of grab Trust (choice) value for each row and paste it into the TrustName (lookup), maybe there would be need of filtering of ID from lookup list based on the match of values of 'Trust' field and Title from lookup list, not sure, I have little expertise in powershell. So looking for a PowerShell script solution for this that I can run. FYI, there are 3 other lookup fields in the same library, couple of text fields, people picker etc.