Power Platform Community Forum Thread Details

I'm trying to import a spreadsheet with two columns to a table that has a text column and a lookup column. The lookup column is not visible in the column mapping screen. I made a key as suggested here: Mapping fields with relationships in standard dataflows - Power Query | Microsoft Learn

When I try to save it with just the text field, it acts like the other column(Category) is available but not filled in, but it's not shown.