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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Building Power Apps / ExporttoExcel component
Power Apps - Building Power Apps
Suggested answer

ExporttoExcel component

(1) ShareShare
ReportReport
Posted on by Petrusottie1 42
Hi
 
Kindly assist, I am trying to export my gallery data to excel using exporttoexcel component but for some odd reasons all my choice columns are showing numbers(values) instead off label for choices. Here is my code used for exporting the data:
 
JSON(ShowColumns(Gallery1.AllItems,'Category','Created Date','Is Active','Record Name'))
 
Category is the choice column in a dataverse table but it gives a number
Categories:
General Questions
Screenshot 2025-1...
I have the same question (0)
  • Suggested answer
    Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 291 Super User 2025 Season 2 on at
    ExporttoExcel component
    This is a common issue when exporting data that contains Choice columns. By default, the JSON() function serializes the underlying value of a choice rather than the display label.
    I'd use .Value to get text value. Something like this
     
    JSON(
        ShowColumns(
            Gallery1.AllItems,
            "Record Name",
            "Created Date",
            Category.Value,
            'Is Active'.Value
        )
    )
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 624 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 381 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 225

Last 30 days Overall leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans