Lookup formula showing error "The property on this control expects Text values. The rule produces record values.."

[Shoaib_Shaikh]

I have a text field in the gallery for which I want to Lookup for ThisItem in a Sharepoint data source (which I added to the app as a data source) and return one of the fields. When I write the lookup formula I get the result correctly if the column in the Sharepoint list is just text. but then I change the formula to return a column's value which is a drop-down list, I get the error "The property on this control expects Text values. The rule produces record values..".

It looks like looking up to return a value from a column which is a drop-down list is not possible (or I don't know how to do it)

My formula for lookup is :
1. When it works: 

LookUp('CVS-WLA',ThisItem.SubWorkloadNumber=Title, MON*)

* MON is a text field in my Sharpeoint source

2. When it give the error:

LookUp('CVS-WLA',ThisItem.SubWorkloadNumber=Title, IsEnumerated*)

* IsEnumerated is a drop-down list field in my Sharepoint Data

[eka24]

Change the code to;

LookUp('CVS-WLA',ThisItem.SubWorkloadNumber=Title, IsEnumerated.Value)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-jefferni · Accepted solution]

Hi @Shoaib_Shaikh ,

Assuming the IsEnumerated column is a Choices type, please try:

LookUp('CVS-WLA',ThisItem.SubWorkloadNumber=Title, IsEnumerated.Value)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.