Copy document meta data between libraries

[OzOscroft]

Hi all.  I'm trying to copy documents from Library A to Library B (which is in a different site) whilst retaining all the meta data.  It's working fine apart from the meta data which uses Lookup columns in Library A.  Is there a way to get around this please?

[#2]

Hello @OzOscroft 

there is no OOTB way available for cross site collection lookups. I think Power Apps works for that.

For your case to copy i found this article:

https://collab365.com/forum/topics/how-can-i-copy-lookup-field-value-to-another-site-list-in-lookup-...

Regards, Dave

[#3]

Thanks @DaveMehr365, much appreciated.  I've decided to take a slightly different approach by using Power Automate to write the information from the Lookup fields into normal text fields which copy between sites fine.