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 / Set a default data map...
Power Apps
Unanswered

Set a default data map for excel imports

(0) ShareShare
ReportReport
Posted on by

I have a table which my end users are going to mainly import data from excel tables they receive, I have a lookup column to another table which does not use the primary key column as the lookup value. Currently I have to manually change this in the data map, by clicking on the lookup mapped field and selecting the correct related column in the looked up table. 

 

Is there a way I can save a default data map which already has this done so that my end users will not have to do this?

I have the same question (0)
  • Verified answer
    Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at

    Hi @Ben_C 

     

    There is no way in Setting Default, but you can save the Data Map while Importing, then the next time while importing select the saved DataMap and import the same

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.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 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard