
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.
@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: