Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Import Excel to Dataverse - Mapping



I've created a Model Driven app where regular uploads from Excel take place. In the uploads a Lookup field is present for which the standard mapping can't be used (possible duplicates in the primary name column). Therefore, an alternative ID is used but the mapping needs to be modified each time an upload takes place. Is there a way to make an Alternative Mapping as the default to prevent the mapping to be changed each time?


See pictures below for the clicks I want to prevent:






Thanks in advance for any suggestions.


Kind regards,

Lars Dewolf


Solution Sage
Solution Sage

I don't think you can make a 'default' one, but you can stop users from creating new or editing existing ones (but may find they can still do a new map but not save it)  via the Data Map privilege in Security Role -> Core tab

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,498)