Question

Validate drop down lists in Workflow

Workflow Version 10

Updated October 15, 2021

asked on October 14, 2021

I have an issue with items not in a list field getting inserted during a workflow operation.

What I'm doing is taking OCR text and matching a pattern match to an option in a drop down. Obviously OCR isn't perfect, so some junk data makes its way into the field.

For example the list contains: Test1, Test2, Test3. But the OCR will miss a character, so something like Tes2 can be assigned to this field.

Is there a way in workflow to make sure a field's value is in the list of options? And if not, just leave it blank?

0 0

Replies

replied on October 14, 2021

I assume that you've set your OCR activity to "Accuracy" as well, to help with the missed characters?

0 0

replied on October 14, 2021

I do. It's mostly working as intended, but small errors do happen on occasion. I'm also using these fields to move documents around our folder structure, so we're ending up with a bit of a mess whenever this happens.

0 0

replied on October 14, 2021

Maybe create a multivalue token in workflow. Put the values of the drop down list in the token (Test1, Test2, Test3). Then check, does your multivalue token contain the value found by the OCR. If yes, put it in, if not, route to an exception or don't insert.

0 0

replied on October 15, 2021

While not as clean as I'd like, this does work.

Fortunately this field doesn't get updated very often, so updating the list in two spots isn't a huge deal (so long as we don't forget!).

Thanks for the suggestion.

0 0

You are not allowed to follow up in this post.

Question

Question

Validate drop down lists in Workflow

Replies

Sign in to reply to this post.