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 Platform Community / Forums / Power Apps / Dataverse Newbie Import
Power Apps
Unanswered

Dataverse Newbie Import

(0) ShareShare
ReportReport
Posted on by 1,265

I have an Excel sheet that contains the following columns/headers...

 

Vehicle No (not unique)

Current Mileage

Past Mileage

Mileage Difference

 

I want to import this to a Dataverse table (which ultimately will be part of a Many to One relationship).

 

  1. Should the Vehicle No be the Primary Column?
  2. If I want an auto-increment column, should I add after the import?

 

I have the same question (0)
  • Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at
    Re: Dataverse Newbie Import

    Vehicle No can be mapped to the primary column (by default the logical name will be prefix_name) but setting it as primary column does not affect if the values are unique or not. If you plan to consider it as a unique key, you need to clean first the excel and create an alternate key inside dataverse using the primary column.

    Regarding the auto-increment column, which is the purpose? but probably you need to add it before the import if you want the values filled.

    hope it helps

  • RJF61 Profile Picture
    1,265 on at
    Re: Dataverse Newbie Import

    @GuidoPreite Thanks for the response and information.  I was able to import the data.

     

    I have the following question, but didn't no if this should be a new post.  I now have a table VehList (listing of vehicles in fleet).  I also have VehInsp (list of inspections performed on each VehNo from VehList).

     

    My question is should the relationship be a Many-One where multiple inspections are related to the One VehNo...or One-Many where One VehNo has many VehInsp (Inspections).  Employees will enter the inspection from their mobile device by identifying the VehNo and then providing inspection pass/fails.

  • Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at
    Re: Dataverse Newbie Import

    if you create a many-to-one relationship from one side it will be a one-to-many relationship if you see from the other side. From your message to me looks like you want to create the same relationship.

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 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard