Export SharePoint List items to Excel Using Power Automate

A few days ago, I was working with a client who needed to export SharePoint list items to Excel. To meet their immediate need, I created an instant cloud flow (button flow) that allowed them to export the data at any time.

In this tutorial, I will show how to export SharePoint list items to Excel using Power Automate with an example.

Export SharePoint List Items Selected Columns to Excel

For this example, I created a SharePoint list called Task Tracker, which contains over 50 items. This list is used to manage tasks within a team and includes the following columns:

Column Name	Data Type
Title	Single line of text
Description	Multiple lines of text
Assigned To	Person or Group
Due Date	Date and Time
Priority	Choice (Low, Medium, High)
Status	Choice (Not Started, In Progress, Done)

Follow the steps below:

1. Open Power Automate, click Create, and select Instant cloud flow. Choose ‘Manually trigger a flow’ as the trigger.

2. Next, add a Get items action to retrieve all SharePoint list items and provide the following parameter:
   • Site Address: Select the site address where the Task Tracker SharePoint List is present.
   • List Name: Choose the Task Tracker list.

NOTE:

In my case, the Task Tracker list has only around 50 items, so the standard “Get items” action works just fine. However, if you’re working with a large dataset (more than 5000 items), you have two better options to make sure all items are retrieved:

• Option 1: Use REST API with Pagination
• Option 2: Enable Pagination in “Get items” -> Click on the Settings (⚙️) of the Get items step. Enable Pagination. Provide a high Threshold value (5000 or more, depending on your list size)

If you don’t want to retrieve all items and only need to export specific records, you have a couple of great options in Power Automate:

• Option 1: Use OData Filter Query
• Option 2: Use Filter Array

3. Then add a select action and provide the below parameters to extract only the necessary column details from Get items:
   • From: Use this expression to get all field details from the previous Get items action:

@{outputs('Get_items')?['body/value']}

4. Click the T (Text mode) icon and define the structure to extract key column details. Use the following JSON mapping:

{
  "Title": @{item()?['Title']},
  "Description": @{item()?['Description']},
  "Assigned To": @{item()?['AssignedTo/DisplayName']},
  "Due Date": @{formatDateTime(item()?['DueDate'],'dd/MM/yyyy')},
  "Priority": @{item()?['Priority/Value']},
  "Status": @{item()?['Status/Value']}
}

5. 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="
}

6. Add the Create file action from the SharePoint connector. Set the parameters:

• Site Address: Select the Site Address where you want to store the Excel file.
• Folder Path: Choose the Library name.
• File Name: Name of the Excel file (SharePoint List Details @{formatDateTime(utcNow(),’dd/MM/yyyy HH:MM:ss’)}.xlsx)
• File Content: Use the output from the Compose action (which contains the Excel file content, such as JSON data).

7. Now, let’s create an Excel table. Click the + icon to add the Create table action (under the Excel Online (Business) connector) and provide the following parameters:
   • Location: Select 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 the number of columns you have. For example, if you have six columns, use A1:F1. 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.

Title,Description,Assigned To,Due Date,Priority,Status

8. Add an “Apply to each” action. In the Select an output from previous steps field, choose the output from the Select action you added earlier. This will loop through each item in the array of formatted SharePoint data, allowing you to process and add each row to the Excel file.

@{body('Select')}

9. Now, let’s add a row to the table. Click the + icon to add the Add a row into a table action (under the Excel Online (Business) connector) and provide the required parameters:
   • Location: Select OneDrive for Business.
   • Document Library: Choose OneDrive as the document library.
   • File: Use the dynamic content from the Create file action (@{outputs(‘Create_file’)?[‘body/Id’]})
   • Table: Select the table name from the dynamic content.
   • Row: Provide the values for each column, mapping the dynamic content accordingly.

{
  "Title": "@{item()?['Title']}",
  "Description": "@{item()?['Description']}",
  "Assigned To": "@{item()?['Assigned To']}",
  "Due Date": "@{item()?['Due Date']}",
  "Priority": "@{item()?['Priority']}",
  "Status": "@{item()?['Status']}"
}

Now, save the flow -> Click Test (top-right corner) -> Select Manually and click Test again. Once the flow runs successfully, go to your SharePoint document library, and you will see that the Excel file has been created with all the list data included.

This way, you can export only the selected columns from your SharePoint list to Excel.

Using Power Automate, you can easily export selected columns from a SharePoint list to an Excel file with just the click of a button.

I hope you found this article helpful.

Related Power Automate tutorials:

• Disable Title As Mandatory Field From SharePoint List Using Power Automate
• Append Multiple Values to An Array in Power Automate
• Rename SharePoint List Using Power Automate
• Check if SharePoint List Already Exists in Power Automate
• Get and Delete a SharePoint list view using Power Automate