Power Automate "Update Item" step for SharePoint should not automatically apply column default values to existing list items
The "Update Item" step automatically retrieves the default value for SharePoint list columns that have default values specified and incorporates them into the step. This can corrupt a list by unintentionally overwriting values that already exist in those columns. It is a highly counter-intuitive behavior for two reasons: 1. it does not make sense to apply default values to existing list items, which may already have different values specified; and 2. the "Update Item" step does not otherwise automatically apply values to columns that do not have default values. In my opinion, "Update Item" should not make changes to fields/columns that are not EXPLICITLY configured by the Flow's author.
100% agree! It is tremendously inefficient having to re-populate every column over and over. An alternative option... add a new "Set Field" action that comes with the SharePoint on create/modify connectors
Steve Walker commented
I nearly destroyed some really important data. At the last minute I asked myself, "wait, is this going to clear the content of all those fields?" and yup, it would have.
And/Or allow the option to update a field without having to specify the value for every other single field in the list.
I would suggest to implement "Add field value" user experience. It could make step settings more clear for understanding the step logic.