Difference between Field Name and Field Name Value?

[MShelnutt]

Hi,

I am building some of my first flows and am wondering with Dynamic Content- what is the difference between [Field Name] and [Field Name Value]?  When should I use one over the other?

Thanks,

[annajhaveri]

@MShelnutt The Product Group seems to be lookup column. Product Group Value will give you the display value of the column and Product Group will give you the combined lookup value with ID and Display Value of your lookup column

[Pstork1]

Product Group is a complex object that includes multiple properties.  product Group Value is the string for the Text property of the object.  As @annajhaveri says it is probably a lookup column.  For comparisons you should use the Product Group Value field.

[MShelnutt]

@annajhaveri @Pstork1 I should have included more information about that particular field in my SharePoint list.  It is a dropdown with several choices.  I apologize, I do not grasp your explanation of the difference between NAME and NAME VALUE.  Can you explain it like I am 16?

Thanks again.

[jdoss]

A good way to check is to test the flow and look at the outputs that come out of "A new customer complaint" 

Or you could use "Initialize a variable" as a string and set it equal to NAME and do another for NAME VALUE. Then when you run the flow you can see exactly what comes out of it.

[Pstork1 · Accepted solution]

If Name is a dropdown (Choice) field in SharePoint then Name will return a record something like this {Index: 1, Value: "Choice 1"}.  But Name Value will return just the Value property from the object "Choice 1". So if you are trying to do a comparison it works much better when you use Name Value.