Hi,
This seems like it should be straight forward, but I can't figure it out. I am trying to assigned metadata from query data. My users will create a document, and type in first and last name. if a match is found in the connected database, I want queried middle name to be assigned in the metadata.
When I test the query in the workflow designer it connects successfully and returns rows. But when the workflow runs on the new document, the middle name isn't assigned. I have checked the status of the workflow and it says it is completed, but not middle name has been assigned.
What am i missing???