Importing from Excel. When mapping, a required column is not showing up.
The table column importing to is a whole number column. It is required. I can't find anything on this one.
This is the Excel table (just showing the headers)
This is the table column list, referring to CustID
And column properties
I'd appreciate any input.
I appreciate the reply, but this is not a solution.
I've since learned the issue is I am importing into a CHOICE column, and for some reason #microsoft doesn't allow this. No idea why, it seems pretty standard that we'd have data to import that will be a choice in our tables... maybe this is just being ignored (maybe this is simple, and we should know the answer), or there's a solution we just can't find?
At any rate I will bookmark your page as a potential resource for answers, thanks.
Hello, @STS1SS, try to use Import Data (Dataflows) to import the Excel file. Here is a full tutorial on how to acheive this: Excel to Dataverse Migration - Part 1 (ahmedsalih.blog)
If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.
Visit my Blog: ahmedsalih.blog
Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
Microsoft Business Application MVP
Hi,
Can you please provide a picture of the Mapping process so we can see exactly what you mean.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey