Converting a Text value into an Option value

When trying to save a text value from an API response into a db field that’s an option, bubble through the error “value should be an option, but right now its a text”. Any suggestions?

Hi there, @li1… you should be able to use the Get an option operator to get all of the options from the option set, and then add the :filtered operator to filter the options to the one that has the same display as the text value. Finally, add the :first item operator to the end of the expression, and you should be good to go.

Hope this helps.

Best…
Mike

Hey Mike, your suggestion worked a treat! Thanks for the help.

1 Like