Excel Import: Table columns not available

(0) Share

Report

Posted on by STS1SS

307

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
STS1SS 307 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No