Posts

Showing posts from January, 2023

Daily Dataverse Tables Backup using Power Automate In SharePoint

Image
   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

Daily Dataverse Tables Backup using Power Automate

Image
 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 Dataver