I am attempting to use Power Automate to concat values from a multi value child list into a filed on the parent list
- The field on the child list is named :ConcateDateDef.
- It is a text field with a default value that is concatenate of a date and a text field ( Concatenate(DataCardValue32.SelectedDate," - ", DataCardValue140.Text))
- the field on the parent list is named: EventsGrouped
- It is a text field with the value set by the flow
The concat value for the EventsGrouped field keeps duplicating in the field, so that it appears twice within the same delimiter ( i am using -- to separate the items).
I can see that my concat formula is telling it to duplicate, but every change I try to make to the concat code to prevent it from duplicating does not seem to work,
below is the code:
concat(split(items('Apply_to_each')?['ConcateDateDef'], '.')[0], '. -- ', split(items('Apply_to_each')?['ConcateDateDef'], '.')[sub(length(split(items('Apply_to_each')?['ConcateDateDef'], '.')), 1)])
below is the result:
4/8/2024 - Deadline for the action (request for instructions via email to be submitted the week of Apr 5/24). -- 4/8/2024 - Deadline for the action (request for instructions via email to be submitted the week of Apr 5/24)3/8/2024 - Document was served with notice . -- 3/8/2024 - Document was served with notice
