Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Excel Import: Table columns not available

(0) ShareShare
ReportReport
Posted on by 276

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)

STS1SS_0-1695928588645.png

 This is the table column list, referring to CustID

STS1SS_1-1695928660609.png

 And column properties

 

STS1SS_2-1695928740075.png

 

I'd appreciate any input. 

Categories:
  • STS1SS Profile Picture
    STS1SS 276 on at
    Re: Excel Import: Table columns not available

    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.

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Excel Import: Table columns not available

    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

     

     

     

  • FLMike Profile Picture
    FLMike 30,156 on at
    Re: Excel Import: Table columns not available

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics