Generate unique ID in child list based on ID in parent list

In parent list, create a hidden field which keeps track of the number of children. (childCount)

When a child gets created, increment the childCount field of the parent by 1, write it back to the parent and use this value to create the id.

Hi,

1. Go to the parent list and add a new column.
   1. Name it childCount (or something)
   2. Type: Number, default value 0
2. Go to the child list and create a workflow
   1. Under Workflow Settings -  Start when items are created -> Yes
   2. Using a query list action, read the childCount from the linked parent and store it in a variable
   3. Using a math operation, increment the variable by 1
   4. Update the parent with the variable (which for the first child should then be 1)
   5. Generate the child id ( ParentElement-Title - variable) 

Regards

Hi Tarf,

My workflow as below

Math Operation

Update item in Parent list

Tarf,

Parent list query action as below and there is no filter

Regards,

Hi,

you are connecting the Action Plans (Children) to their Risks (Parent) using a Lookup Column, correct?

If so:

1. Update your Query List Action to receive the parents childCount
   Filter: Where RiskID equals {Your Lookup Column}
2. Use the same filter to update the correct parent only
   Update Risks where RiskId equals {Your Lookup Column}

Hi,

in your Screenshot, the update item action is disabled. May this be the cause?

You could also update using the id of the element.

Should look like this then:

Hi,

are you sure your query list returns the current childcount?

The rest looks fine to me.

Try placing a "log to history" action and log the itemCount variable.

Also I saw in a earlier response, you were not filtering in the query list action, have you fixed that? You want the childCount from the parent element (using the same filter as in the update item section)