web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to export Choices ...
Power Apps
Answered

How to export Choices columns with label instead value in dataverse

(1) ShareShare
ReportReport
Posted on by LinTse 158

As title, I'm working on the feature about export Dataverse data to CSV file.

But the Choices columns are export with value but not label.

LinTse_0-1719999595178.png


What I need is shows Approved / Skip / Rejected, instead 161,330,000 / 161,330,001 / 161,330,002 in CSV file.

Is there any way to convert the Choices columns data with Power Apps?
Or need work on Power Automate. Please teach me.


Any information will be appreciated! Thank you!

Categories:
Building Power Apps
  • Ami K Profile Picture
    Ami K 15,689 Super User 2024 Season 1 on at

    @LinTse - the Export to Excel option only includes the unique ID for complex data types like the LookUp and Choices.

     

    Before considering Power Automate, have you considered connecting to your Dataverse table directly from Excel using Power Query?

     

    Amik_0-1720036476667.png

     

  • LinTse Profile Picture
    LinTse 158 on at

    Hey, @Amik 

    Thank you for your replied!


    Unfortunately, I need to figure this out with Power Apps and Power Automate only...
    So it's no way to display the Choices label data during the export....

  • Verified answer
    Ami K Profile Picture
    Ami K 15,689 Super User 2024 Season 1 on at

    @LinTse - appreciate that is not the answer you want but again, the Dataverse export will only export the Value rather than the Label.

     

    If all you want to do is include the Label column in the Excel export, using Excel is the most sensible option because you are returning the data directly into that application anyway.

     

    Another option is to create a Model Driven App from your table, create the View you need, and then simply click Export to Excel:

     

    Amik_0-1720125397467.png

     

    If neither option is workable, then yes you can use Power Automate to retrieve the Labels.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 271

#3
Mohsin Ali Profile Picture

Mohsin Ali 239

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans