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 - Microsoft Dataverse / Exporting Dataverse Vi...
Power Apps - Microsoft Dataverse
Unanswered

Exporting Dataverse View to Excel

(0) ShareShare
ReportReport
Posted on by ADumith 277

Hi guys,

 

I have a table in Dataverse from which I created a view. I wonder if there is any way to export this view to an Excel file. I tried exporting directly from the table, but the selection fields come with the number and not the description; the same happens with the lookup fields.

 

I know there is a way through a workflow, but as I mentioned before, the selection and lookup fields do not come with the correct information.

 

Any ideas?

 

Thanks,

Categories:
General Questions
I have the same question (0)
  • Guido Preite Profile Picture
    Guido Preite 1,488 Super User 2024 Season 1 on at
    Re: Exporting Dataverse View to Excel

    inside a model-driven app you have the option to export a view to an excel file, is that one you tried? strange to me it returns wrong column names, can you post a couple of screenshots of the view and the excel file you are getting?

  • ADumith Profile Picture
    ADumith 277 on at
    Re: Exporting Dataverse View to Excel

    Hello @GuidoPreite 

     

    Thank you for your reply.

     

    There you go:

     

    ADumith_0-1716137252385.png

     

    As you can see the Attorney and Approver columns are populated with the user ID instead of the user name, and ApprobalStatus column is populaed with the status ID instead of the status description.

     

    Thank you again,

     

     

  • Guido Preite Profile Picture
    Guido Preite 1,488 Super User 2024 Season 1 on at
    Re: Exporting Dataverse View to Excel

    from the screenshot you posted, looks like you didn't export this excel from a model-driven view.

    I don't know the method you used to export this excel, but you have two options:

    1) use a model-driven view to export the excel

    2) check what you are using to export to excel and try to fix it, or explain the way you are getting this excel

     

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
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

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 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans