cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JenniferHayes
Level: Powered On

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
Community Support Team
Community Support Team

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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 80 members 3,704 guests
Please welcome our newest community members: