Unanswered

SQL Get Rows - Filter with multiple values in array variable

(0) Share

Report

Posted on by levi_Kovach

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.

Any thoughts?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-litu-msft on at

Like (0)

Report

Hi @levi_Kovach,

You could consider using the ODATA filter query in the Get Rows (V2) action, for more detail, please refer to this post:

https://powerusers.microsoft.com/t5/Building-Flows/GET-SQL-ROWS-With-OData-Filter-And-OR-Query/m-p/96845

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
levi_Kovach 2 on at

Like (0)

Report

Unfortunately that deals with Dates, not arrays.
I could potentially have a day where 59 items would be in the array to filter with.

Was this reply helpful? Yes No