Allow OR and Condition Logic in Get/Update/Delete Records in Flow - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
5,670  Points
Open
Idea has been posted. Give it an upvote or downvote.

Allow OR and Condition Logic in Get/Update/Delete Records in Flow

Process Automation

Currently, when you use a Fast/Record lookup and add same field twice as a filter condition then Salesforce secretly applies filter logic AND/OR to the query.

However, when we have all unique field as filter conditions, Flow evaluates them all as AND condition.

For Example:
I need add a Fast Lookup in my Flow to query list of records where  ((Field_1__c = 'First'  AND  Field_2__c = 'Second')  OR   Field_3__c = 'Third')

So I put 3 conditions in my Fast Lookup :
Condition 1st : Field_1__c = 'First';
Condition 2nd : Field_2__c = 'Second';
Condition 3rd : Field_3__c = 'Third';

Currently flow will evaluate it as (1 AND 2 AND 3)  and not as (1 AND 2) OR 3.

As a workaround, either we do an addtional Fast Lookup specially for a stand alone 'OR' condition such as the 3 in above example; or query large data set and use Assignement to filter it out. However it turns combersome when the initial query return large data set. 

It will be great if there can be a way to add Filter Logics in Fast Lookup or Record Lookup. Something similar to workflow rule.

 

User-added image

Merge Idea · Flag

  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Questions

No results found.

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.