I am currently building a flow to extract fields from emails received into a shared mailbox. I have previously used an expression in a flow to convert and Output from a filter arrray into a XML to use Xpath. The expression is as follows:
xml(json(concat('{"root": { value:', body('Filter_array'), '}}')))
When trying to use this expression on my new flow, I am not getting any of the pulled data from the XML compose step although it appears to be present in the output of the XML step.
Is my current expression used in my XML step incorrect?
Thank you,
​
[
"======================================================================",
"Personnel Change Authorization",
"(Termination)",
"======================================================================",
"Please see the Termination PCA details below for Jane Doe.",
"======================================================================",
"Employee Details:",
"======================================================================",
"Employee ID : 11111111",
"Name : Dane Doe",
"Job Title : Manager",
"Report to Manager : 22222222 John Doe",
"Action Date : 2/2/2023",
"Effective Date : 2/3/2023",
"Division : XXXX - OGR",
"Branch/Dept. : Payroll",
"Work Location : United States",
"Discipline : Back Office",
"Sales Location : United States",
"Service : SA-Staff Aug (SA-Staff Aug)",
"======================================================================",
"Termination Details:",
"======================================================================",
"Last Day Of Work : 2/2/2023",
"Shut Off Access : Immediately",
"Transfer Business To : 22222222 John Doe",
"Notes:",
"Human Resources Department",
"Ph:123-456-7891",
"[cid:image001.png@01D93723]",
"First Last Name",
"IT Support",
"Tel: 123-456-7891",
"first_lastname@random.com",
"Connect With Us",
"For immediate assistance, please contact IT Technical Support",
]
Could you show the output of "Filter Array"?
David_MA
161
Super User 2025 Season 1
Michael E. Gernaey
158
Super User 2025 Season 1
stampcoin
143