Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : SxAOCqrjA93PCveX8fsIFV
Power Platform Community / Forums / Power Automate - Building Flows / Converting Output from...
Power Automate - Building Flows
Unanswered

Converting Output from Filter Array into XML

Like (0) ShareShare
ReportReport
Posted on 3 Feb 2023 03:56:45 by DH2023 84

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. 

 

DH2023_0-1675396074180.png

DH2023_1-1675396401243.png

 

Is my current expression used in my XML step incorrect?

 

Thank you,

​

  • DH2023 Profile Picture
    DH2023 84 on 06 Feb 2023 at 21:42:09
    Re: Converting Output from Filter Array into XML
    After playing with this for a few days, I don't appear to be able to crack the code.
     
    Below is what the XML output looks like. 
     
    <root><value>======================================================================</value><value>Personnel Change Authorization</value><value>(Termination)</value><value>======================================================================</value><value>Please see the Termination PCA details below for Dane Doe.</value><value>======================================================================</value><value>Employee Details:</value><value>======================================================================</value><value>Employee ID : 11111111</value><value>Name : Dane Doe</value><value>Job Title : Payroll</value><value>Report to Manager : 22222222 John Doe</value><value>Action Date : 2/2/2023</value><value>Effective Date : 2/3/2023</value><value>Division : XXXX - OGR</value><value>Branch/Dept. : Payroll</value><value>Work Location : United States</value><value>Discipline : Back Office</value><value>Sales Location : United States</value><value>Service : Sales</value><value>======================================================================</value><value>Termination Details:</value><value>======================================================================</value><value>Last Day Of Work : 2/2/2023</value><value>Shut Off Access : Immediately</value><value>Transfer Business To : 22222222 John Doe</value><value>Notes:</value><value>HR</value><value>Ph:123-456-7891</value><value>Image</value><value>Some One</value><value>IT | OGR</value><value>Tel: 123456789</value>
    </root>
     
    Any assistance on this is helpful!
     
    Thank you
  • DH2023 Profile Picture
    DH2023 84 on 03 Feb 2023 at 13:41:26
    Re: Converting Output from Filter Array into XML

    [
    "======================================================================",
    "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",
    ]

  • VictorIvanidze Profile Picture
    VictorIvanidze 12,214 on 03 Feb 2023 at 07:05:22
    Re: Converting Output from Filter Array into XML

    Could you show the output of "Filter Array"?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,679 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans