Export Dataverse Table to Excel Using Power Automate

If you work with Microsoft Dataverse, you already know how powerful it is for storing and managing business data. However, when you need to export that data to Excel for reporting, manual export can take a lot of time, especially if you do it regularly. While some people can export manually, automating the process saves time and effort.

In this tutorial, I will show you how to automatically export the Dataverse table to Excel using Power Automate and extract a specific column from the Dataverse table using Power Automate.

Export Dataverse Table to Excel Using Power Automate

Here I will show two examples of exporting Dataverse table data to Excel. In the first example, we will see how to export all the columns. In the second example, we will see how to extract a specific column using Power Automate.

For this example, I am using a Dataverse table named Client Feedback:

Exporting Client Feedback Data from Dataverse to CSV for Monthly Reporting

In this example, I will create a monthly schedule cloud flow to extract the data from the Dataverse table and send it to a CSV.

Now follow the steps below:

1. Go to Power Automate. Click + Create -> Scheduled cloud flow. Set the Recurrence:
   • Interval: 1
   • Frequency: Month
   • Start time: First of the month (2025-06-01)
2. Click Create.

2. Add an action, List rows from the Dataverse connector, and select the table name Client Feedback.

3. Then, add another Create CSV table action to add all the data to a CSV. Under the From parameter, provide the list row body/value using dynamic content.

4. Next, add the Create file action from SharePoint because I want to store the CSV file in the document library and provide the following parameters:
   • Site Address: Select the site name where the library is present.
   • Folder Path: Then choose the library name from the file picker
   • File Content: Provide the above-created CSV table output using dynamic content.
   • File Name: Provide the below expression:

Client Feedbacks@{formatDateTime(utcNow(),'ddMMyyyy')}.csv

5. Now save the flow and run it manually. After the flow runs successfully, go to the SharePoint library, and you can see the csv file is created. When you open it, you can see all the data exported.

You can export Dataverse table data into a csv file using Power Automate.

Manually Export Specific Client Feedback Columns to Excel

In this example, I use the same Client Feedback Dataverse table where I need to export only (like Client Name, Service Type, and Feedback Score) columns into an Excel file.

Here, I will build a manually triggered Power Automate flow that gets only the selected columns and exports them to an Excel table.

Let’s follow the steps below:

1. Go to the Power Automate site and create a new Instant cloud flow with Manually trigger a flow trigger.
2. Add the List Rows action from the Dataverse connector, and select the table name as Client Feedback.

3. Then, add a select action and provide the parameters below to extract only the necessary column details from the Dataverse Table.
   • From: Provide the list row body/value using dynamic content.
   • Map: Click the T (Text mode) icon and define the structure to extract key column details. Use the following JSON mapping:

{
  "Client Name": @{item()?['cr0e5_clientname']},
  "Service Type": @{item()?['cr0e5_servicetype@OData.Community.Display.V1.FormattedValue']},
  "Feedback Score": @{item()?['cr0e5_feedbackscore@OData.Community.Display.V1.FormattedValue']}
}

The Select action is required because the dataverse contains all data, but we only need specific columns like Client Name, Service Type, and Feedback Score.

4. Add a Compose action and provide the below expression to create Excel files dynamically:

{
  "$content-type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
  "$content": "UEsDBBQAAAAIAAAAIQAfm12L7wAAAIoBAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJyQTU/DMAyG70j8hyj3NRlIE5rSTONLXCY4jN2j1O0iWjtKwtT+ewwTBXHkZvu1H7+22YxDL06QciCs5bLSUgB6agJ2tXzdPy5upMjFYeN6QqjlBFlu7OWFeUkUIZUAWTACcy2PpcS1UtkfYXC5YhlZaSkNrnCaOkVtGzzck38fAIu60nqlYCyADTSLOAPlmbg+lf9CG/Kf/vJhP0U2bM02xj54V/hKuws+Uaa2iIfRQy+esQ8IRv3uMTuHroNkjZqjOxqiw4lLc/TE+MTTb7cuAwt/ciYezq+1y1Wlr7X+2vJdM+rnifYDAAD//wMAUEsDBBQAAAAIAAAAIQBfzqihgQEAACQDAAARAAwAZG9jUHJvcHMvY29yZS54bWwgoggAKKAAAAAAAACcUkFuwjAQvFfqHyLfg5MgWhRBkNoK9QBSJaha9ebaC7gktmUvhPy+JgkBKk697ezMTjbjHU0ORR7swTqp1ZjEvYgEoLgWUq3H5H05DYckcMiUYLlWMCYVODLJ7u9G3KRcW3iz2oBFCS7wTsql3IzJBtGklDq+gYK5nlcoT660LRh6aNfUML5la6BJFD3QApAJhoweDUPTOZLWUvDO0uxsXhsITiGHAhQ6GvdietYi2MLdHKiZC2UhsTJwU3oiO/XByU5YlmWv7NdSv39MP+ezRf2roVTHrDiQbCR4ihJzyEb0XPrK7b5/gGPT7oCvuQWG2jZEB3zMW6hKbYXzzBXyMgGOW2nQP14zd9Xw6pw5nPvXXEkQT1U2k0Ky4FXnuS5ZVfv9URyHLOylayyvUJttsxyIwGeSNgmemI/+88tySrIkSgZh1A+TwTJ6TJNh2o++jvtdzZ8Ni/b7/3Y8GdTrc2++1rZq1j+j+mIV+pNZIMNdm+fN1uVdZ78AAAD//wMAUEsDBBQAAAAIAAAAIQAgtUK5mwIAAEIGAAANAAAAeGwvc3R5bGVzLnhtbKRUW2+bMBR+n7T/YPmdGmjIkgiomqZIlbZqUjtprw6YxJovyHYysmn/fcdAEqJO29S+4OPD8Xe+c01vWinQnhnLtcpwdBVixFSpK642Gf7yXAQzjKyjqqJCK5bhA7P4Jn//LrXuINjTljGHAELZDG+daxaE2HLLJLVXumEK/tTaSOrgajbENobRyvpHUpA4DKdEUq5wj7CQ5f+ASGq+7Zqg1LKhjq+54O7QYWEky8XDRmlD1wKottGElqiNpiZGrTk66bQv/EheGm117a4Al+i65iV7SXdO5oSWZyRAfh1SlJAwvoi9Na9EmhDD9tyXD+dprZWzqNQ75aCYgyJP7Q+0pwI0ESZ5WmqhDXJQJUhSp1FUst7itnHaokdqjP7ubWsquTj0/2Kv6Ko7GEsOufZK4v0Oh4VHXIgTi9izAEWeQrkcM6qACxrk50MDHBR0Vg/T2f3DemPoIYqT0QPSOczTtTYVdPI4/l6Vp4LVDogavtn60+kGvmvtHFQ7TytON1pR4UM5vhgECKdkQjz5bv9aX2C3NVI7WUj3UGUY5sYn4ShCIIPY4/UXjz9G67HfDIva+hIfEEe0L0if3CNf9Aw/+vEU0NIDBFrvuHBc/YEwYFbtOQWhr4Dzo9Yl5+QFMlGxmu6Eez79zPBZ/sQqvpPxyeoz32vXQWT4LPdWc++Dte6jhfaCE+0Mz/DP++WH+eq+iINZuJwFk2uWBPNkuQqSyd1ytSrmYRze/RoN/BvGvdtPeQpbY2EFLAUzBDuE+HTWZXh0+egbrZstArTH3OfxNLxNojAorsMomEzpLJhNr5OgSKJ4NZ0s75MiGXFPXrkWQhJF/YLx5JOF45IJro61OlZorIUiwfUvQfhQukqQ8/LPfwMAAP//AwBQSwMEFAAAAAgAAAAhAEHfy0zIBwAAESIAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7FrNjxu3Fb8X6P8wmLus0Wj0tbAc6NMbe3e98MoucqQkSkMvZzggqd0VAgOFc+olQIC06KVAbz0EQQIkQINe+scYsNGmf0QfyZFmuKJirz+AtNgVsJjh/N7jj+89Pr4h5+4nVwn1LjAXhKVdv3Yn8D2czticpMuu/2QyrrR9T0iUzhFlKe76ayz8T+799jd30YGMcYI9kE/FAer6sZTZQbUqZtCMxB2W4RSeLRhPkIRbvqzOOboEvQmthkHQrCaIpL6XogTUPlosyAx7E6XSv7dRPqJwm0qhGmaUnynV2JLQ2Pl5TSHEWgwo9y4Q7frQz5xdTvCV9D2KhIQHXT/Qf3713t0qOsiFqNwjW5Ib679cLheYn4e6T76cbjsNRmE7qm31awCVu7hRW/22+jQAzWYwUsOlrLMWNcbtMMeWQObSpbtVr284lEDmsr7DudZuDsLI0q9BBh/tjnHcGQ0bFl6DDL6xg+8FYb9Tt/AaZPDNHXw06rXCkYXXoJiS9HwX3Wy1280cvYUsGD10wjvNZtAa5vACBdGwjS7VxYKlcl+sJegZ42MAKCBFkqSeXGd4gWYQxb1MMuENicgoWvtehlImoDkIg3FQh//qF+krbXF0gFFJWvECJmKnSfHxxIyTTHb9B6DVL0Fe/fTTyxc/vnzx95dffPHyxXfeEVnG0qiy5A5RuizL/fy3r/7zl997//7hrz9//Uc3XpTxr7/9w+t//POX1MNUK0zx6k/fv/7x+1d//vJf33zt0N7jaFqGT0iChXeCL73HLIEBalPY/PGU30xiEiNiSaAYdDtUj2RsAU/WiLpwfWyb8CmHLOMC3l89s7iexXwliaPnh3FiAY8Zo33GnQZ4qPoqWXiySpfuzvmqjHuM0IWr7wFKLQePVhmkV+JSOYixRfOUolSiJU6x9NQzdo6xY3SfEWLZ9ZjMOBNsIb3PiNdHxGmSCZlagVQIHZIE/LJ2EQRXW7Y5fur1GXWNeogvbCRMC0Qd5CeYWma8j1YSJS6VE5TQssGPkIxdJM/WfFbGjYQETy8xZd5ojoVwyTziMN6S0x8iSGxOtx/TdWIjuSTnLp1HiLEycsjOBzFKMidnksZl7KfiHEIUeadMuuDHzJ4h6h78gNK97n5KsOXuNyeCJ5DgypSKAFFPVtzhy/uY2fNxTRcIu7JMjydWdu1x4oyO/mpphfYRxhRdojnG3pNPHQz6LLNsXpB+EENWOcSuwHqA7FhV9ykWUCapumY3RR4RYYXsGV6yPXyO19cSzxqlCeL7NJ+A163QnXKYjA4Kj+jsvAw8IVD+Qbw4jfJIgI5ScI/2aT2NkbV2qXvhjtc1t/z3NnMM5uWzm85LkME3loHE/ta2mSBqdVAEzAQR78iVbkHEcn8hotZVLbZyyi3sSVu4AQojq95JSPqm4ucEcc4uy7VPrQZld5RXP7oCMnHz4Wufj1b1uBW/T72zL68cXqty9uH+B2ubIVqlpxiWk93EdVva3JY2/v99abNvLt8WNLcFzW1B43oF+ygFTVHDQHlTbPXojZ9k777PglB6JtcUHwm99SPgtWY+hka9J6U3Jrf7gFkMl2o80IGFW3KkZTzO5O+IjM9ilMH+UE3vYi5FrnopvIwJ2DbSzXo/FV/TrTefVskxm5vtTl1jBcaEAsmiPWhA8WXaYatKGnSzlTcqfhvqmu1Sb7VuCCjZm5AodWaTqDtItDaNbyChqscPw6LjYNFW6jeu2jEFUNt6Bd67PXhb7/qNyDCCHTmo0efKT8bVG+8q53xQT+8zJi1HABTYu57uKK57h6dGZ0LtLTxtkdBOMWFlk9C+0gWeiOFtOI/O8r77LwXcTX3dKVxq0VOm2MyGgkar/TF8rZLItdxA03KmoKl3CXM8hEnnezOUdf0F7BvDZZJB8Aj17oXoEg5fZpKbGf8uqSXjQg6RiI3FddYx/kmIxNyjJOn6avzbcKCpTiKGXAem7q+VXKgm3K+NHHjd9jJeLPBMlv1ealGWNreQ4k2ycD7V4u8OVpJsBe4+i+eX3pSu+GMEIdZo1ZR350TA8UHNuHpO4Dxsm8mK+Lu2MuXZ3zrkKvIxolmM8iWlnM0NXC8oWzr6bmuD0l0+ZjDorgmnS7XCvvey++a1WlmuWB87xaJppRW1bLqz6cdb5UusilXUYmVy9/Wc29kkOwhU5zLx/mt/iVrRmUVNMd7Nwypp5602tQ9YEZRWn+Yeu20XCacl3nXpB7nrUatWiE1hqQNfH5yXz7bZ9BkkjyGcIq6oOe2mKdzp0jI75dq3UzZf55dUmERjfK6KUpPKH+OFR+ZXXT90VY754XFeDdAU0LrmhRm2FXRWe7agWuxyUTNht8KmjL1Wr9rCW4nNMetWWG8tumjLq81ptqrVdc/KYWbUOg1rS8HVrhVhm5wjKJ3NYa7JvZBnrmReacOVt+Kk638eNHrRIGwMKkG7MapE9SiotBu9eqXXaNRro0YtGPbD50BPxkmtYb58GMNpEF3n3z/o9p1vIJLNgdedGUuqTH/jUNXe199A1ML930CAI4FWMxx36p1+s9Kp98aVaNhvVzqDZr8ybA5aw/Fw0Gh3xs9970KDo159EDVH7UqzNhhUomag6Lc7lVYUhr2o1WuPot7z3P0wcpODc1uA+TSve/8FAAD//wMAUEsDBBQAAAAIAAAAIQCMcfAH7wIAAI0HAAAPAAAAeGwvd29ya2Jvb2sueG1srFRtb5swEP4+af8B+TvFJpAQ1KQKAbRITVWlWbt9qlxwEiuAkXEaqqn/fWcSkmatpqgbApvznR8/9+K7vKrzzHhmsuKiGCBygZHBikSkvFgO0Pd5bHrIqBQtUpqJgg3QC6vQ1fDrl8utkOsnIdYGABTVAK2UKn3LqpIVy2l1IUpWgGYhZE4ViHJpVaVkNK1WjKk8s2yMu1ZOeYF2CL48B0MsFjxhoUg2OSvUDkSyjCqgX614WbVoeXIOXE7lelOaichLgHjiGVcvDSgy8sSfLAsh6VMGbtfENWoJbxc+gmGw25NA9e6onCdSVGKhLgDa2pF+5z/BFiEnIajfx+A8JMeS7JnrHB5Yye4nWXUPWN0jGMH/jEagtJpa8SF4n0RzD9xsNLxc8Izd70rXoGV5Q3OdqQwZGa1UlHLF0gHqgSi27LjgIENuymDDM9DaXo/0kTU8lPOtBKGWfhvPWyUN+J+E14B5R5/hBPAj3RfgBCAIeQwjuxeHLnFDHAVdr9PBHTu2w140svvRmHh41ItjEgMVKCA/EXSjVnviGnaAnI9UU1q3GoL9DU+PFH7h/WPq+Y+h1b1qv/QVvedsWx1d1KJRP/AiFVuIgAP+vLQSwS4yto3qgadqBe453nHtG+PLFfD1cJNNaWtaA3RCJ9zRieEx9XBCx3rDp+kEwKuZjaLJ3p3uDgRajp6b6EK2fH2GnKREO2S12xKaJbfS0FNj2CfY9rQFq9V1pZrZ2EgO9IgDGcB9x8RRxzUdr2+bntOxzbET2pHbi8IocF//532GEiKu37ZIzXJFpZpLmqyhsc7YIqAVVNLOIeD7lmzgegHuAEUHSsZ0SB+bQdB1TDeMO26PhOPIjY9ktfuLT94mz2p2M6o2Eto6kG5kX4/xfvWwuNgt7PN00pb8Wajjvt/9N8M78D5jZxrH92cajm+m8+mZttfR/PEhPtd4NA3C0fn2o9ls9HMe/WiPsD4MqNUkXI9NmVptmQx/AwAA//8DAFBLAwQUAAAACAAAACEA6eHjsNABAACNAwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJySS2vDMAyA74P9B+N76zhtxxqSlsEo623sdXccJTH1I9hOH4z99znp2g5yKTV+ytYnyVK63CuJtmCdMDrDdBxhBJqbQugqw58fq9EjRs4zXTBpNGT4AA4vF/d36c7YjasBPAoE7TJce98khDheg2JubBrQ4aY0VjEfjrYirrHAil5JSRJH0QNRTGh8JCT2GoYpS8Hh2fBWgfZHiAXJfPDf1aJxJ5ri1+AUs5u2GXGjmoDIhRT+0EMxUjxZV9pYlssQ955OGUd7G3ocxuRkppcPLCnBrXGm9ONAJkefh+HPyZwwfiYN478KQ6fEwlZ0Cbyg4ttcorMzK77AJjfCHs6w7rts0ooiw9/RXxuFlXZTdJlOdz94kRYiZLiLClkoM/xEMVmkffF8Cdi5f3vkWf4OEriHYIBi1NVmbsyme7gOoqhTJQPdVV+brxYVULJW+jezewFR1T5AZkHlFwAA//8AAAD//7IpzkhNLXFJLEnUtwMAAAD//wAAAP//silITE/1TSxKz8wrVshJTSuxVTLQM1dSKMpMz4CxS/ILwKKmSgpJ+SUl+bkwXkZqYkpqEYhnrKSQlp9fAuPo29nol+cXZRdnpKaW2AEAAAD//wMAUEsDBBQAAAAIAAAAIQC9hGIjkAAAANsAAAATAAAAY3VzdG9tWG1sL2l0ZW0xLnhtbGyOOw7CMBAFr4LSky3o0OI0gQpR5QLGOIqlrNfyLh/fHgdBgZR6nmYediS8dRzVRx1K8p3BE2caPKXZqpfNi+Yoh2ZSTXsAcZMnKy0Fl1l41NYxgUw2+8QhKjx28LVptcFYXdIY7INUXzE9uzvV1Dlcs81lSSH8IB5vQdcnH4IX/1zHC0D4O27eAAAA//8DAFBLAwQUAAAACAAAACEANJ2OQ7kAAADJAAAAGAAAAGN1c3RvbVhtbC9pdGVtUHJvcHMxLnhtbAyNwYrCMBRF9wP+Q3j7mDZqRqVRprYF9wqzDemrLTTvSROHAZl/n6wu9x64pzr/hln84BInJgvlugCB5Lmf6GHhfuvkHkRMjno3M6EFYjifVh9VH4+9Sy4mXvCaMIg8TDmvjYW32elGH8pPuWsvndx+da08XPZa1nVdGtNuOq3NH4ispnwTLYwpPY9KRT9icHHNT6QMB16CS7kuD8XDMHls2L8CUlK6KIzyr6wP32EGdfoHAAD//wMAUEsDBBQAAAAIAAAAIQB/K6G8mwkAAEAwAAATAAAAY3VzdG9tWG1sL2l0ZW0yLnhtbOxb62+cSBL/vtL+D4j7zAADzEuZrJyZ5M7aeBOtR6v9tmqaxsMZ6Ak09lir+9+vups38wDs1UanS6TYPKq6urqevyLvfjpGofJEkjSg8Vo1J4aqkBhTL4gf1mrGfG2h/vT+HWYrTGNGYrZ7OZB7vCcRUuDmH2tVVSJU/qy99AuKyFrdUpxFQCbeqj293a5V42iY8NdY2tbGsuyP9o1hWkv75mZhGjfOh7m9/bCxFzfzNu1vpbRW+9GWpDgJDkxsZpMQxIiClJg8K14uyKRNco/pAQQVt3M9cOF8x3V9m+Cl4Rl45i4My5ySqeNaDvxEvq8qoLg4XWG2VveMHVa6ngq1pJMowAlNqc8mmEY69f0AE31qGDM9Igx5iCG9pomCUYTGMDokIH3CApIK5jeMJYGbMZKq73/84d0x9VZSKoWh5IEwfijpAWHY8HChq7WEshJKYe8syYi49AMSeilXneMbznSBl47nT23LtgxMbNf2bdsxXMdYIlWJ06k0mTi15C9SmSBvKdjz8/Pk2ZrQ5IHrztR/v/ss7a5Q2DHt/+7htfuV8oHca9UGaWY+IprlWoZm+8ZSQ4sp0ZbWAizFNqd4MS1khP2tVeRMHcOfG/DGdAYEDtKQ4xna3FvihUcsz7NQeVxBdKAJU+LqoHqtpxfH3aXvtXxJT0LC/VUIsFZrR14sADZ9CMmRx4HSxMi3DIJGed3kUXjeHYrRg2BebvYELxSGBduCTUL8tcpN5o54AbonyRM41F3uSmB7QfwF4ywBczDUzj5OEn9CKXsVg3uCErz/WjrfKCm+uP8mmG0Jg39pkke1dBSrLQS6HXok8Sjqf5KYJIgHzV0QcW8ertGPT2A0/0LpfkO9/hxC7M9nvuk4mHi252HXNpZz07J938KWNYUg20sUa7VDxw1ieH8ThuOOYvNrbzqPRPTUyzqPtrn5it9b1i3u5TbNTVxcpzXX6U8kEs21AN8vTuUCfaJJtCU+ykKI6d8yFAYQz70q1P5FcdmLqiB+PX12I4nOIAyBy8jwfMD9wnwQ+/SA2J4nlrn+FSUM7H8D9U1CwypxdiNp75R5VtALYboP88uCn4nhZ6ImWgWxR45rdQH5OAhD5IZQFZTp3AvSQ4heZBV3lsU+8DwCdWNJFkCRmMQovEIHlZn3JQ5fcsrSlEHnIamnloSkUNFgHpsUF6UgIZjM6hfKiAz10okaZG0/427ZzEj17bRSQamV5TCtdNgM0EyH9vvRzok8V2rIhFZhiOGc5DVATSfpvx9Vnc3mlcLMYQq7wPGE2sCXCUTpHp54ge8r1bkjR/ZGflmvaCoNQmE9xOSaTF6ltCar70dPndqtUhZ0x0OUdYLTAO88Qf39KKldnVY6sofpqMtogIq6xH+vhnpU35WiZicVxdCRxjQq8jiHgpoVQK81Ci6fOITQrRxuI+gbd+iBt0Zo1ShMxCOlfFbp00dhWsMlbiEy/unk3YbG2w2N9xsabzi0esfxH7FGIdAdlMNBLaam6YFzsv2ZZZE50vDUdDTbWc60hQdd/ZT42JwR7C45AgCyQi0U3RPGaYzlwrSxZ2nObEE0nywBDoA7QDibmr6/8N0F2CLQoBjvacJJfBc5tu9aGraICSQLU0Pz+UzDyHZnS9NeYBsqdCABCKhRg6U/k5dnmnAWQg0jWnfRNh/wagc7aLeksOSx6LhN9b1sZF7b2Fyu0r6I/qyyxh4168cjSxBmxFNEVuqaZr0KLPi/RTlRaBu09JnED2yvPKEwg8p16ji15FirbKtucGAhm7eilV56VK0ljQ8tH4JubwsohkefOXTQ9l7x7tDiXKj7L1OCLPh7NcC9gC/l/w3w/3oD3ASHKmeBwcK1+ghIRX5TBLqkALykbGiYRdJZOrk/DFJwqD/RzFks58u5tvBngBATd6kt54D/2nNkEWKbztxzZaJpJsu2oOmePoucuFYLdAvKUMDPwVGfiTsQWT4Btua3OPQB8F2Jux7his+Dah23yISbPQXk9TOlj9mhmi9cBH9/46FPVThMI1v3nLqeQ7LYpRlgETyZ1ZHH9ukIfOM0agZ9hxS5DKXdrb0xvNbCa3gOBhRKBtVUjC1gzvIIlUtn9JMQrT5KuRKAUDHSaUB0WVwD6dyQ4scSvfsHYJA5ItaBw8ZLOWpAA7VTrqaz0xwtiFMGNQ8YiVzCq0C8Q5aEQpMe1nMtpbo5MfXqXV5hVRBinUA8Kd+kAMldAQcLX9Sp610Yx+QbuiCbBDI/Uywg9XJVL3PDAEarCRF7yuFOHXad6t9ghwBGWrph68ZU9/AE6qFqmHEWijy14bdYXiivKUMTQuPbqI8/pINvdn+0HpSYZC365LOl7stFADo3A/LwCvOZLk3akaJRkZ6eAXlQC4KtSA7dWNOLwyoAtJNxaHygBHyct1YbU99mqGssn4dLMb0F9DN+yEszAdcC6tbugvL4rXDg9MwEDFTHAha2RzPNUl4WgGIV2Ys0eq2doD+n3FWaiXHWqJNZedXcfhgDqdhH2e9cblS6Wj27lxDFDxmE7jGygNeTB5q8XKTtIYvcWf5FwtswS8hTwPP6QG6lW8YxZSKmFXeKOUdxUznzZ7cPUtkFKTB0CLiKUoXtiRJnkUsShfpKip7gHk2UQsh0ouzgDXQ4hJyAlyPABLqmA4XiBIYVCuRaJTvA9xTgIcCtXAL54OkKQXhfMpv8+MMp0WTr2t6FvIsau70+VAj5TBm+m+Fzsw+vPn3RfxchK8rZjjJHWdvdw8Flo/yj11hT5hxpFq/64uTyhOtas9ajVnrLSWFesfT6ECXXTTOLfoUvmcAd82edAn1Vnw4f03KKVYAz22pG1zINAcoU77eWLqhvMIayG8Cp8bQi4TSL9s7KYD+NffDr7mT8jKwyCDb2KSsNzlSmxktbleS1jY4mljsdTv5hu7lJU4oDCHneR6gd2Mvo4wZeOYdWn1QrHqpe6upBgApLf4FACd/YAN4nFyg/E5PoXvVebkqX6HqT3L+kjES3efnPl+xNWqgUksI5ul5mVu1DWkp792WabhpbSdZRR5tN0fm2zfUahxO6GSlLW1U92TTjVGV5Y0OV1OzrApbkURjMr8QnCf/qbET4yjl5MJBtlOF9wmZByxH+OloxhJZ/tzqWllfmY2mda7RvEKxPnPTwsHn2qEez4mc9nhgOezwxnPZ4Yjju8cRw3sOJ5chnrKNz6lv4vupCrTogR40oFkoBXrMDkVWG+5lY+2o99QZOxheSMo47X170XaUUcpaTFv3U/wF4/18AAAD//wMAUEsDBBQAAAAIAAAAIQAvfJOtuAAAAMkAAAAYAAAAY3VzdG9tWG1sL2l0ZW1Qcm9wczIueG1sDI3BisIwFEX3gv8Q3j4mbZxWi1F0quB+BLchfdVC8540UYTBfzery70H7tns3mEUL5ziwGShWGgQSJ67gW4WLn8nuQIRk6POjUxogRh22/ls08Wmc8nFxBOeEwaRhyHnubXwb9r98VSagzRmXcplXSzlwZha/vxWuq3q8ljo+gMiqynfRAv3lB6NUtHfMbi44AdShj1PwaVcp5vivh88tuyfASmpUutK+WfWh2sYQW2/AAAA//8DAFBLAwQUAAYACAAAACEAdD85esIAAAAoAQAAHgAIAWN1c3RvbVhtbC9fcmVscy9pdGVtMS54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAITPwYoCMQwG4LvgO5Tcnc54EJHpeFkWvIm44LV0MjPFaVOaKPr2Fk8rLOwxCfn+pN0/wqzumNlTNNBUNSiMjnofRwM/5+/VFhSLjb2dKaKBJzLsu+WiPeFspSzx5BOrokQ2MImkndbsJgyWK0oYy2SgHKyUMo86WXe1I+p1XW90/m1A92GqQ28gH/oG1PmZSvL/Ng2Dd/hF7hYwyh8R2t1YKFzCfMyUuMg2jygGvGB4t5qq3Au6a/XHf90LAAD//wMAUEsDBBQABgAIAAAAIQBcliciwwAAACgBAAAeAAgBY3VzdG9tWG1sL19yZWxzL2l0ZW0yLnhtbC5yZWxzIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAhM/BasMwDAbge6HvYHRfnPYwSonTSxnkNkYLvRpHSUxjy1hKad9+pqcWBjtKQt8vNYd7mNUNM3uKBjZVDQqjo97H0cD59PWxA8ViY29nimjggQyHdr1qfnC2UpZ48olVUSIbmETSXmt2EwbLFSWMZTJQDlZKmUedrLvaEfW2rj91fjWgfTNV1xvIXb8BdXqkkvy/TcPgHR7JLQGj/BGh3cJC4RLm70yJi2zziGLAC4Zna1uVe0G3jX77r/0FAAD//wMAUEsDBBQABgAIAAAAIQCJiOMPBgEAANcDAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHO8k09rwzAMxe+DfQfj+6Ik3coodXoZg15HBrsaR/lDYztY6rZ8+5kO0hVKdgm9GCTh935+wtvdt+3FJwbqvFMyS1Ip0Blfda5R8r18fXiWgli7SvfeoZIjktwV93fbN+w1x0vUdgOJqOJIyZZ52ACQadFqSvyALk5qH6zmWIYGBm0OukHI03QN4a+GLC40xb5SMuyrlRTlOETn/7V9XXcGX7w5WnR8xQKIxz4+QJQ6NMhK/tZJZJRw3T5f0p5jLHh2P5VwOrM5hmxJhi8fDtQi8pljahGcJrMw6yVhzJHY248Y/7SSJIGpCx2jXc1F83RrmnyO5vHWNNOm4OI7Fj8AAAD//wMAUEsDBBQAAAAIAAAAIQC8r/ecRAEAAI4CAAATAAAAY3VzdG9tWG1sL2l0ZW0zLnhtbKzSu27DIBQG4FeJ2G2w8S2W7ajK2kiV2qHrCRxiJBssIHUev06atB0itZW6MfB/nAvN5jQOqzd0XlvTkiRmZIVGWKnNoSXHoKKKbLpmqidnJ3RBo18tCePrqSV9CFNNqRc9juDjUQtnvVUhFnakViktkKaMFXTEABIC0C+FXJmT15/QPM/xzGPrDudYQl93j88XO9LGBzACb6lJ/O51bZSdIPRnr6RP4IJBt7UmODt40jXSiuOIJuzAwAHPp655gdMWgugfhuGjxpZAnuZMlSxa87SIMpVDBLlkUSnXopLIpeSwlOZ1bfTQkuCOSOii42hvRLY0VCjAiO85Wwi2jqBKcRErJoosSUWV3iEGocpCJXkuUGZSin3G1mXCM6W44DxVf+KX3tCN1wX+zwDpRewa+lOhy5V7w6bff1b3DgAA//8DAFBLAwQUAAYACAAAACEAOCuS+LUAAADJAAAAGAAoAGN1c3RvbVhtbC9pdGVtUHJvcHMzLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMjcEKwjAQRO+C/xD2XhNbra0YRWkD3hW8hnSrhWZXmiiC+O/mNLwZmLc7fPwo3jiFgUnDcqFAIDnuBrpruF5MVoEI0VJnRybUQAyH/Xy268K2s9GGyBOeI3qRiiHludHwNfW6bYo6z0y9WWWrXB2zkzEJy0q1x3VVFGX7A5HUlG6ChkeMz62UwT3Q27DgJ1Iae568jQmnu+S+Hxw27F4eKcpcqVK6V9L7mx9B7v8AAAD//wMAUEsDBAoAAAAAAAAAIQD/////EgEAABIBAAAQAAAAW3RyYXNoXS8wMDAwLmRhdP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQSwMEFAAGAAgAAAAhAHvzAqPDAAAAKAEAAB4ACAFjdXN0b21YbWwvX3JlbHMvaXRlbTMueG1sLnJlbHMgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACEz8FqwzAMBuB7Ye9gdF+cdDBKidPLKOQ2Rge7GkdxzGLLWOpY336mpxYGPUpC3y/1h9+4qh8sHCgZ6JoWFCZHU0jewOfp+LwDxWLTZFdKaOCCDIfhadN/4GqlLvESMquqJDawiOS91uwWjJYbypjqZKYSrdSyeJ2t+7Ye9bZtX3W5NWC4M9U4GSjj1IE6XXJNfmzTPAeHb+TOEZP8E6HdmYXiV1zfC2Wusi0exUAQjNfWS1PvBT30+u6/4Q8AAP//AwBQSwMEFAAAAAgAAAAhABNevmUCAQAA3wIAAAsAAABfcmVscy8ucmVsc6ySTUsDMRCG74L/Icy9O9sqItJsL0XoTWT9ATGZ/WA3mZCkuv33RkF0obYeepyvd555mfVmsqN4oxB7dhKWRQmCnGbTu1bCS/24uAcRk3JGjexIwoEibKrrq/UzjSrlodj1Poqs4qKELiX/gBh1R1bFgj25XGk4WJVyGFr0Sg+qJVyV5R2G3xpQzTTFzkgIO3MDoj74vPm8NjdNr2nLem/JpSMrkKZEzpBZ+JDZQurzNaJWoaUkwbB+yumIyvsiYwMeJ1r9n+jva9FSUkYlhZoDneb57DgFtLykRXMTf9yZRnznMLwyD6dYbi/JovcxsT1jzlfPNxLO3rL6AAAA//8DAFBLAwQUAAAACAAAACEAIFmKTn0BAAARBgAAEwAAAFtDb250ZW50X1R5cGVzXS54bWy0lE1PwkAQhu8m/odmr6ZdwMQYQ+Hgx1E5YOJ1bad0w35lZ0H490634MFgEYuXbtrtvO+z8047nm60StbgUVqTs2E2YAmYwpbSLHL2On9Kb1mCQZhSKGsgZ1tANp1cXoznWweYULXBnNUhuDvOsahBC8ysA0M7lfVaBLr1C+5EsRQL4KPB4IYX1gQwIQ2NBpuMH6ASKxWSxw09bkk8KGTJffti45Uz4ZyShQhEytem/OaS7hwyqozvYC0dXhEG4wcdmp2fDXZ1L9QaL0tIZsKHZ6EJg28U/7B++W7tMusWOUBpq0oWUNpipakDGToPosQaIGiVxTXTQpo99yF/Kp5565Da6OF0gn2fmurUkRD4IOGrU52OFEHvI0MTcgnlqd7FCoPVve1bmV+a76KOuSCPy/DMmTejFIW7IieOQJ8WtNf+CFHsiCGGrQI894RH0S7nNp83rbgMoOOg9z/vl2ijd3zeDzCMzjR4dLA/M1z/JwOPP/TJJwAAAP//AwBQSwMEFAAAAAgAAAAhAHp9ZcIrAQAAEgIAABMAAABkb2NQcm9wcy9jdXN0b20ueG1spJFLa8MwDIDvg/0H43tq5bUmJUnJq9DDYNBud5M4aaC2g+1mDWP/fS5bV3bYZTsKSZ8+Scn6zI9oYkoPUqTYXQBGTDSyHUSf4uf9xokw0oaKlh6lYCmemcbr7P4ueVJyZMoMTCOLEDrFB2PGFSG6OTBO9cKmhc10UnFqbKh6IrtuaFglmxNnwhAP4IE0J20kd8ZvHP7krSbzV2Qrm4udftnPo+VlyRd8Rh03Q5vityosqyqE0PHquHRccAsn9uOlAxGAV3jlJs7rd4zGS7GHkaDcrl5KYeyMC3TbWupkVsfxVRuVwRksAyAO/NL3gzrIwfXjIM8jF/KwWAZVUQZRvkzIrSchV6t/+vlXv0fWDnTH1GQPsuW0Z3va6x+ev80nt2dmHwAAAP//AwBQSwECLQAUAAAACAAAACEAH5tdi+8AAACKAQAAEAAAAAAAAAAAAAAAAAAAAAAAZG9jUHJvcHMvYXBwLnhtbFBLAQItABQAAAAIAAAAIQBfzqihgQEAACQDAAARAAAAAAAAAAAAAAAAAB0BAABkb2NQcm9wcy9jb3JlLnhtbFBLAQItABQAAAAIAAAAIQAgtUK5mwIAAEIGAAANAAAAAAAAAAAAAAAAANkCAAB4bC9zdHlsZXMueG1sUEsBAi0AFAAAAAgAAAAhAEHfy0zIBwAAESIAABMAAAAAAAAAAAAAAAAAnwUAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAAACAAAACEAjHHwB+8CAACNBwAADwAAAAAAAAAAAAAAAACYDQAAeGwvd29ya2Jvb2sueG1sUEsBAi0AFAAAAAgAAAAhAOnh47DQAQAAjQMAABgAAAAAAAAAAAAAAAAAtBAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQItABQAAAAIAAAAIQC9hGIjkAAAANsAAAATAAAAAAAAAAAAAAAAALoSAABjdXN0b21YbWwvaXRlbTEueG1sUEsBAi0AFAAAAAgAAAAhADSdjkO5AAAAyQAAABgAAAAAAAAAAAAAAAAAexMAAGN1c3RvbVhtbC9pdGVtUHJvcHMxLnhtbFBLAQItABQAAAAIAAAAIQB/K6G8mwkAAEAwAAATAAAAAAAAAAAAAAAAAGoUAABjdXN0b21YbWwvaXRlbTIueG1sUEsBAi0AFAAAAAgAAAAhAC98k624AAAAyQAAABgAAAAAAAAAAAAAAAAANh4AAGN1c3RvbVhtbC9pdGVtUHJvcHMyLnhtbFBLAQItABQABgAIAAAAIQB0Pzl6wgAAACgBAAAeAAAAAAAAAAAAAAAAACQfAABjdXN0b21YbWwvX3JlbHMvaXRlbTEueG1sLnJlbHNQSwECLQAUAAYACAAAACEAXJYnIsMAAAAoAQAAHgAAAAAAAAAAAAAAAAAqIQAAY3VzdG9tWG1sL19yZWxzL2l0ZW0yLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAImI4w8GAQAA1wMAABoAAAAAAAAAAAAAAAAAMSMAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAAAAgAAAAhALyv95xEAQAAjgIAABMAAAAAAAAAAAAAAAAAbyQAAGN1c3RvbVhtbC9pdGVtMy54bWxQSwECLQAUAAYACAAAACEAOCuS+LUAAADJAAAAGAAAAAAAAAAAAAAAAADkJQAAY3VzdG9tWG1sL2l0ZW1Qcm9wczMueG1sUEsBAi0ACgAAAAAAAAAhAP////8SAQAAEgEAABAAAAAAAAAAAAAAAAAA9yYAAFt0cmFzaF0vMDAwMC5kYXRQSwECLQAUAAYACAAAACEAe/MCo8MAAAAoAQAAHgAAAAAAAAAAAAAAAAA3KAAAY3VzdG9tWG1sL19yZWxzL2l0ZW0zLnhtbC5yZWxzUEsBAi0AFAAAAAgAAAAhABNevmUCAQAA3wIAAAsAAAAAAAAAAAAAAAAAPioAAF9yZWxzLy5yZWxzUEsBAi0AFAAAAAgAAAAhACBZik59AQAAEQYAABMAAAAAAAAAAAAAAAAAaSsAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAAACAAAACEAen1lwisBAAASAgAAEwAAAAAAAAAAAAAAAAAXLQAAZG9jUHJvcHMvY3VzdG9tLnhtbFBLBQYAAAAAFAAUADYFAABzLgAAAAA="
}

5. Add the Create file action from the SharePoint connector. Set the parameters:
   • Site Address: Select the site name where the library is present.
   • Folder Path: Then choose the library name from the file picker
   • File Content: Provide the above compose action output using dynamic content.
   • File Name: Provide the below expression:

Client Feedback @{formatDateTime(utcNow(),'dd/MM/yyyy HH:MM:ss')}.xlsx

6. Add the Create table action (under the Excel Online (Business) connector) and provide the following parameters:
   • Location: Select the SharePoint site from the dropdown menu.
   • Document Library: Select the library where the Excel file is stored.
   • File: Provide the dynamic content from the Create file action, using Id.
   • Table Range: Specify the range based on your number of columns. For example, if you have three columns, use A1:C1. Adjust this range according to your columns.
   • Table Name: Enter a name for the table.
   • Column Names: List all the column names you want to include in the table.

Client Name,Service Type,Feedback Score

7. Add an Apply to each action, and under “Select an output from previous steps,” provide the output of the selected action.

7. Inside the Apply to each action, add the Add a row into a table action (under the Excel Online (Business) connector) and provide the required parameters:
   • Location: Select the SharePoint site from the dropdown.
   • Document Library: Choose the library name from the dropdown.
   • File: Use the dynamic content from the Create file action:
   • Table: Select the table name from the dynamic content.
   • Row: Provide the values for each column, mapping the dynamic content accordingly.

{
  "Client Name": "@{item()?['Client Name']}",
  "Service Type": "@{item()?['Service Type']}",
  "Feedback Score": "@{item()?['Feedback Score']}"
}

8. Now, save the flow -> Click Test (top-right corner) -> Select Manually and click Test again.
9. Click Run flow and wait for execution. After the flow runs successfully, go to the SharePoint document library. Then you can see the Excel file created. When you open the Excel file, you see that the selected column has only been created.

This way, you can export the Dataverse table data to an Excel table using Power Automate.

I hope you found this article helpful.

Related Power Automate tutorials:

• Get Choice Column Value From Dataverse Using Power Automate
• Power Apps Horizontal Navigation Menu Component With Submenu
• Break Permission Inheritance SharePoint Online Using Power Automate
• Power Automate Dataverse Add New Row
• How to work with dataverse formula column
• Get Dataverse Created by in Power Automate
• Update a Row in Dataverse Using Power Automate