The Lookup Single Row action is designed to return a single row from another table, but it returns all the data from that row, including any arrays it contains. If you need to extract just one specific value from an array, you'll need to use column references to access that specific item after the lookup.
If you want to flatten arrays into individual rows, consider using the "Send row for each item in a list" action instead.