Announcements
Hi,
I am trying to create DF to tranform dataverse table and load it in another one. In the first table. there is a field that is choice option. When I create the DF, the output is loading the integer value of the choice instead of the true categories.
Any simple idea how I can load the categories and not the integer ?
Asma
Hello @asmabahamyirou
May i know what is the source place, weather it is from SQL or Excel ?
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
@rampprakash the source place is a dataverse table.
Which means Dataverse to Dataverse using Dataflow, Both the place field type and values are same?
@rampprakash
The sources one is choice (a,b,c) and the end point is text type. But before I load it the end table, it change to Integer. Please see attached. The variable wwater_test belong to (a,b,c). 483,780,000 is the integer associated to a. If loaded, I will see the integer in the end table and not a.
Try Creating same set of Choice Field with Values in Dataverse and Try again
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 529 Most Valuable Professional
Haque 230
Kalathiya 217 Super User 2026 Season 1
