cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Getting data to copy/update across to SharePoint Lists

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
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (11,062)