You’re offline. This is a read only version of the page.
17
I'm trying to migrate some data from excel sheets to dataverse and I've encountered a weird problem.
I've created a table that has 2 lookup columns and the default primary name.
The primary name column was set to optional on creating the table, its an autonumber type and I've set it to optional after the table was created because it defaulted back to required.
Manually adding data doesnt require me to set the primary name column but once I try to import data from excel it throws an error saying that a required column is not mapped (primary name).
What may cause this? I didn't have problems with this in the case of other columns, I recreated the table a number of times just in case I missed something but it still doesnt work for some reason. Other tables I've created before didnt throw this error, or even if they did recreating the table solved the issue.
Didn't solve the issue. In the end I worked around it by adding an empty column to my excel table and mapping it to primary name during import. It still generatesan autonumber ID this way.
Can you please try Publishing and retry 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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
