Hello everyone,
I'm working on a project in SharePoint where I need to create a master list that automatically tracks and syncs entries from five different sub-lists. The goal is for the master list to reflect any new entries or updates made in the sub-lists. When a new item is created or modified in any of the sub-lists, a corresponding entry should be created or updated in the master list using Power Automate.
I've followed the steps from this video to set up a flow for syncing one of the lists, and I’ve tried to extend this to cover all five sub-lists. Here’s what I have configured so far:
- A trigger for "When an item is created or modified" in each sub-list.
- An action to retrieve items from the master list and check if an entry with the same unique identifier (like the item title or ID) already exists.
- A condition to either create a new item in the master list or update an existing one based on whether the item is found.
While the flow appears to be set up correctly and shows as successfully executed in Power Automate, nothing actually happens in the master list. Even when new entries are created or updates are made in the sub-lists, no corresponding changes appear in the master list, and no new items are created.
Here are my main questions:
- Has anyone encountered a similar issue where the flow runs successfully but doesn’t perform the intended actions in the destination list?
- Could there be a problem with the conditions or actions used in the flow, even if it shows as successful?
- Are there specific troubleshooting steps to ensure that updates and new entries are reliably synced between multiple sub-lists and a master list in SharePoint?
Any insights or suggestions on how to resolve this would be greatly appreciated!
Thank you!
