CODEWITHSUNDEEP
azuredynamics-crmazure-logic-appsdynamics-365
DuncanW
DuncanW

Reputation: 45

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

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: Azure logic app
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?

Upvotes: 1

Views: 1364

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22846

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.

Upvotes: 0

Related Questions