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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Auto-map never works i...
Power Apps
Answered

Auto-map never works in dataflows, doesn't it?

(0) ShareShare
ReportReport
Posted on by 157

Hi,

 

Is it just me or the Auto-map button never works in dataflows.  After creating your Power Query, you get to the windows where you have to map your query columns to the destination table columns.  It never works for me! 

 

molegris_0-1615906588817.png

 

 

I wonder if it's because of the prefix in the destination colunm names.  But this prefix is put there automatically by Power Apps when creating any object in Dataverse (table, column, relationship, key), it's the publisher prefix and it mandatory to make sure object names are unique... so it's always this way.  Hence I can't think about 1 scenario where the Auto-map would actually work.

 

I was thinking about submitting an idea... but then I feel it's more like a bug.  This button is just useless right now... unless I'm missing something... that's why I'm asking you, my community friends.

 

Thanks

--mo

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @molegris,

     

    You are correct.  It does not work with custom tables to run the automap function. 😥 You could enter a new idea here:

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas/status-key/Started 

     

    Sorry it doesn't automap in these situations, I wish it would.

     

    Thanks much!

     

    Drew

  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @molegris,

     

    You are correct, this does not automap for the custom tables with the prefix, wish it would.  You could enter a new idea request here and let me know the link and I will vote for it as well! 🙂

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas/status-key/Started 

     

    Thanks much,


    Drew 

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @molegris , same as @dpoggemann. It doesn't work for me and I don't bother either., You should submit a Microsoft Support Ticket at https://admin.powerplatform.microsoft.com/support as I think is actually a bug...

  • molegris Profile Picture
    157 on at

    Thank you @dpoggemann 

    Here's the link to the idea : Make the Auto-map button work in dataflows column ... - Power Platform Community (microsoft.com)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard