Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

How to display choice when creating a Data Flow

(0) ShareShare
ReportReport
Posted on by 10

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

  • Ram Prakash Profile Picture
    5,179 Super User 2025 Season 1 on at
    Re: How to display choice when creating a Data Flow

    Hello @asmabahamyirou 

     

    Try Creating same set of Choice Field with Values in Dataverse and Try again

     

    Please mark as Answer if it is helpful and provide Kudos


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

  • asmabahamyirou Profile Picture
    10 on at
    Re: How to display choice when creating a Data Flow

    @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.

     

    asmabahamyirou_0-1644411317809.png

     

  • Ram Prakash Profile Picture
    5,179 Super User 2025 Season 1 on at
    Re: How to display choice when creating a Data Flow

    Hello @asmabahamyirou 

     

    Which means Dataverse to Dataverse using Dataflow, Both the place field type and values are same?

     

    Please mark as Answer if it is helpful and provide Kudos


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

  • asmabahamyirou Profile Picture
    10 on at
    Re: How to display choice when creating a Data Flow

    @rampprakash  the source place is a dataverse table.

  • Ram Prakash Profile Picture
    5,179 Super User 2025 Season 1 on at
    Re: How to display choice when creating a Data Flow

    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/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

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.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 17 Super User 2025 Season 1

Overall leaderboard

Featured topics