I’ve figured out quite a simple workaround for this.

Firstly you need to run a Find Row via Custom Query in SQL Server statement that selects the key of each of the elements in your list. So if you imagine your table called FOOD is like this:

and you want to loop through all the elements that are type ‘Hot’

Run a SQL Select that looks like this:

select replace((stuff((select ',' + str(id) FROM Food where type = ‘Hot’ FOR XML PATH('')),1,1,'')), ' ', '') as ID

That will return a single element with the value ‘2,3’

You then use Create a Loop from Text that loops through each id in the results from above in turn with the sub loop elements able to reference each Key (Id) value in turn so you can update, or read or whatever using other SQL functions.

Hi we would like to vote to enable multiple rows. It’s really stupid to not allow for multiple rows. 

Hi @kinship 

I’ve added your vote for this feature request, we’ll update you via email once available. Thanks!

Please add too

I’m sorry that workaround didn’t do the trick here, @aydinflyp :(

We’ll be sure to email you as soon as this feature request has been implemented! :)

Hi @BudgetCoinz 

I added your vote for this feature request, we’ll update via email once available. Thanks!

Please add my vote.  This is much needed! 

Hey folks,

Just circling back in here to share that the feature request has been closed - a new Find Multiple Rows via Custom Query action has been added to the latest version of the MySQL app.

That action will allow you to use a custom query to fetch multiple rows. If you’re not able to see that action in your Zaps you may need to upgrade the Zaps to use the latest version of the MySQL apps. You can learn more about upgrading apps in a Zap here: Update to the latest app version in Zaps

Hope you’re able to give that new action a try soon. If you run into any issues with it please do reach out in the Community to let us know. In the meantime, happy Zapping!

Hi, @Harris!

Thanks for your reply and for letting us know why this addition would be helpful for you - I’ve added you as an interested user on the feature request. 

Hey @Zeeptin and @LoganH24, I hope you’re doing well!

I’ve just added you both as interested users on the feature request. :)

Could you please do the same for me as well? We would use the feature to retrieve all our customers that have birthdays that particular day and add them to a email list for that day!

Please add another vote for me. 

Please add me to the vote. 

Hi @bisevo guy 

I’ve added you to this feature request. Thanks!

Add me to this request please.
I kind of understand why you are not implementing this. It's costing you zaps… right? I mean it's super easy to implement

Get my vote in as well please!

Add me to that list!! we are working where we will need this function! Thank you

Please add my vote as well and kindly let us know if there is any progress.

And please add me as anther vote for this.  Typical application would be to sync/add multiple contacts information from a MySQL db with a Contacts service.

Please add my vote as well via the email xxx@xxxx.com. 
 

I cannot believe this has been open for 3 years! It is so obvious and critical a need. Please add my email to the list.

S Gibbs

Sure thing @zappier! I’ve added your vote to that feature request now. 

Hi @Sankon - you have been added as an interested user!

Please add me as well. 

Its essential for pulling multiple row for reports, so yes please 

Hi @involved, I’ve added you as an interested user on the feature request Thanks!