is it neccessary to stick with xml and xpath? What if you make an array from your input, then find the starting and the ending position of your string, then make an array of your result strings? (for example: "Data and Analytics|2024-09;2024-09-30;": you need the substring between 19th and 27th characters, and your result would be "2024-09" ).

where:

1. 'Apply to each':

   variables('varArray')

2. 'Compose - Start':

   add(indexOf(item(),'|'),1)

3. 'Compose - Length':

   substring(item(),outputs('Compose_-Start'),outputs('Compose-_Length'))

4. Append to array variable:

   outputs('Compose')