Hello
I have a choice field what I like to compare with an value. I don't want to use a textfield column.
The choices are Approved, Rejected and Canceled and the field name ist Status 😉
I tried different ways and I always get no result:
(1) I used the following formula: @equals(triggerBody()?['Status']?['Value'], 'APPROVED') ===> NOT WORKING
But it shows the coorrect VALUE 😉
(2) I used SELECT AND JOIN but in Join I get as result: {"Status":"CANCELED"} ===> NOT WORKING
Interesting on point (2) was that I needed to set the field in brackets [FIELDNAME] not to get the error:
"The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array."
But still not working !!!
Later on I used the following: https://www.youtube.com/watch?v=OXEcLqDvCrc
So I can say, it always NOT working.
If sombody has an idea its most apprechiated 😉
Thanks in advance.
Cheers
Michael