SQL Get Rows - Filter with multiple values in array variable
I'm building a flow to automatically email our vendors their ACH remit.
I've pulled in all the ACH payments for the past day with SQL, now I need to pull in all the vendors' information for that batch of payments.
I have over 1100 vendors in my table so I don't think that pulling in the entire table each time makes sense. So I have an array variable with the vendor code in it, and I want to use that variable for my get Rows V2 step to only pull in the Vendor information apart of that array variable.
I'm thinking that I'm needing to perform a "for each" step, but that seems to be taking way longer than it should.