(dataverse column type) i want to change new table's column text-> choice

(0) Share

Report

Posted on by Bingqiling

321

I clicked Import Data from Dataverse and Uploading an Excel file from OneDrive.

Looking at the picture, the data type of the Dept column is text. I want to change it to choice. However, if you change it to choice, an error occurs. Is there another name?
Seeing that the data type of auto number is named Int64.Type, it seems that there is another name. Please let me know

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Are you wanting to change the type in the Table, or in the Mapping type?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @FLMike

i want to change the type in the Table😀

Was this reply helpful? Yes No
ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Bingqiling,

Unfortunately you won't be able to change the column type from text to a choice. You'll need to create a new choice column and map/move any existing data to the new column.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Yeah that wont happen, thats why i was asking. As @ChrisPiasecki its a remove that and recreate only option
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bingqiling If you dont mind marking the answer resolved, it will show up better for others who search also.
Have a great day

Was this reply helpful? Yes No
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

안녕 @ChrisPiasecki
새 선택 항목을 만들고 기존 데이터를 새 열로 매핑 / 이동하는 방법을 알고 있습니까? 링크가 있으면 보내주세요. 감사합니다.

Was this reply helpful? Yes No