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

Not able to import data to Dataverse tables (CDS entities) from excel files.

Hi,

I have tried importing the Data from Excel to Dataverse tables(CDS Entities) which is not happening. only One filed is  getting imported rest are not getting imported from data source.

Could you please help me on this?

Thanks,
Padmini

1 REPLY 1
Microsoft
Microsoft

Hi @padminisravya ,

 

Please refer to the steps below:

1\ This is my table in excel

v-xiaochen-msft_0-1614134630030.png

 

2\ Add this excel to onedrive .

v-xiaochen-msft_1-1614134630032.png

 

3\ Create a table ‘Test 77’ and create 2 text columns. They are ‘Column 1’ and ‘Column 2’.

v-xiaochen-msft_2-1614134630038.png

 

4\ Import data

v-xiaochen-msft_3-1614134630039.png

 

v-xiaochen-msft_4-1614134630039.png

 

v-xiaochen-msft_5-1614134630043.png

 

v-xiaochen-msft_6-1614134630046.png

 

v-xiaochen-msft_7-1614134630048.png

 

v-xiaochen-msft_8-1614134630052.png

 

v-xiaochen-msft_9-1614134630055.png

 

v-xiaochen-msft_10-1614134630057.png

 

5\ The result is as follows:

v-xiaochen-msft_11-1614134630061.png

 

 

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

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.

Top Solution Authors
Top Kudoed Authors
Users online (66,739)