web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Repeat field using AND condition in a Business Rule

(0) ShareShare
ReportReport
Posted on by 67

Hello,

I have spotted that some of the Business Rules we have set up look like they want to be using a combination or OR and AND within the same Condition box, of course my thinking is that will not work... A field is repeated using AND conditions but with a different answer in it. Am I correct in assuming this will not work? As this is an AND condition a value cannot be A and B it must be either. Please see scenario below with one of the repeat fields. Please note I have changed some of the words as to not breach any data but the theory is the same!

This is the condition field, set to use the AND operator

Example:

IF

Service Area = Apples

AND

Colour = Red

AND

Queue does not = Greengrocers

AND

Queue does not = Supermarket

CLEAR

Queue field

SET value of Queue = Market 

As the check for Queue is used multiple times the Business Rule will get confused as the Queue cannot = Greengrocers AND Supermarket, it must be one or the other.

Does this break the Business Rule or is it in fact a sneaky way to get around the BR being limited to choosing the one operator as AND / OR. I have a feeling it means the BR will not work effectively.

Thank you

I have the same question (0)
  • Suggested answer
    Jorge Landazabal F. Profile Picture
    on at
    RE: Repeat field using AND condition in a Business Rule

    Hi Jess
    By design, all conditions steps into the business rules you can select only one comparative clause (an OR or AND).

    You can use two conditions steps to try to emulate this feature into the business rule

    IF

    Queue does not = Greengrocers
    OR
    Queue does not = Supermarket

    THEN

    IF

    Service Area = Apples
    AND
    Colour = Red

    THEN

    CLEAR
    Queue field
    SET value of Queue = Market

    END

    END

    If found helpful, Please mark my answer verified.

    Regards

    Jorge Landazabal

    Support Engineer

  • Jess Howes Profile Picture
    67 on at
    RE: Repeat field using AND condition in a Business Rule

    Hmm yes that means that the whole BR is broken. There are several instances within 1 condition block where the same field has been used multiple times during an AND condition in an attempt to use it as OR.

    Which means they all need to be reviewed!!

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 247

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 166 Super User 2025 Season 2

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 164

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans