Dataverse Newbie Import

(0) Share

Report

Posted on by RJF61

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).

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No