Missing Dataverse import columns

[CrimsonFox242]

Hello,

I am trying to build a portfolio app with several tables, I am working on the sales table and I got the views and the form set up the way I want it but when I try to import the data one of the columns I need is missing from the mapping section. I am on the community plan, the table in question has 3 lookup columns. Here are some pics to give context:

This is the table in the dataverse

This is in the data import as you can see the employee ID is missing and to manually input it would be a pain.
What am I doing wrong that makes it doesn't show all the columns?

[timl]

@CrimsonFox242 

One thing I would check is the 'keys' section of your 'Employee_Interview' table.

Is there a key defined for your Employee_ID column?

If this has become missing, it can sometimes explain these types of import problem.

[CrimsonFox242]

I dont see a key there should I make one? I thought these keys were for alternate ID columns?

[CrimsonFox242]

Wow that did the trick I had to add a key to the employees table and the field appeared. Now I have another problem, when I used the get data option the data doesn't appear like it hasn't been uploaded. The process goes through smoothly and I have no errors but for some reason the records don't appear. Any ideas?

[CrimsonFox242]

I wonder is it because I have lookup fields in the table that it wont make the records?  I am using the blank table upload method as the other gateway connections cant be used in the community plan. I am trying to import data to the columns in my table and for some reason the upload process works fine but when I finish the process the new records don't appear in the data tab. I can create the record manually and it appears fine but using the get data method doesn't create any records and I don't get any visual errors so I cant troubleshoot what the issue is.  Please also note that 3 fields of table is lookup but the fields I am importing has the right numbers. 

[timl]

@CrimsonFox242 

The data import process does work with lookup fields, provided that there is a key on the lookup table that corresponds to the data value that you want to import.

As you've discovered, it can be very difficult to diagnose problems with the import.

If all the lookup fields are not mandatory on your sales table, I would try importing the data without the lookup data to see if that works. If it imports okay, I would add a lookup field and try importing again, to try to diagnose whether it's just one lookup field that causes the entire data import to fail.

[CrimsonFox242 · Accepted solution]

Wait hold on a second, I want to be clear that I don't have a lookup field in the source data but rather in power apps and also I tried uploading a few records without the lookups and only one record out of five was uploaded. 

OK I tried again but this time the date field taken off and I got 4 out of the 5 records imported. Thing is to manually update 200 records seems like a pain. Also when I say import I mean the Get data option where all the other data sources are like access, azure services etc. not the import from excel. I am using the blank table method and raw pasting the data in.