Others

Fix Power Automate Update Item Action Fails Intermittently

Camila MilosovichCamila Milosovich Oct 22, 2026 868 views

Question details

The user needs to fix a scheduled Power Automate flow where the action to update a SharePoint item fails sporadically.

How to Fix Power Automate Update Item Action Intermittent Failures
Product
Power Automate
Device & OS
not provided
Scenario
Running a frequently scheduled flow to update SharePoint list items containing Choice and Person fields.
Observed behavior
The 'Update item' action works sometimes but fails intermittently, seemingly due to connector cache issues or improper mapping of Choice and Person fields.
Before you start

Ensure your SharePoint list permissions are fully active and that the account running the flow has editing rights for the target list.

Solution 1Recommended

Recreate the Update Item Action and Map Value Properties

Clearing the connector cache by recreating the action and correctly mapping the 'Value' property of Choice columns usually resolves sporadic update errors.

Intermittent flow failures are often caused by a corrupt connector cache or passing an entire object to a SharePoint column instead of just the required string value. Rebuilding the step guarantees a fresh connection.

1
Delete the existing action

In your Power Automate flow editor, locate the failing 'Update item' action, click the three dots (ellipsis) in the upper right corner of the action box, and select 'Delete'.

2
Clear browser and connector cache

Save your flow, sign out of Power Automate, clear your web browser's cache, and sign back in to refresh the SharePoint connector.

3
Re-add the Update item action

Click 'New step', search for 'Update item' under the SharePoint connector, and add it back into your flow sequence.

4
Select the Choice Value property

When mapping dynamic content to your Choice columns, ensure you select the '[Column Name] Value' property from the dynamic content list, rather than just the base column name.

5
Verify Person fields

For fields like 'Assigned to' or 'Issue Logged by', confirm that you are passing a valid user profile email address or exact Claims ID.

Recreate the Update Item Action and Map Value Properties
Test the Flow: Run a manual test after saving the rebuilt action to confirm that the flow now runs consistently without intermittent errors.
Free Microsoft Office alternative

Looking for a Lightweight Alternative for Daily Office Tasks?

While Power Automate handles complex Microsoft ecosystem workflows, day-to-step document editing doesn't have to be complicated. WPS Office provides a free, lightweight, and incredibly fast alternative to traditional office suites, fully supporting your Word, Excel, and PowerPoint files.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Open Microsoft Formats: Launch WPS Office and directly open any existing Word, Excel, or PowerPoint files without needing conversion.
  3. 3. Edit and Save Seamlessly: Edit your documents using the familiar toolbar and save them in their original Microsoft formats to share with others.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Free and lightweight, consuming minimal system resources.Familiar user interface requiring zero learning curve.Built-in PDF editing tools for comprehensive document management.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate SharePoint flow fail intermittently?

Intermittent failures are commonly caused by connector caching glitches, SharePoint throttling limits (especially if updating items as frequently as every minute), or subtle data mismatches in Choice or Person fields.

What is the difference between a Choice column name and its Value in Power Automate?

The Choice column name represents a complex metadata object, whereas the 'Value' property extracts the actual text string you selected. Mapping just the name often sends the entire object to SharePoint, which triggers a flow error.

How do I correctly map a Person field in an Update item action?

When updating a Person field, you must provide the precise identifier for the user. It is recommended to use the user's primary email address or their specific Claims ID from the dynamic content to ensure successful mapping.