In this post I will share with you the steps to export all file / list item details from SharePoint Online using Power Automate. Using this approach you can get details about each and every file / list item from SharePoint. The end result will look something like below.
# Prerequisites
You need the following to follow along this post
- A SharePoint site
- Power Automate license(O365 E3 is preferable, F3 would do the job as well)
Related Topic
What is Microsoft Power Automate
# Concept
There is a main concept for this post is that, everything in SharePoint(i.e. whatever you can see in Site contents page) is considered as a list. In other words document libraries, site page libraries, calendars etc. everything is considered as a list in SharePoint. We will use this list concept to fetch the details from a site.
# Logical Diagram
Related Topic
What is Sign-off in SharePoint? How to use it?
Write to influence. 7 Proven Tips to improve your writing skill.
# Solution – Power Automate
The basic design of the flow is as shown below
Explanation for each of the above points are as below
Many action blocs are renamed to improve management lifecycle of the flow
- The flow is triggered manually(You can choose any trigger method of your choice)
- Initializing a variable to store the SharePoint URL(make sure the url ends with ‘/’). Using a variable is better design approach, as it will allow you to quickly apply this flow to another site.
- Initializing a variable to store the end results(i.e. all list items)
- Sending a REST API Get request to retrieve all the list details from. The response shows how to result will look when you run the flow. When designing the Power Automate flow make sure your HTTP request action resembles as below
URI: _api/web/lists
Query: ?$select=Hidden,Title,Id&$filter=Hidden eq false
- Apply to each – loop through all the lists received in the previous step and then fetch all the items from them.
- Send email with the fetched details
That’s all, if you now run the flow you will receive the results as shown below. To verify the results, compare the items count with the site contents image above(or below)
Related Topic
Master OneDrive troubleshooting as IT Admin
Outlook vs SharePoint Calendar. How to choose?
Please Help us Grow!
I hope you have found this article helpful. If you are happy with the document, please use the below links when you buy something from Amazon to help us grow.
Ways to Help
Amazon Affiliate Links
How this works?
Amazon affiliate program gives a small (%)share of price to the referrers, so feel free to buy anything.
Below are some Amazon affiliate links, if you open amazon application/website using these links and buy something, (it can be one of the below items or anything of your choice) Then Amazon will give us a little percentage(%) of the money you spend on Amazon. To know more check this document.
Thank you
For your Contribution
Newbietechie.com
Author @ramizmollahmd
About Ramiz
Ramiz is a professional working in an MNC as a business and technology consultant for quite a few years now. Ramiz is proficient in various Microsoft tools and technologies. He is a tech enthusiast and an active blogger. Ramiz spends his free time playing games or watching movies. He writes blogs to share his knowledge with the world and to make it a better place to live.
