I have a Workflow currently like this:
get_quote_sites executes and returns either 0 or 1 result. If the result is 0, it runs the create_quote_site path and creates a record. If the result is 1, then it proceeds without creating one.
In my query6 step though I want to reference these values in a new query but I'm not sure how. What I'm trying to accomplish is:
If the top path create_quote_site was taken, set the value to be used/referenced to be the "id" field from the create_quote_site step. However, if it did not take this step, then use/reference the "id" of the row found in the get_quote_sites step.
Basically, I almost want a variable step where "query6" is, where it sets the variable to be either the id of the newly created record, or the id of the found records. If this was Power Automate which I'm more used to, I'd just add a variable step after each path and have it set that variable to be the applicable id, and then reference the variable in future steps, but I don't see any mention of variables or states here. Hope this makes sense!