Thank you for creating this topic so we can follow up after Office Hours.
Your idea of running the same query based on the value of State variables and update those depending on the output of query1 and query2 should work! To run the same query with a different scope, we could use a combination of a "Run script" event handler and Additional Scope.
