SOLVED

Automatically created child

%3CLINGO-SUB%20id%3D%22lingo-sub-3072747%22%20slang%3D%22en-US%22%3EAutomatically%20updated%20child%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072747%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20suggestions%20on%20how%20to%20create%20a%20child%20item%2C%20in%20a%20child%20list%2C%20from%20the%20parent%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20have%20a%20list%20of%20items%20(issues%20to%20track)%2C%20with%20a%20link%20to%20a%20child%20list%20to%20keep%20track%20of%20updates%20for%20the%20parent%20item%2C%20but%20by%20the%20time%20the%20parent%20is%20created%2C%20the%20child%2C%20and%20I%20don't%20know%20how%20to%20work%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20a%20given%20parent%20item%20may%20have%20many%20different%20updates%20(children)%2C%20I%20need%20to%20have%20the%20parent%20item%20in%20the%20parent%20list%2C%20linked%20to%20the%20many%20items%20in%20the%20child%20list.%20The%20challenge%20I%20have%20is%20that%20by%20the%20time%20I%20create%20the%20parent%20item%2C%20the%20child%20item%20doesn't%20exist%2C%20and%20I%20need%20to%20create%20it%20automatically%20so%20that%20users%20can%20go%20(say%20a%20few%20days%20later)%20and%20enter%20updates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20use%20a%20field%20with%20%22Multiple%20lines%20of%20text%22%20in%20SP%20and%20view%20the%20entries%2C%20but%20I%20need%20to%20pull%20the%20data%20from%20a%20database%20and%20the%20field%20with%20%22Multiple%20lines%20of%20text%22%20doesn't%20work%20in%20the%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ELeo%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello

 

Do you have any suggestions on how to create a child item, in a child list, from the parent list?

 

I'd like to have a list of items (issues to track), with a link to a child list to keep track of updates for the parent item, but by the time the parent is created, the child, and I don't know how to work it out.

 

Because a given parent item may have many different updates (children), I need to have the parent item in the parent list, linked to the many items in the child list. The challenge I have is that by the time I create the parent item, the child item doesn't exist, and I need to create it automatically so that users can go (say a few days later) and enter updates.

 

I know I can use a field with "Multiple lines of text" in SP and view the entries, but I need to pull the data from a database and the field with "Multiple lines of text" doesn't work in the database.

 

Thank you

Leo

 

3 Replies
best response confirmed by Leonel GUZMAN (Contributor)
Solution

@Leonel GUZMAN I don't think you can achieve this with SharePoint on its own, you need to look at doing this with a flow in Power Automate. It would create the "child" item in the separate list when the parent item is created, and you'd need a ParentID column in the child list for the ID of the parent to be populated. Then when the parent is updated it can update the child based on a filter query on the ParentID column eq ID.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@Leonel GUZMAN If using PowerApps is an option, @Admin Reza Dorrani has an excellent tutorial on related lists that may be helpful to you. 

Thank you all

 

Yes, PowerAutomate is the way to go.

 

Leo