SharePoint Document Issues

Fix SharePoint Managed Metadata Missing in Power Automate Get Items

Steve K Oct 10, 2026 870 views

Question details

Users need to resolve an issue where Power Automate fails to retrieve SharePoint managed metadata for certain list items.

How to Fix SharePoint Managed Metadata Missing in Power Automate Get Items

Product: Power Automate and SharePoint
Device & OS: not provided
Scenario: Using the 'Get Items' action in a Power Automate flow to retrieve data from a SharePoint list.
Observed behavior: Managed metadata values appear correctly in the SharePoint list but are completely missing from the Power Automate 'Get Items' output for some specific items.

Before you start

Ensure you have owner or edit permissions for both the Power Automate flow and the SharePoint list to successfully verify configurations and column settings.

Solution 1Recommended

Verify Flow Configuration and SharePoint Source Data

Check if the issue stems from cached flow schemas or discrepancies in how specific users inputted the SharePoint list data.

Power Automate can sometimes fail to pull complex column types like managed metadata if the flow schema is outdated or if the source data contains subtle formatting errors depending on how it was created.

Review SharePoint Column Settings

Navigate to your SharePoint list, click the gear icon to access 'List settings', and verify that the managed metadata column is configured correctly to allow the expected terms.

Compare Successful and Failed Items

Identify an item that returns metadata correctly and one that fails in Power Automate. Check if they were created by different users, via different forms, or using different integration methods.

Refresh Flow Schema

Open your Power Automate flow in edit mode, delete the existing 'Get Items' action, save the flow, and then re-add the 'Get Items' action to force a refresh of the SharePoint column definitions.

Verify Flow Configuration and SharePoint Source Data

Caching delays: Power Automate caches column definitions. Removing and re-adding the SharePoint action is the most effective way to clear this cache and resolve missing field mapping issues.

Solution 2

Consult the Microsoft Power Automate Community

For deeply customized flows or persistent source data anomalies, escalating the issue to community experts is recommended.

Free Microsoft Office alternative

A Seamless, Lightweight Office Alternative for Your Daily Tasks

While Microsoft tools like SharePoint and Power Automate are great for complex automated workflows, your daily document, spreadsheet, and presentation tasks don't need to be heavy or expensive. WPS Office provides a free, lightweight, and incredibly fast alternative that handles standard office files with ease.

1. Download the Installer: Visit the official WPS Office website and download the free installation file for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
3. Open Your Documents: Directly open your existing Microsoft Office files in WPS Office without losing any formatting or data.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly on older or low-spec devices.Familiar, tabbed user interface ensuring zero learning curve for seamless migration.Built-in PDF editing tools combined with powerful document processing capabilities.

microsoft office alternative - wps office

Frequently Asked Questions

Why is managed metadata appearing in SharePoint but missing in Power Automate outputs?

This usually happens due to mismatched schema caches in Power Automate or subtle corruption in the SharePoint source data. It is often tied to how the data was entered, such as through a third-party form versus native SharePoint UI.

Does the 'Get Items' action have limitations with complex SharePoint columns?

Yes. Complex column types like Managed Metadata, Lookups, and Person fields require extra processing. If your SharePoint list exceeds the list view lookup threshold, Power Automate might fail to pull these complex fields in its response.

How do I clear the Power Automate cache for SharePoint columns?

There is no direct 'clear cache' button in Power Automate. The standard method to force a refresh is to delete the SharePoint action from your flow, save it, refresh your browser page, and then insert the action again.

Document & File Issues