web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Dataflow Lookup Column...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Dataflow Lookup Column Not Showing Even After Key Created

(0) Share

Report

Report

Posted on by crham

390

I am importing products and PriceList Items for those products using a Dataflow pulling from a SQL database that will constantly change.

When importing the Product I want to define the Default Price List (PriceLevelID) which is a lookup column on the Price List table.

So as I have done with other fields in this same scenario (Default Unit, Unit Group), I created a key on the Price List table for the column I do have the info to import (Name).

HOWEVER, in the Dataflow, unlike Default Unit and Unit Group, the PriceLevelID column still doesn't show up in the column mapping list.

Wh?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: Dataflow Lookup Column Not Showing Even After Key Created

Are you using correct import template ?

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

DAnny3211 367

#2

Abhilash Warrier 137 Super User 2025 Season 2

#3

Martin Dráb 82 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans