Initialize Variable for Choice Field Not Working

[PowerUser06]

Hi,

I have a Choice field named 'Application Type', and when that field is modified, I want to trigger an action. So for that I used the trigger 'When a row is modified', and then I Initialized Variable for that choice field as follows (please refer screenshots)...

Then I applied a condition on that Initialized Variable...

So if the value of the Choice field is a particular value, I want to trigger an action, but whether the value is equal to my chosen value or not, the result of the condition is always returning 'false', and the 'If no' action is the one that is always being triggered. 

Can someone please tell me what is wrong with my condition?

Thanks!

[Sundeep_Malik · Accepted solution]

Hey @PowerUser06 

The variable you have taken is a string and the value that you have compared to is a number. Thats why its giving a false value every time. Instead either make the variable an integer or in the condition write "248870003".

I hope this helps.

[v-chengfen-msft]

Hi @PowerUser06 ,

The reason why you met this problem is that:
1. Get "Application Type" 's value from [When a row is added, modified or deleted], the result should be empty.

2.Because the value of the variable is empty, the Condition will be No

Please try:

Add a [Get a row by ID]
Get "Application Type" from [Get a row by ID] and return Value

Best Regards

Cheng Feng

[PowerUser06]

@Sundeep_Malik 

Thank you for your response. The actual options in the 'Application Type' field are strings, i.e., 'New', 'Renewal', 'Resubmission', 'Extension', etc. So the actual options are strings, but the number I have used is the number value of these choice labels. This number represents the option 'Extension'. The flow run shows that the Trigger of my flow has captured both the values correctly. This is what is shown in the output...

{

 "new_applicationtype": 248870003,

 "_new_applicationtype_label": "Extension"

}

Even the output of my action branch that ran after the condition returned false has captured the value and label correctly..

{

"aparnasw_applicationtype@OData.Community.Display.V1.FormattedValue": "Extension",

 "aparnasw_applicationtype": 248870003

}

So I am not able to figure out where the problem lies. 

[PowerUser06]

@v-chengfen-msft

Thank you for your help. I tried whatever you have mentioned here - added a step 'Get a row by Id', but still the result is the same. 

I checked the trigger point's output, it seems to be picking the label and value of the compared value correctly. The number 248870003 is the value for choice option label 'Extension'. This is what is shown in the output...

{

"new_applicationtype": 248870003,

"_new_applicationtype_label": "Extension"

}

[PowerUser06]

@Sundeep_Malik 

I tried putting the number value in quotes in the Condition (i.e., "248870003"), and now it is working fine. Thanks for your help!