cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JenniferHayes
Frequent Visitor

Getting data to copy/update across to SharePoint Lists

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? 

1 REPLY 1
v-yamao-msft
Community Support
Community Support

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.

1.PNG2.PNG

Please take a try with it on your side.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,624)