cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Heliooso
Helper I
Helper I

Import choice column

Hello, 

 

I've exported data from dataverse into csv file and when I imported it to another enivronment to dataverse the data type for a choice column changed to text. How can I maintain the data types for columns ? 

4 REPLIES 4
dpoggemann
Super User
Super User

Hi @Heliooso 

 

This means the field is a Text column in that environment vs a choice column.  Did you export the solution from the one environment and bring into the other?  If you did not, you may want to export the data import template for the table from the target environment:

dpoggemann_0-1631536329891.png

and then you can map the data from your source environment to this (probably via Excel is easiest).  

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
rampprakash
Community Champion
Community Champion

Hello @Heliooso,

 

Points to be followed

 

1. Navigate to https://make.powerapps.com

2. Go to solutions

3. Create a Solution

4. Add the Table by clicking on Add Existing 

5. After adding Table Open the Table and Select Add Existing Component and Add Field which required and Click ok

6. Once Done Publish all Customization in solution

7. Click Export and select Unmanaged or managed then Export

8. Import the solution where you planned to import (Navigating to Solutions then click on import and import the solution which we have exported from the environment 1)

 

then you can import the CSV file in the new Environment to make it work

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

 

 

Hi @dpoggemann & @rampprakash  thank you for your assistance. 

 

I should have been more clearer that I am importing the data to a new account, not just between environments under the same account.

 

I exported the data and the app from another user and environment, when exporting the data from dataverse, it gave me the option to export to an excel file, so I did that. I then imported the app and data to the new user account and environment. Unfortunately the choice columns in dataverse are now showing up as column type text. 

 

I am not sure whether the way I exported the data or importing it causes the column type to change.

 

Here is a column that should be a choice column, I am importing the data in this case.

Heliooso_0-1631695165204.png

 

dpoggemann
Super User
Super User

Hi @Heliooso ,

 

Sorry no familiarity with that approach.  I usually create a solution and export the solution and import into the target environment.  In this case a completely different account.  This will transfer the data structure / schema like for like.  

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,336)