I have an Excel doc with four columns worth of info. Each column contains approval level names. When a file is scanned for a certain person in column A I want the Workflow to locate that person in Column A and route it to that group of individuals in the 4 columns. So it's pretty much an "if/and/or" type of query. Can Workflow do that? If so how?
Question
Question
How can I query an Excel doc and match it against and entry path?
asked on October 6, 2014
0
0
Replies
replied on October 6, 2014
You can. You can use the document name or field or whatever value specifies who they're for and run a Query Data activity. The activity will generate tokens for the other columns. You can use those tokens to specify the users to route to in Route to User activities.
However, since you mentioned scanning documents, I would not recommend using Excel because Excel only allows one connection at a time. Workflow will try making multiple connections when routing multiple documents that Laserfiche Scanning creates in quick succession. Using a SQL table instead would give you better performance.
0
0
You are not allowed to follow up in this post.