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?
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:
In contrast, using Power Automate for the same task would:
More information about dataflow here: https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365