How to Get SharePoint List Column Details Using Power Automate? [Internal Name, Display Name, Data Type]

A few weeks ago, I developed a Power Automate flow for a client that used SharePoint lists as data sources. There were ten lists, each with more than 30 fields.

Due to permission issues, the client had to create all the lists and columns manually. To make this easier, I needed to fetch each SharePoint list column’s internal name, display name, and data type into an Excel file so the client could use it as a reference.

After some research, I found two main ways to get this information:

• Use PnP PowerShell, but this requires a Client ID, which is difficult for everyone.
• Using Power Automate with an HTTP request is a simple and easy method.

In this tutorial, I will show you how to use Power Automate to retrieve SharePoint list column details, including Internal Name, Display Name, Data Type, Editable status, and Required field status. I will also tell you how to get SharePoint List GUID manually and using Power Automate.

Get SharePoint List Column Details Using Power Automate

To get this information using Power Automate, you will need:

• Site Address – The URL of your SharePoint site
• SharePoint List GUID – The unique identifier of the list

This is the result after you run the flow.

Now, follow the below steps:

1. Open Power Automate, click on Create, and select Instant cloud flow. Choose the Manually trigger a flow trigger. Then, click + Add an input and add two text inputs:

• SharePoint List GUID – Enter the unique ID of the SharePoint list
• Site Address – Enter the SharePoint site URL

2. Add the Send an HTTP request to SharePoint action to retrieve the SharePoint list details. Provide the action with the following parameters:

• Site Address: Select the SharePoint Site Address from the dynamic content.
• Method: Select GET as the method
• URI: Provide the below URI:

_api/web/lists(guid'@{triggerBody()?['text']}')/fields

• Header: Use the below headers to make REST API calls to SharePoint:

{
  "Accept": "application/json;odata=nometadata"
}

3. Then add a select action and provide the below parameters to extract only the necessary column details from the API response:

• From: Use this expression to get all field details from the previous HTTP request:

@{body('Send_an_HTTP_request_to_SharePoint_|_Get_All_Info')?['value']}

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

{
  "Display Name": @{item()?['Title']},
  "Internal Name": @{item()?['StaticName']},
  "Data Types": @{item()?['TypeDisplayName']},
  "Hidden": @{item()?['Hidden']},
  "Required": @{if(equals(item()?['Required'],true),'Yes','No')},
  "Is Edit": @{if(equals(item()?['ReadOnlyField'],false),'Yes','No')}
}

The Select action is required because the API response contains much data, but we only need specific details like Internal Name, Display Name, Data Type, Editable status, and Required status.

4. Add a Filter array action and provide the below parameters to remove hidden columns and keep only the visible ones:

From: Use the output from the Select action

@{body('Select')}

Filter Query: Use this expression to filter out hidden columns:

@equals(@{item()?['Hidden']},false)

This step is important because SharePoint lists contain system-generated hidden columns that are not needed. Filtering them out helps work only with user-defined columns.

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

This JSON structure is correct for defining an Excel file’s content type and base64 content.

6. Add the Create file action from the OneDrive for Business connector. Set the parameters:

• Folder Path: / (Root folder or specify a subfolder if needed)
• File Name:

SharePoint List Detalis @{formatDateTime(utcNow(),'dd/MM/yyyy HH:MM:ss')}.xlsx

• File Content: Use the output from the Compose action (which contains the file content, such as JSON data or table 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 the OneDrive for Business from the dropdown menu.
• Document Library: Select the OneDrive where the Excel file is stored.
• File: Provide the dynamic content from the Create file action, using Id.

@{outputs('Create_file')?['body/Id']}

• Table Range: Specify the range based on the number of columns you have. For example, if you have seven columns, use A1:G1. 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.

Display Name,Internal Name,Data Types,Is Edit,Required

8. 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.

@{outputs('Create_table')?['body/name']}

• Row: Provide the values for each column, mapping the dynamic content accordingly.

{
  "Display Name": "@{item()?['Display Name']}",
  "Internal Name": "@{item()?['Internal Name']}",
  "Data Types": "@{item()?['Data Types']}",
  "Is Edit": "@{item()?['Is Edit']}",
  "Required": "@{item()?['Required']}"
}

The row values should match the columns you defined in the table:

When you add the value, it may add a for each loop.

Run the Flow to Get SharePoint List Column Details Using Power Automate

Now, save the flow -> Click Test (top-right corner) -> Select Manually and click Test again. -> Enter GUID and SharePoint Site Address in the input fields.

If you know how to retrieve the SharePoint list GUID, then test this flow. If not, check the section below.

Click Run flow and wait for execution. After the flow runs successfully, the Excel file will be created in OneDrive.

Get SharePoint List GUID Manually

• Open SharePoint and navigate to the site where your list is located.
• Open the list whose GUID you want to find.
• Click on the Settings gear icon (top-right corner) and select List settings.
• Look at the browser URL. It will look something like this:

https://yoursharepointsite/_layouts/15/listedit.aspx?List=%7B03bc2abb-1735-46fb-8014-44fa52c872d0%7D

Here, GUID is 03bc2abb-1735-46fb-8014-44fa52c872d0.

Get SharePoint List GUID Using Power Automate

Please refer to the post link below to retrieve a SharePoint list GUID using Power Automate. I have written a complete blog post on this topic.

Generate New GUID in Power Automate

Conclusion

In this tutorial, I showed you how to retrieve SharePoint list column details—including Internal Name, Display Name, Data Type, Editable status, and Required field status—using Power Automate.

I explained how to set up a flow that takes a SharePoint List GUID and Site Address as inputs, makes an HTTP request to fetch column details, filters out hidden columns, and exports the data to an Excel file in OneDrive. I also covered how to manually find a SharePoint list’s GUID and how to retrieve it using Power Automate.

Related Power Automate tutorials:

• Disable Title As Mandatory Field From SharePoint List Using 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
• Send Email Reminders From a SharePoint List Using Power Automate
• Check IF the Date is Weekend in Power Automate