Filter Query Get Items how to get the value?

[Belasor]

Hello,

I´m currently trying to filter a list for one special value. On List A I have a choice field, on List B i´m doing a LookUp to receive the same values. 

I want to check if the Value from Topic is equal to "SCM" unfortunately I´m receiving an error message.

"Topic":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"SCM"}

Following error message is coming up:

One or more field types are not installed properly. Go to the list settings page to delete these fields.

[Denski112]

same issue to me hope someone could help us...

[Taylor_Becktold]

@Belasor 

It appears that your filter query is using the column display name of Topic/Value for your filter. @tom_riha has a great blog about finding the internal name of a SharePoint column: https://tomriha.com/what-is-sharepoint-column-internal-name-and-where-to-find-it/

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.

[Denski112]

Try to use Topic/Title .

[EDresvyanskiy]

Try to use 

Topic eq 'SCM'