You may be able to do this using an autofill Unity script where you would retrieve based on one primary keyword and then only add the result row(s) where the second primary value is also a match.
We've had this situation occur a number of times - the autofill script calls a web service that requires multiple input values. This means we can't call it with one input then filter the return values based on the second input. We've had to do what many others have done/suggested: take the 2 keywords and combine them in a different field with a delimiter, then in the script tokenize them and call the web service with the multiple inputs.
+1 to getting info from an AFKS to Properties (and ideally from a Property as the input value too)! That would enable A LOT of handy options in Workflow (less scripting) without extra messiness (extra keywords). If anyone knows of relevant SCRs I'm happy to express my +1 formally.
We use the "composite key" idea that Marcus mentioned a lot in Unity Forms and in Workflow.
One Workflow-specific example is wanting to be able to select a "person" from an external lookup in a plain vanilla Workflow User Interaction Dialog. We need Autofill info about Bob Smith... and we need to choose Bob Smith (userid 1234) vs Bob Smith (userid 5678). An External Dataset concatenates the info needed for user to choose ('Bob Smith : User 1234 "), then Workflow de-constructs the string and triggers an Autofill, and we end up with other keywords set so we know that Bob Smith is in Accounting.
We've had this situation occur a number of times - the autofill script calls a web service that requires multiple input values. This means we can't call it with one input then filter the return values based on the second input. We've had to do what many others have done/suggested: take the 2 keywords and combine them in a different field with a delimiter, then in the script tokenize them and call the web service with the multiple inputs.
This is going to be your best bet for executing something like this. As others have noted, there is no out of the box functionality for dealing with composite keys.
