Power Automate flow update to sharepoint list, but does not retain updates

(2) Share

Report

Posted on by RE-27081413-0

I have a flow, that when manually triggered, initializes variables, gets items from the destination sharepoint list. Destination was created from two sharepoint lists A and B exported to excel and combined and then imported to create a new sharepoint list (Destination). Whereas list A and B , ID became Legacyid and Created became Origin for the purpose of retaining historical data as new ID's were assigned upon import. List A and B power automate flow was updated to add update items to the destination list. Those updates are working well.

The destination flow "get items" retrieves the LegacyID, use that field to "gets item" from List A or B, Then updates destination.

This all works well and I see the results as expected, however when sharepoint destination list is refreshed, none of the power automate updates are retained? I'm at a loss?

Please advise thank you

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (1)

Report

Hi,

Ensure that the account running the Power Automate flow has the necessary permissions to update the SharePoint list, also if versioning is enabled on your SharePoint list, ensure that the updates are being saved as new versions.
Sometimes, updates might not appear if versioning settings are misconfigured.

Create a simple test flow that updates a single item in the destination list to see if the update is retained.

This can help isolate whether the issue is with the flow logic or the SharePoint list itself.

Hope this helps.

Anthony.

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report

Check the version history of the item in the Destination list after an update to see if anything actually happened. You might have a sort of race condition somewhere in which the item is updated with the values that existed before, maybe in another flow. The version history should tell you if that is happening.

Was this reply helpful? Yes No
RE-27081413-0 6 on at

Like (1)

Report

Thank you.

I have full access as owner, with the SharePoint and now begs the question how to "Ensure that the account running the Power Automate flow has the necessary permissions" a little help there to verify?

The whole versioning thing is a bit of a mystery on this end. I have never been able to find it, wondering if the site architect turned it off from the beginning of time or I'm just an idiot? My right click yields:

and versioning yields:

Gentlemen, I sincerely appreciate the guidance!

Was this reply helpful? Yes No