web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Dataflow - column not available for mapping in last step

(0) ShareShare
ReportReport
Posted on by 2
Hi all
 
I am facing an issue with dataflow in Power Platform. I am using using it to populate a table in dataverse.
 
I created the dataflow and in the last step where columns are mapped, I realised that I need a new lookup column in my dataverse table. 
 
I created the new lookup column, came back to the dataflow and I cannot see this new column available for mapping.
 
Approaches I have already taken:
1. Clear cache and cookies
2. Publish all customisations so that new column is published
3. Deleted the dataflow and created a new one from scratch
 
Even after doing all this the new lookup column would not appear at mapping stage. However, when I created a new text column, it became available at the mapping stage immediately. I wonder if it has to do with just a new lookup column.
 
Any help would be greatly appreciated.
 
Thanks
Categories:
I have the same question (0)
  • Suggested answer
    developerAJ Profile Picture
    3,384 on at
    Dataflow - column not available for mapping in last step

    Please let us know if the issue still exists. If it has been resolved, kindly close the thread by accepting the solution

     

    If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

    🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

  • developerAJ Profile Picture
    3,384 on at
    Dataflow - column not available for mapping in last step

    Please let us know if the issue still exists. If it has been resolved, kindly close the thread by accepting the solution

     

    If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

    🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

  • developerAJ Profile Picture
    3,384 on at
    Dataflow - column not available for mapping in last step
    Yes, this is a known limitation in Power Platform Dataflows: new lookup (relationship) columns in Dataverse tables do not appear in the column mapping interface. This behavior is documented in the official Microsoft documentation https://learn.microsoft.com/en-us/power-query/dataflows/relationships-in-standard-dataflows

    Ensure Alternate Keys Are Set

    Alternate keys are essential for establishing relationships in Dataverse.

    • Steps:

      1. Navigate to Dataverse → Tables → [Your Table] → Keys.

      2. Create a new key using a column that has unique values (e.g., an external ID).

      3. Publish the changes.

    After setting the alternate key, the lookup column should become available in the Dataflow mapping interface

    https://youtu.be/m24yu-dwK8Q

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 998 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 426

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics