Apply to Each Loop Fails to Detect an Number Value Retrieved From a SP List Choice Column

[cmanning]

I am building a flow that retrieves items from a SP list and creates a new row in Dataverse (DV table created with choice col for DHC Score.  In SP there is a DHC Score column that is a choice type with values ranging from 0 to 20.  However, this integer must be converted to the DV 9-character integer equivalent inside the Apply to each loop and if I use a Compose action within the loop, it will convert the SP DHC score value to an object which then requires additional steps. 

Once inside the Apply to each loop, I have a condition action that is supposed to detect the matching number and then set the varDHCScore to the DV 9-character integer equivalent so it can then be written to a new DV insert row.  This is where I don't understand what is happening.  Since I know the first SP List item contains an 18 for the first record and I am limiting the results to one record in the Get Items action, I am only using one conditional action. But it will NOT detect an 18 and therefore always fails.  

Here is the entire flow.  Note, I have not even added the Set Var action to the DV 9-character integer equivalent because it never detects the number 18.  I'm sure it is something simple but I have not found the root cause yet. 

@ekarim2020 

[ekarim2020]

In the No option, add a compose action containing the DHCP-Predictor-Score column, run the flow again and examine the runtime output of the compose action. What is the value you see?

 

See also the Get items runtime output. What values are being returned by the Get Items action?

Ellis

[cmanning]

@ekarim2020  - Thank you for your response. I added the Compose in the If No.  Here are the results. 

[ekarim2020 · Accepted solution]

The DHC Predictor Score is a choice column (a JSON object) and contains a number of properties: @OData.type, Id and Value.

The property we need from DHC Predictor Score need is Value.  Value is stored as a string; it is not an integer. There should be a Dynamic content called DHC Predictor Score Value that will give you the Value property. Use the DHC Predictor Score Value for the condition. Also, try comparing DHC Predictor Score Value with string value "18":

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

[cmanning]

@ekarim2020 - Thank you for another solution and I learned a new troubleshooting technique!