Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Custom Columns?

(0) ShareShare
ReportReport
Posted on by 34
Hi all: I created a new Dataverse table called "Company", with 2 custom columns, Name (text) and Id (Whole Number). I have an Excel Spreadsheet with 100 records, and when I try to import into Dataverse, for some reason the ID column does not show up. I thought maybe the name was the problem as a reserved word or something, so I tried a name of Cid, but no luck. I also tried creating a new column of type Text, but that didn't work either. I tried publishing all customizations, a Browser refresh, restart, etc., Can anyone make a suggestion?
 
ID1.PNGID2.PNGID3.PNG
  • Verified answer
    Re: Custom Columns?

    Hi @JohnStraumannPA ,

     

    There are the following possibilities:

    1\ Delay or caching issues

    2\ column name caused 

     

    You could try to create a column in your excel file. Its column name is the custom column name in dataverse.

    // In my test I fixed the problem by modifying the column name in excel.

    But I can't be sure that the problem is caused by the column name, it could be the delay.

    vxiaochenmsft_0-1641872218607.png

    vxiaochenmsft_1-1641872255789.png

     

    Besides, you could use a easier way to do it. (I prefer this method.)

    vxiaochenmsft_2-1641872307270.png

    vxiaochenmsft_3-1641872321963.png

     

    Best Regards,

    Wearsky

     

     

     

     

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics