How to update a task list item in a master task list when a task is updated in child task list

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have two subsites created under root as : Subsite A and Subsite B.

Subsite A has SP task list (OOTB) created as Task List A, similarly Subsite B has task List B created.

On root site, I have a task list created as "Master Task List". Also I have a flow attached to Task List A and Task List B that triggers when a task is created in these task list and it adds these newly added items to the Master Task List.

Now another flow I am trying to implement is: For example let's say if a task is maked as Completed in Task List A then I would also like to update the master task list. So in theory whichever task is completed in Task List A, flow should catch that and update this change for the same task in the master task list. I guess unique identifier here would be Task name, not sure how it will work though. Can someone please help me with the flow for this.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Re: How to update a task list item in a master task list when a task is updated in child task list

Hi @Anonymous，

Do you want to update a task in the Master Task list on Root site when the corresponding task on sub-site is marked as Completed?

I have made the following test for your reference which will be used to create/update items from sub-site to root site.

It is triggered by When an item is created or modified. Enter the correct sub-site URL in the Site Address field, and the Task name in the List Name field.

Add the action Initialize variable. Set its name as Tasks, Type as Array.

Get items from the master list on Root site.

Add an Apply to each, get value from the action Get items. Add the action Append to array variable within Apply to each. Select “Tasks” for Name field and dynamic content “Task Name” for Value field.

Under Apply to each, add a Condition to check if the variable Tasks contains the Task Name from the trigger.

Under If yes branch, add Condition2 to check if the dynamic content Task Name from action Get rows is equal to dynamic content Task Name from the trigger. if yes, update the corresponding task with the Task Status Value selected from the trigger.

Under If no branch, add action Create item to create the new task on the master task list on root site.

Images for your reference:

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to update a task list item in a master task list when a task is updated in child task list

@v-yamao-msft thanks Mabel for the solution. This will work for one child list and one parent list. However in my case, I have 4 task lists located on different sub sites and then one master list on parent site. How would it work then?

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Re: How to update a task list item in a master task list when a task is updated in child task list

Hi @Anonymous,

You may need to create four flows for each task list with the same configuration.

Please take a try with it on your side.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to update a task list item in a master task list when a task is updated in child task list

Yes I have done that to test but it won't work.

First, I have separate flows attached to all of these child lists that brings tasks over to the parent list when a task is created in any of the child lists. Although when it comes to editing the task in parent list when its marked as completed, the ID of the task in child list differs from ID in parent list and hence flow cannot update status of that task in parent list, that's the limitation I am seeing.

Was this reply helpful? Yes No