web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Impossible to get data...
Power Apps
Answered

Impossible to get data from Excel to create new entity or import to existant entity

(0) ShareShare
ReportReport
Posted on by

Dear All,

I have tried since two days to search on internet how to deal with this problem below but in vain.

I tried to import a file Excel to create a new entity in CDS but after chossing the main field, I clicked next; but always I have the error

Error unexpected

we are sorry to reach an error unexpected

see the file joint

Please help me how to deal with this problem.

 

Many thanks

I have the same question (0)
  • SeanHenderson Profile Picture
    1,104 on at

    Hi @JeanneVU 

    I feel your pain, I have a lot of issues trying to import data into CDS! 

    I have a workaround that should solve all your problems.

    First, build out the entity with the appropriate fields to map your excel columns (it sounds like you've done this already)

    Next, convert your excel file to CSV by going to Save As and selecting CSV from the dropdown list.

    Here's the trick. We are going to use the data import wizard, and I'll bet it won't give you the same errors.

    From the maker portal, click the gear icon, then Admin Center. Click Environments, then select your environment and click Settings. Expand Data Management and click Imports:

    Annotation 2020-01-06 121827.png

    From Imports click Import Data from the top ribbon. The wizard will open, which is pretty easy to use. Add your CSV file, pick the entity to map to and follow the steps. 

    Let me know if this import method works for you, or if you hit any snags. You shouldn't get the errors this way.

     

    ---
    Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

  • Verified answer
    v-yutliu-msft Profile Picture
    on at

    Hi @JeanneVU ,

    Do you mean that when you import excel to cds entity, after you choose main field, it will get error?

    I've made a similar test but not met the same problem like your description.

    I could import excel successfully.

    Could you tell me the fields' data type in the cds entity?

    Here's my test for your reference:

    1)The excel that I want to import is in local.

    2)choose " get data from excel"

    2020176.PNG

     

    3)choose the entity that you want to import

    4)upload excel  //your data in excel should have been formatted as a table

    5)map fields

    2020177.PNG

     6)must choose for main field

    2020178.PNG

     

    in my test the main field's data type is: Text

    7) click "save changes", "import"

    2020174.PNG

     

     

    Best regards,

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard