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 Platform Community / Forums / Power Automate / Formula for SharePoint...
Power Automate
Unanswered

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.

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,268 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard