How to retrieve integer values of an option set using text inside an azure logic app

Question

I'm trying the Azure Logic apps to create dynamics 365 crm records, but I'm stuck with the following: I don't know how to search a lookup value using a text field.

The process is simple. I receive a JSON message and I parse it. It has 3 fields which I need to map to my crm record. Please check the following image:
As you can see I can't do:

“new_accountlogic”: “@body(‘Parse_Account_JSON’)?[‘Account’]?[‘AccountLogic’]”

because the field is expecting an integer. I need to do something like:

“new_accountlogic”: 100000001 

So I need to retrieve the integer values of an option set using text inside an azure logic app. Anyone has any idea in how can I accomplish this?

Answer 1

This is going to be a costly Metadata call for a handful of picklist key/value stuff.

Instead you can have a hard coded text-to-value conversion mappings in Logic app itself or in some Azure functions.