Automated Flow not recognising String as True - even when copied and pasted from outputs!

[mattmalone]

Hello all,

I can't make sense of what I am doing wrong. The first step of my flow doesn't proceed with a "True" value. I'm sure it's something to do with my condition but if I put the string in quotations and directly post it from the results of the flow, it's still not treating the value as "True".

Inputs: It is when an item in the list is created or modified.

The Logic is meant to be IF [Delivery Status] = "Request for Approval" then kick off the Teams message of approvals.

BUT

The output is not registering the string as being true.

Delivery Status Value

Delivery Status

{

  "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

  "Id": 2,

  "Value": "Request for Approval"

}

I have typed into the condition from dynamic information [Delivery Status] [is equal to] "Request for Approval" as well as Request for approval and then I was desperate and had contains approval but all passed as False... even though that's what the output results are even saying!

Any assistance would most definitely be appreciated!

[efialttes · Accepted solution]

@mattmalone Can you access SP list configuration and doublecheck which column type is? Looks like a Choice column instead of a Text Column.

Try to select [Delivery Status][Value] [is equal to] "Request for Approval"

Hope this helps

[mattmalone]

Thanks for that, worked a treat!

Can you explain the difference between the two parameters so I can understand moving forward?

[efialttes]

@mattmalone 

As far as I understand Choices are repretented as objets with several parameters:

-an ID of type integer

-a Value with the Label chosen

See the example you shared:

Delivery Status

{

  "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

  "Id": 2,

  "Value": "Request for Approval"

}

So if you compare [Delivery Status][is equal to] "Request for Approval" you are comparing the whole object with the string "Request for Approval"(always false). If you invoke [DElivery Status][Value][is equal to] "Request for Approval" you are comparing the label with the string, sometimes false sometimes true.

Hope this helps