So I have a list with repeating section, I have to parse the repeating section to a different list in order to export the data out. I figured out how to parse the repeating section items to a different list.
The part I need help is in addition to parsing the repeating section items to a new list, i need to copy the case ID to the new list as well. Here's an example, list A has the following items:
date (in repeating section)
Amount (in repeating section)
How do I parse the date and amount plus copying the case ID to list B at the same time?
One route you can go is to create the new item the second list and set the Case ID when the new item is created. You should be able to get the list item ID for the item and store it in a workflow variable. Then use that variable to update that item via with the Update Item action with the Date and Amount information. You could also use the Case ID in the Update Item action to match the new list item.
Thanks for your input.
The second is used solely for the purposes of getting the repeating section information out from the first list. I can't create item in the second list.
I figured out how to query list to get the case ID I need from the first list, but I can't get the Update item part works.
@CherieWong I assume that your Case ID is outside the repeating section.
Now if you have 4 rows in repeating section then it will create 4 items in your list 2.