I've a list with a lookup column named Agents.
I want to filter it by using the Lookup Value in "Agents" with Linq but I don't understand how to be able to compare the lookup Value to a string.
the code looks like this now:
var filteredConnectList = connectItems.Where(u => u.FieldValues["Agent"].ToString().ToLower() == user.FieldValues["NameAndMail"].ToString().ToLower()).ToList();
u.FieldValues["Agents"] returns an object of FieldLookupValue I suppose but I need to access the lookup Value in that object.
Some help would be nice here ;)