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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard