cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Sharepoint Update Item Wipes Out Pre-Existing Data In Fields Not Being Updated

I am using Sharepoint Update item to update a handful of fields in a sharepoint list item when a new item is created.   New items are created with up to 10 fields populated.   The update item flow correctly adds the specified fields but in the process wipes out the contents of any fields left blank on the update item form.   Flow should ignore any fields that do not have an update value specified, but instead updates each field to an empty text string.   For example if an address has been populated in the list but address field left blank in the Update Item action, the address field gets updated to empty text.   Looking at the code behind the form I see "Address1":"",  which seems to explain why the contents of the address field is being replaced by "".   But it makes no sense that this would be a default for every field in the Sharepoint Update Item form.   Empty fields should be ignored by default, not updated to empty strings or null.

5 REPLIES 5
Community Support
Community Support

 

Hi @djroller ,

 

Could you please share a screenshot of the Flow configuration?

The feature expected by the Update item action is exactly the same as your description. It only updates the fields of the content you configured, and other fields are not updated.

 

Do not change/fill the fields that do not need to be changed when configuring the Update item action.

Or please try to fill the field with the Dynamic content of the corresponding field output in the trigger, which could also avoid the situation you mentioned.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Flow.PNG

 

Hi Barry,

See below for flow and explanation of what is happening.    The second alternative you mentioned -- updating all fields with dynamic content of same, does work, but seems strange to have to specify an update action for fields I don't want to update.   Hard to imagine that is how this is intended to work.   IF it is, it should be documented because it's not at all intuitive.   The other thing is, there seems to be no way to recover data wiped out  in this manner unless you have list versioning turned on.   

 

Another solution I came across today is to create a custom view of just the fields I want updated, and then select advanced options and specify the view.  This limits the patched columns to just those I want to update.   But again, a very clumsy solution.   If I need to create a custom view every time I want to use flow to update certain fields in a list, that's very cumbersome.   Again, if this is the intent, the documentation should state this and also the danger of not doing it.   If you don't create a custom view, or if you don't specify an update action for the fields you want to keep, you will lose data if you leave fields blank.   Or, at least that is my experience.

 

To help isolate this issue, I've noticed the behavior happening only when an existing Update Item action is modified. When setting the Update Item up initially it appears to work as intended. If you then modify that action, or use the clipboard to copy/paste the action elsewhere, it will exhibit the behavior in OP's description. 

 

A workaround (very frustrating workaround) I've found is to insert dummy data into ALL fields in the action, save and close the flow, re-open and remove the dummy data, save again. I've taken to creating a specific view in my lists just for my flow to reference because in most cases I'm only updating a couple of fields out of many more. This makes the workaround quicker to process but still annoying.

New Member

I just discovered a better solution after getting frustrated with this same issue!! My flow kept wiping out previous values on fields and resetting my 'task status' back to new.

 

Go to the "update item" that's having the issue, click the "..." menu and go to "peek code", it will show you which fields it's wiping out/overriding. So if any fields are listed in the body of the "peek code" that you don't want updated/wiped/cleared out, just exit the "peek code" view (click done) and clear them out in the "update item" box. After you've deleted/erased the fields you don't want updated, go back to the "peek code" view to verify that they're no longer listed. I found this a much easier solution than writing gibberish in every field, saving, then clearing it out, especially when you have a lot of fields!

 

ex of what to look for in "peek code":

{
    "inputs": {
        "host": {
            "connection": {
                "name""@parameters('$connections')['shared_sharepointonline']['connectionId']"
            }
        },
        "method""patch",
        "body": {
            "Title""@triggerBody()?['Title']",
            "Current_x0020_Status""Completed without Routing",
            "BR_x0020_First_x0020_Completed""@{formatDateTime(utcNow(), 'MM/dd/yyyy')}"

Thanks for sharing your "peek code" solution.   I will definitely give that a try.

Another solution that seems to work well is to create a special list view that only contains the fields I want to update.  Then in the flow, instead of just selecting the list, I click advanced options and select the special view of the list I created for the flow operation.   This seemed to preserve the integrity of all fields that were excluded from the view.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (35,587)