cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Bug in Importing Data from Excel to CDS Custom Entity

I have created a custom Entity in CDS with 10 columns. I was able to upload data from excel with that 10 columns.

 

But I removed one column from that CDS and added a new column with a different name. Now my entity will again have 10 columns.

When I tried to upload data now I'm only seeing 9 columns, Not able to see the newly added column in Field Mapping while upload.

 

Attached screenshots for references.

 

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions

Actually I found that issue, Its not from Excel side, Its my mistake sorry for that.

The new column that I've added is a Lookup column from a new entity. I have missed to add Primary key to newly created Entity.

That was causing this problem. Now I identified and resolved that issue. 

 

Thanks for your Insights 🙂

View solution in original post

4 REPLIES 4
Super User III
Super User III

After changing the CDS column did you also make any changes in the Excel columns?

No, I haven't done any change on excel.

Kindly make the same changes to the excel and retry

 

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Actually I found that issue, Its not from Excel side, Its my mistake sorry for that.

The new column that I've added is a Lookup column from a new entity. I have missed to add Primary key to newly created Entity.

That was causing this problem. Now I identified and resolved that issue. 

 

Thanks for your Insights 🙂

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (23,925)