Answered

Creating a flow to update a child sharepoint list from a parent list and a form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My AttemptI am trying to build 2 lists, a parent that is populated from a form, and a child that is populated from the parent list. I have a working flow that moves the form answers into the parent table (I could use this to also populate the child table, but assumed this would stop me being able to update the child based on editing the parent)

I need the child list to update if it meets a condition and if

a) a new entry is made into the parent list from the form

b) the parent list is manually edited

The columns I have are: Name, Project, Stakeholder, Key Message. The condition is based on the project field (ultimately I will produce more of the flows once I have the first one set up). I tried creating ID fields but got confused!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

As I understand, you are trying to create/update a child record after a parent record is created/ modified. You already have a flow that runs to create the Parent record and you wnat to create another one for the child records. If i am right so far, please refer to the flow below:
Here, I have a parent list - Exchange Rate and a child List Database and both of these lists have a Project column. The trigger is when an item in the parent list is created or modified, the next action is to filter and get the items from the child that have the same project. I then used a condition to check if that is null and if it is not then we update the child items and if it is then we create new item in the child list.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to create/update a child list according to its parent list, if the item already exists, update it, otherwise, create a new one.

Please check if the following flow will work for you.

In my scenario, List11 is the parent list, and List 33 is the child list.

Add trigger When an item is created or modified in List11.

Initialize an array variable named as Childitems.

Get items from List 33.

Add Apply to each, select value from action Get items. Add action Append to array variable, name set as Childitems, value set as Title from list33.

Add condition to check if the variable contains the trigger title.

If yes, which means that the item is existing. Add Condition2 to find out the specific one, if they have the same title, update the exiting item.

If no, which means that the item is new. Add action Create item to create new one.

Screenshots of the flow for your reference:

Best regards,

Mabel

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

Like (0)

Report
Copy link

Link copied!

Thanks for your response, this didn't work however, probably as I didn't explain the set-up properly! I get an error saying that there is no column name = to the project name. (Sorry I can't post another screenshot but working in locked down environment).

Also I am going to slightly change my question as it would make more sense for the childs to update the parent once the line item has been created.

So in short -
- form creates item in parent > Parent creates item in relevant child (project dependent - see below)
- Any modification to items in child(ren) will update item in parent

So the parent list will only need to create child items, but in such a manner that it can be linked back and reflect modifications to the child(ren) tables

Tell me if I'm asking too much (or making no sense)! I imagine this would require 2 seperate flows! Really appreciate the help

Parent
Name - Project - Stakeholder etc.
Joe Bloggs - Project A - Tim
Mark - Project B - Chris

I want multiple childs that will only be for each project i.e.

Child 1
Name - Project - Stakeholder
Joe Bloggs - Project A - Tim

Child 2
Name - Project - Stakeholder etc.
Mark - Project B - Chris

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

Like (0)

Report
Copy link

Link copied!

So building on my last post - I have now got to here:

1 - I am updating both the Parent and Child in the first flow based on some conditions
2 - I am updating the parent based on modifying the child however it is modifying each entry in the parent. I.e. If i change the entry in'Type of Engagement' in the child table for item 14, it changes the type of engagement in the parent for all of the entries

1 - Create2 - Modify

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

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Thanks for updating.

If you want to update the parent list when child list is modified, just use Child list in the trigger “When an item is created or modified”, then update the corresponding item in Parent list.

Besides, I assume that there should be a common value between Parent list and Child list, which could be used to check whether the modified child item exists in the parent list.

Please take a try with the flow configuration I provided, it should work for your scenario. You could remove the Create item part from the flow in your scenario.

Best regards,

Mabel

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

Like (0)

Report
Copy link

Link copied!

Thanks - I have had to keep the create in seperately as I need the form responses to populate, but the modifying is working!

I am slightly concerned that I get a 'False' Expression Result from the Second condition - this means the Update item field is giving me an 'ActionBranchingConditionNotSatisfied'

However this looks to just be a glitch as the update is worked in my test table.

Thanks so much for the flow
@v-yamao-msft wrote:
Hi @Anonymous ,

Thanks for updating.

If you want to update the parent list when child list is modified, just use Child list in the trigger “When an item is created or modified”, then update the corresponding item in Parent list.

Besides, I assume that there should be a common value between Parent list and Child list, which could be used to check whether the modified child item exists in the parent list.

Please take a try with the flow configuration I provided, it should work for your scenario. You could remove the Create item part from the flow in your scenario.

Best regards,
Mabel

Was this reply helpful? Yes No