Export Sharepoint List Metadata Using Power Automate

The response of the above step is JSON, so I am adding the "Parse JSON" step. Input for Parse JSON will be the output body of the above HTTP response

I am attaching the Schema.txt to be used for this step.

If you don't want to use this schema, another option is: to save this job before adding the current step (Parse JSON) and run it. From the run history, use the output of the "Send an HTTP request to SharePoint" step and use "Generate from Sample" to generate the schema.

The next step is "Select" from "Data Operation". This step selects the specified properties from all elements of the 'From' array into a new array. We will map each property from the result data of the "Parse JSON" step. To map each property, I am using expression.

Here are all the expressions I used for each property.

Now we are going to filter the output array returned by the "Select" step where "ReadOnlyField" is false. For that, I am using "Filter Array"

This is to eliminate many system default columns of the list and only select the user-defined fields/columns. You can refine the filter by eliminating "Hidden" = true fields as well.

Below screenshot shows the expression being used for the filter and the dynamic value used as input of "Filter Array"

And now, we are going to prepare our output in HTML format by selecting "Create HTML Table"

Input to this step is going to be the "Filter Array" output body. Keeping the columns as "Automatic". This will select all the properties from the Body.

If you want to select specific properties, you can do this by defining the "Custom" Columns like below. In Columns - select Custom, then define each field mapping by defining expression like "item()?['Title']"

For now, I am going to keep Columns as "Automatic" only.

Then, I am going to append this HTML in the string that we initialized at the top, which will be holding the metadata of multiple lists (each given by this Create HTML Table step)

Here is the Value being selected : <h1>@{items('Apply_to_each')?['DisplayName']}</h1>@{body('Create_HTML_table')}</br>

I have added the name of the list by selecting dynamic property "items('Apply_to_each')?['DisplayName']" and added a few HTML tags to add little formatting here.

• Finally, I am going to use "Compose" outside of "Apply to each" to copy the final value of the variable "ListMetaData".
  
• Tada... Your flow is ready. Save this flow, and run it. Open run history, and copy the output from Compose like below.
  

You can save it in an HTML, and here is how html looks in the browser. The bottom list is the one we created with the Description when we started with the article.

If you don't like the idea of copying the output manually, you could also add another step to copy this variable to a file and save that file to SharePoint.

Summary

In this article, we learned many concepts of power automate, like, getting SharePoint lists, invoking Sharepoint APIs, using variables, using parse JSON (which is very handy in power automate), filtering arrays, etc.

For this small list I created, this may look like a tedious job to create the power automate. However, this can help when you have a huge set of fields in each list and there are many lists on site. This can become very handy at that time.

Do let me know your thoughts and suggestions in the comments. I am new to power automate, so I am sure there will be many improvements possible. Please let me know if you found this article helpful and, if not, your suggestions to improve the same.