Unanswered

Optional column required?

(0) Share

Report

Posted on by sandorselyem

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @sandorselyem

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

Was this reply helpful? Yes No
Verified answer

sandorselyem 17 on at

Like (0)

Report

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.

Was this reply helpful? Yes No