How to use a list to manage file properties in multiple site libraries?

Iron Contributor

We have three site document libraries, each for a different office, to manage PDF and JPG documents that need to be reviewed by one user. When a document is added to the doc library, a line item is created in a SharePoint list for an admin user to review and update the status of the item; Accepted, Pending, or Rejected.  

I'm trying to figure out how link the items in a SPO list with the files in a site doc library. 

 

Below is a very abridged illustration of what I'm talking about. 

Screen Shot 2021-10-27 at 1.55.44 PM.png

0 Replies