Share
Report
4I have a Excel Table that I'm trying to import into MS Planner and I've gotten it to work but it seems like I got it to work almost by accident. There is one field that is defined as a number in Excel. It will either have a 1, 2 , or 3 value. I want to check to see if the variable is = 1 and then 2 and 3 and if it's none of those, it's supposed to send and email. Each value 1, 2, or 3 has different things that happen to it.
I want to do a compare var = 1 if true do things if false do another compare var = 2 if true do things and if false var = 3 if true do things and if false send email. The code doesn't recognize the 1, 2, or 3 as integers. I've gotten it to work by using the comparator "begins with" and that makes it work but for future projects I would like to know how this seemingly straight forward issue isn't working. I've tried using the INT function on the 1s, 2s, and 3s but I don't think I'm using it correctly. I've also tried converting the var to an Integer using the INT function but again I'm not sure of the syntax.
Any help you can provide will greatly help a budding new user. Thanks
All responses (
Answers (
