Daily Dataverse Tables Backup using Power Automate In SharePoint

 

 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 

Apply to each value in dataverse And Get Items From SharePoint


Apply condition in Loop
Put Expresson= length(outputs('Get_items')?['body/value']) is not equal to 0

For Yes Value Apply to each value Of SharePoint  Update Item

For NO



Thank You ! Run the Flow Now....

✨ 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! 🚀




Comments

Post a Comment

Popular posts from this blog

Display Dataverse Table Data In Power Pages by Using liquid Language

 Display Dataverse Table Data In Power Pages by Using liquid Language Display Dataverse Table Data In Power Pages by Using liquid Language CSS CODE:   /* styles.css */ /* Apply basic styles to the outer container */ .col-md-12.columnBlockLayout {     padding : 16px ;     margin : 60px 0 ;     min-height : 200px ;     background-color : #f5f5f5 ;     border : 1px solid #ddd ;     border-radius : 5px ; } /* Style the table */ .table {     width : 100% ;     border-collapse : collapse ;     background-color : #fff ; } /* Style the table header */ .table th {     background-color : #007bff ;     color : #fff ;     text-align : left ;     padding : 10px ; } /* Style the table rows */ .table td , .table th {     border : 1px solid #ddd ;     padding : 8px ; } /* Apply alternate row background color for better readability */ .table tbody tr:nth-child (even) {     background-color : #f2f2f2 ; } /* Style the button within the table cell */ .table button {     background-color :
Read more

Public Preview of Column-Level Security for Masking Sensitive Data

Image
  Public Preview of Column-Level Security for Masking Sensitive Data Data Masking in Customer Interactions: Key Points Overview : Data masking (also known as de-identification or obfuscation) protects sensitive information by replacing it with masked strings. This ensures that only authorized users can view the original data, while unauthorized users see the masked version. Purpose : Helps prevent exposure of sensitive information such as credit card numbers and social security numbers during customer interactions. Preview Feature : This is a preview feature, meaning it is available for early access and feedback but isn't intended for production use. May have restricted functionality compared to the final release. How Masking Works : Masking Rules : Define how data should be masked using regular expressions to identify patterns like credit card numbers or email addresses. Rules Setup : Create a solution in Power Apps. Add components and select "Secured masking rule" from
Read more

Fetch XML For Dataverse Table

Image
 Fetch XML For Dataverse Table In D365 & Power Apps Youtube Video Link   Step 1 1. Click On Gear Icon 2. Go to the Advanced Setting In Power Apps Or In D365 3.  Click on Advanced Find.          New Window Will Pop-Up. 4.  Select The Table As Shown. 5.  Click On Download Fetch XML. Thank You Everyone. Keep Learning  Keep Growing Keep Exploring ✨ 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 Jad
Read more