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?
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:
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.
Unfortunately that deals with Dates, not arrays.
I could potentially have a day where 59 items would be in the array to filter with.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
45 | |
42 | |
42 | |
41 | |
32 |
User | Count |
---|---|
85 | |
85 | |
59 | |
50 | |
42 |