Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Get Name for Dataverse choices column

Hello,

 

I am trying to make a report from my dataverse data.

I have connected to dataverse (import mode) but for choices column, I got Value on my data.

I would like to take Name instead.

 

I used Replace Value to solve this but Is there any way?

What do you think best practice(performance) for this problem?

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    But how do you want to display the columns names? Do you mean you want columns names in one columns?

    Column
    column1 name
    column2 name
    column3 name
     

     

    Maybe try select the columns than unpivot.

     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous 

       

      Thank you for your reply.

      I tried but it shows like this.

       

       

      I want to change like this.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Have you found a solution yet? I have been stuck on the same issue for days.