power-automatepowerappspowerapps-canvasdataversepower-platform

Bulk Update a field in Dataverse table


I have a dataverse table having a datetime field . Now I have existing data in the field around 50k records. Now I need to make update to all the rows of that field, which is basically I need to adjust the time and subtract 4 hours from the existing date time data for all the rows. Is there a way I can acheive that in dataverse, using some bulk update or anything like that?


Solution

  • To perform a bulk update on a Dataverse table where you need to adjust the datetime field by subtracting 4 hours from the existing data in all rows (around 50,000 records), using a Dataflow is a more suitable option than Power Automate. Here's why:

    1. Efficiency: Dataflows handle large data volumes more efficiently than Power Automate, which may struggle with high record counts.
    2. Performance: Optimized for bulk operations, Dataflows perform large-scale data manipulations quickly.
    3. Integration: Dataflows integrate seamlessly with Dataverse

    In contrast, using Power Automate for the same task would:

    1. Take a very long time to process
    2. Require implementing paging, as the "for-each" loop is limited to 5,000 records per batch.

    More information about dataflow here: https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365