Daily Dataverse Tables Backup using Power Automate

 Use Case 

To automatically export Dataverse Custom Tables daily to Excel and save those backups versions in OneDrive. Those tables include Lookup columns and Choices columns. We will use those backups as a second backup in addition to the Power Platform Environment system backups. In case of Data Loss, or Corruption, we can Bulk Delete the Dataverse Tables records and use Dataflows to load the data from the Backup Excel Files.

Create The Table In Microsoft Dataverse 

    

                                                                                                                                                                                                                               

Data

In this blog, we are only going to create a scheduled backup for one table in Dataverse, and it's called RavindraTable. 

Power Automate Scheduled Cloud Flow:

tart by creating a Power Automate Scheduled Cloud Flow in the same Dataverse Environment. Our first Action will be the Recurrence Action and we will set it up for the Interval property, we will select ONE and for the frequency, we will select Day (To Run Daily). The start time is for the flow first start and you can test the flow during the design by running manual tests. The next action after the Recurrence will be the Dataverse List Rows Action.

In the Dataverse List Rows Action, we will select the table name and in our case, we are using the RavindraTable table from the 

Create CSV Table

Create Folder In Onedrive In My case whiteboard

Run The Flow

Check File In One Drive...

Once we have customized the Create CSV table Action, below is the result that we are looking for and can be used easily if needed to reload the data into the Dataverse Order Items table. 

✨ Thanks for reading! ✨

I hope you found this blog on the Microsoft Power Platform helpful! From Power Apps, Power Automate (Cloud & Desktop), Canvas Apps, Model-driven Apps, Power BI, Power Pages, SharePoint, Dynamics 365 (D365), Azure, and more, I cover a wide range of topics to help you harness these powerful tools. Don’t miss out on future tips, tutorials, and insights—hit that subscribe button to get the latest posts right to your inbox. 💌

💬 I’d love to hear your thoughts! Drop a comment below with your questions, ideas, or feedback—let’s get the conversation started!

🔗 Let’s connect and grow together!
Follow me, Ravindra Jadhav, on your favorite platforms for even more content and updates on Microsoft Power Platform and related technologies:

• 💼 LinkedIn – Let’s network and share ideas!
• 💻 GitHub – Explore my projects and code.
• 🐦 Twitter – Stay updated with quick tips and industry news.
• 📺 YouTube – Watch tutorials and deep dives on Power Platform, Power Apps, Power Automate, and more!

Let’s build something amazing together with Power Platform and Azure! 🚀