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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Automatic export Datav...
Power Apps
Unanswered

Automatic export Dataverse to Excel

(0) ShareShare
ReportReport
Posted on by 29

Having a Dataverse Table, I try to export it to Excel using Power Automate. In my Power App I like to press a button as a trigger for my Power Automate Flow. I went to Power Automate and used "Immediate Cloud Flow" ("Sofortiger Cloud-Flow). On the next Screen I selected "PowerApps" as a trigger ("Auslöser") and said create ("Erstellen"). Then I selected "New Step" ("Neuer Schritt"). Then "Download File or Picture" ("Datei oder Bild herunterladen"). On the next Screen I entered my Table name. But here I've also been asked for a GUID ("Zeilen-ID") which I don't know what it means. Can anybody help me?

Categories:
I have the same question (0)
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @4Him 

    To download  the table from Dataverse to Excel what you need to do is to List Rows in Table and select the table name, and then use the Create CSV file  action and pass the outputs from List Rows Present in a table.

     

  • 4Him Profile Picture
    29 on at

    To download the table I need to list rows in table?? Could you explain me this?

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @4Him 

    Can you please check the below topic that explains how to do the same:

    https://powerusers.microsoft.com/t5/Building-Flows/Export-Dataverse-to-Excel/m-p/856841

     

  • 4Him Profile Picture
    29 on at

    Here my flow

    4Him_0-1649243469393.png

    "Anstellungsgrade" is my table, but Power Apps says it's type "String"

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @4Him 

    Before the createcsv add list rows in a table from the dataverse connector.

     

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @4Him 

    Screenshot_2022-04-06-21-44-00-82_40deb401b9ffe8e1df2f1cc5ba480b12.jpg

     

  • 4Him Profile Picture
    29 on at

    I assume "List Rows" is in German "Listenzeichen":

    4Him_1-1649246614942.png

    There I could specify my rows I want to download. But regarding to create the CSV Table, what ist meant with "From" ("Von")? My original Table "Anstellungsgrade" is rejected. What else shall I specify here?

     

  • 4Him Profile Picture
    29 on at

    Can anybody tell me, what I have to specify on "From"? Or is something wrong with the approach?

  • 4Him Profile Picture
    29 on at

    Is there no way to AUTOMATICALLY export a dataverse db (by pressing a button or time driven)?

  • 4Him Profile Picture
    29 on at

    I checked

    https://powerusers.microsoft.com/t5/Building-Flows/Export-Dataverse-to-Excel/m-p/856841

    But this leads just to the point where I got stuck: Create the .csv file. I can't do it because it wants an input ("From", in German "Von" as I've shown in the screenshot above. This is actually surprising to me since I made this "ListRows". Shoudn't it take the input from there?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard