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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

IN and NOT IN operators in process Check Condition

(0) ShareShare
ReportReport
Posted on by 12,163

I noticed recently that when adding a new Check Condition to a process that IN and NOT IN are now available operators. I assume this is similiar to SQL IN and NOT IN statements but the syntax does not appear to be the same. I have tried commas to seperate my values but it is not triggering my workflow.

Anybody have any ideas?

NOT-IN.JPG

I have the same question (0)
  • Joe Woltering Profile Picture
    12,163 on at

    Anyone?

  • Cherie O Profile Picture
    5 on at

    Occasionally, the field in question will be a free form text field. In this case, the same options available for Lookup and Option Set field types do not present themselves. You could return to creating a line for each value you would like to include and use the CONTAINS or EQUALS operators in a similar fashion to method described in the beginning. Once again, this is cumbersome for a large list of values. In particular, while you may have the list of values neatly listed in a text file ready to be copied and pasted all at once, you nonetheless must manually configure each line in the check condition and enter a unique value per line.

    This is where the IN operator comes to the rescue. For text fields, the IN operator allows you to compile your list of values to be used as check condition criteria in a semicolon delimited format (no spaces after the semicolons), which can be entered on one line of the check condition just as with Lookups and Option Sets.

    Below, a text field is the check condition target. The operator selected is the IN operator. A semicolon delimited list with no spaces after the semicolons has been entered to complete the check condition line item.

    pastedimage1683209628102v1.png

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 142 Super User 2026 Season 1

#2
ManoVerse Profile Picture

ManoVerse 131 Super User 2026 Season 1

#3
Nagaraju_Matta Profile Picture

Nagaraju_Matta 128

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans