News and Announcements icon

Power Platform CommunityForums Power Apps - Microsoft Dataverse Lookup column not visi...

Power Apps - Microsoft Dataverse

Unanswered

Lookup column not visible in dataflow

Like (1) Share

Report

Report

Posted on 2 Oct 2024 19:31:30 by notj

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:

All responses Img

All responses (2)

Answers Img

Answers (0)

SpaceGhost 4 on 07 Oct 2024 at 19:10:51

Like (0)

Report

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 4 on 07 Oct 2024 at 12:40:25

Like (0)

Report

Lookup column not visible in dataflow

Anyone have an idea here?

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Apps - Microsoft Dataverse

#1

stampcoin 15

#2

ankit_singhal 11 Super User 2025 Season 1

#3

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans