I am trying to setup a simple select expressi...

(Christian Farley) #1

I am trying to setup a simple select expression but I am seing a message that i’ve never seen before: Expression ‘<<SELECT(Punch[Total Travail],[Journée]=48)>>’ could not be parsed due to exception: The given key was not present in the dictionary…

Any hint?

(Praveen Seshadri (AppSheet)) #2

Odd, is this in a workflow rule? I checked your app and the expression by itself seems to verify and test correctly.

I’m guessing you are using this within a workflow rule or a workflow rule template? Any details that will help us reproduce the problem would be very useful. Thanks. @Philip_Garrett_Appsh

(Christian Farley) #3

This is meant to go in workflow rule template, but I am testing it in column Punch[TestA]. I am surprised that you say it is testing correctly. On my side it is failing with the error above

(Praveen Seshadri (AppSheet)) #4

ok, I can reproduce the problem. Investigating

(Praveen Seshadri (AppSheet)) #5

Christian, when using the formula in a column, you shouldn’t have the << >> enclosing characters. Just use SELECT(Punch[Total Travail],[Journée]=48)

(Christian Farley) #6

Hmm… that would do it…I hope I didn’t make you loose too much time with this… Thank for helping Praveen.

(Praveen Seshadri (AppSheet)) #7

No worries