Difference between Field Name and Field Name Value?

(0) Share

Report

Posted on by MShelnutt

381

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,

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@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

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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.

1 people found this reply helpful.

Was this reply helpful? Yes No