Hi everyone,
I'm a bit stuck on creating a flow which should use a condition with following: if 'total' [calculated column in library] < 50000.
The column uses numbers.
Ideally if true, then an e-mail is sent to person A if not an e-mail is sent to person B.
I found some other posts, but they used edit in advanced mode, and even when I used their expression on the left side and then equals to true, the expression is deemed not valid.
I also tried Total [dynamic data] is less than 50000, but doesn't work. Maybe I should change something to the 50000?
Can someone help with this condition? Thanks in advance!
Best regards,
Laura
Hi@abm
Thanks for your help.
I figured out the issue, I forgot to add quotes to the value, which is why the expression wasn't working since I had two different types of variables.
Best regards,
Laura
Hi Laura,
Try convert the total to int or float and compare. If not map the total amount to a compose action and check the compose output to compare in your IF statement.
Let me know how it goes.
Thanks