Flow: Support equivalent of SOQL "IN" condition in Record Filters - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
10,780  Points
Idea has been posted. Give it an upvote or downvote.

Flow: Support equivalent of SOQL "IN" condition in Record Filters

Process Automation

I refer to the Fast Lookup element in Flow [edit: Get Records in Flow Builder].  Right now it appears impossible to efficiently look up a collection of records based on, say, a set of IDs held in a collection variable as would be possible using a "where <field> in :<collection>" SOQL where clause in Apex.  In Flow, as in Apex, this can be important for the avoidance of governor limit overruns, especially the query limit.  (Flows do not appear to require formal bulkification like Apex triggers, but Fast Lookups based on collections of IDs could certainly help efficiency.)

Merge Idea · Flag

Latest Comment from Salesforce

  • Alex Edelstein - 2 years ago

    UnofficialSF.com now has a Flow Action called FilterCollection that delivers a lot of the impact of the IN Operator. It's not a substitute for a native IN Operator solution, but it is a substantial improvement on traditional workarounds. It might be useful to some of the posters on this page.
  • Upvotes
  • Downvotes



from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.