Forum Discussion

dhiggins's avatar
dhiggins
New Member
6 months ago
Solved

Power Query pulls value instead of data label from choice field from my model driven app

I cannot figure out how to get power query to return the label instead of the value for a choice column from my model driven power app. I did a workaround for a different choice column of just copyin...
Need Help
Tips and Tricks
Tutorial Requests
  • v-menakakota's avatar
    v-menakakota
    6 months ago

    Hi dhiggins ,

    Thanks for reaching out to the Microsoft fabric community forum. 

    This is expected behavior in Dataverse. Choice columns store only the numeric value, so Power Query returns the value.

    The correct way to get the label is to use the autogenerated “<ChoiceColumn> (Label)” column that Dataverse exposes in the connector.

    That column returns the display text (county name) without any manual mapping or maintenance and works for large choice lists.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

    Best Regards, 
    Community Support Team

v-menakakota's avatar
v-menakakota
Community Support
6 months ago

Hi dhiggins ,

Thanks for reaching out to the Microsoft fabric community forum. 

This is expected behavior in Dataverse. Choice columns store only the numeric value, so Power Query returns the value.

The correct way to get the label is to use the autogenerated “<ChoiceColumn> (Label)” column that Dataverse exposes in the connector.

That column returns the display text (county name) without any manual mapping or maintenance and works for large choice lists.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards, 
Community Support Team

  • v-menakakota's avatar
    v-menakakota
    Community Support
    6 months ago

    Hi dhiggins ,

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

     

    Best Regards, 
    Community Support Team 

    • v-menakakota's avatar
      v-menakakota
      Community Support
      6 months ago

      Hi @dhiggins ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
       

      Best Regards, 
      Community Support Team