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 :
Power Automate - Building Flows
Answered

Formula for SharePoint Value if Odd or Even number

(1) ShareShare
ReportReport
Posted on by

I'm trying to build a condition statement based on a value from a SharePoint list where if the value is even then do X.

 

Having an issue building the formula for this though after doing some research I came up with this but, it keeps stating the expression is invalid:

 

if(MOD((items('Send_Emails')?['Email_Count']),2) = 1, "Odd", "Even")

 

What am I doing incorrectly with the formula or is there a better way to determine if a value is even or odd.

I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,254 Most Valuable Professional on at
    Re: Formula for SharePoint Value if Odd or Even number

    @Anonymous 

    You can't use = +  - * etc..  You need to use expressions.  In your case, you need to us the equals() expression.

    See my example below:

    image.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

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard