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

🌸 Community Spring Festival 2025 Challenge 🌸

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

WarrenBelz 146,518 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,692 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans