I am trying to use Power Query to check if a value in Table1 contains any value in Table2 and then return the matching value when found. Here is the custom M query code I am using:

if List.ContainsAny(Text.Split([Trim_null]," "),EarningTypes[Type]) = true then EarningTypes[Type] else ""
It returns a result, but the result appears as a "list" item instead of an actual value.

MCode.png

Anyone know how I can convert the list record into an actual table value?