Power Platform Community Forum Thread Details

I have built a project tracker in SharePoint online to track 5 different planners and their construction schedules. For each planner I have built them their own individual view on the list so they can arrange the information how they'd like.

The 5th planner has a significant amount more information to track than the others, about 10 extra columns. I thought the best way to do this and not create all the extra columns in the 'Master Project Tracker' was to build him his own tracking list and set up a flow to update the lines in the 'Master Project Tracker' anytime he adjusts or adds a new project into it ('David's Project Tracker').

Is this the best way to go about doing this? If so, how should I set up my Flow?

Categories:

Building flows

Hi @JenniferHayes,

Would you like to create/update item in the master list when an item is added/modified in the child list?

Could you share more details on “project tracker”? I assume that they are custom SharePoint lists.

So I have made the following flow for your reference.

Add the trigger When an item is created or modified, select the list for one planner.

Initialize variable, set it Name to Title, type to Array.

Get items from the master list, here I am using a list called Total.

Add an Apply to each, select value from Get items, add action Append to array variable within the Apply to each, select Name “Title”, and dynamic content “Title” for Value field.

Under Apply to each add a Condition to check if the variable Title contains Title from the trigger:

@contains(variables('Title'), triggerBody()?['Title'])

Under If yes branch, add Condition2 to filter out the item in Total list which has the same title with the Trigger using the following code. Then Update item under If yes branch to update corresponding value from the child list to master list.

@equals(items('Apply_to_each_2')?['Title'], triggerBody()?['Title'])

Under If no branch, create item in the Total list with action Create item.

Please take a try with it on your side.

Best regards,

Mabel

Community site session details

Getting data to copy/update across to SharePoint Lists

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates