Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Found Multiple Records in a Salesforce Object, how do I filter out the one I need?

I am using the newly available Find Record(s) in Salesforce.  The result I get are multiple related records related to the same Account (that is my search criteria).  Now I want to grab just one of those related records based on a “filter” to then use later in the Zap.  

How do I “filter” out the one related record?  When I try to use “filter” it is evaluating all of the Related Records at once vs one at a time - if that makes sense?  

Any help would be much appreciated!  

Hi @montuckyMike 

Good question.

Try using the Looping app to handle array line items: https://zapier.com/apps/looping/help

Thank you @Troy Tessalone  - the Looping won’t work for me as a Loop has to be at the end of the Zap.  This is in the middle.  Maybe a Path with a loop would work?  I will have to try.  That way I could Loop every record through the Path - if it meets the Criteria I want aka Path A it does XYZ.  If it does not met the Criteria then maybe I just end Path B in a trivial way.  Check a box or something that does not matter? 

@montuckyMike 

You can use Filter steps within a Loop.

(Paths have to be at the end of a Zap.)

 

Looping app help article: https://zapier.com/help/create/other-functions/loop-your-zap-actions

 

How do I stop a loop from running in subsequent action steps?

All actions after the looping step will run for each iteration of the loop. If you don’t want an action step to loop:

  • After the last step you want to loop, add a filter step.
  • Set the filter to only continue if the value loop_iteration_is_last matches the (Boolean) Is True condition.

The filter will run in every loop but will only pass in the last loop. Any actions step after the filter will run once in the last loop and use only 1 task.

Note

If you want an action step to only run once, add it before the looping step, if possible. This will use less tasks and the filter step won’t be needed.

 

Pretty sure I got it to work!  

  • New Record (trigger)
  • Find Record(s)
  • Loop
    • Filter (to filter out the one I want) 
    • Create Record (using the one that started the Zap and the one I filtered out) 

Yay! Love to hear it, @montuckyMike! Thanks for sharing your solution with the community. 🤗

Terms & Conditions