Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Lookup column not visible in dataflow

Like (1) ShareShare
ReportReport
Posted on 2 Oct 2024 19:31:30 by 780
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.
 
Categories:
  • SpaceGhost Profile Picture
    SpaceGhost 4 on 07 Oct 2024 at 19:10:51
    Lookup column not visible in dataflow
    OK, I needed keys in both tables. Dataflow was still failing but it could see the lookup column. I wrote a flow in Power Automate to handle the import instead.
  • SpaceGhost Profile Picture
    SpaceGhost 4 on 07 Oct 2024 at 12:40:25
    Lookup column not visible in dataflow
    Anyone have an idea here?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics

Loading complete