I need to create a 2013 workflow to update information in a library after a new document is added. The user uploads a document and selects Acronym to create the value TListID. This field would link to the ID field in the Source List to identify the correct row. I need to bring over the applicable User and Company from the Source List to the Library. I have tried numerous iterations of the Update Item workflow with no success. Any ideas?
Library
Name | Acronym | User | Company | TListID | | | | | | Test A.docx | ABC | | | 1 | Test D.docx | DEF | | | 2 | Test G.docx | GHI | | | 3 | Test J.docx | JKL | | | 4 | Test M.docx | MNO | | | 5 |
| | | | | |
Source List
Acronym | User | Company | ID |
ABC | Tom | Dodge | 1 |
DEF | Alice | Chevy | 2 |
GHI | Sally | Cask | 3 |
JKL | Pete | Ford | 4 |
MNO | Sally; Pete | Buick | 5 |
PQR | Mary | Buick | 6 |
STU | Tom | Cadillac | 7 |
