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:
It returns a result, but the result appears as a "list" item instead of an actual value.![]()
Please Login or Register to view this content.
MCode.png
Anyone know how I can convert the list record into an actual table value?
Bookmarks