admin管理员组

文章数量:1417434

I have a XML-file that looks like that:

<RESULTS>
  <RESULTSHEADER>
    <TEST1>
      <IDENT>
        <REGISTRATION />
        <X>Value</X>
      </IDENT>
      <COMMENT>
        <TIME>01.01.2025 12:12:12</TIME>
        <TEXT>someText</TEXT>
      </COMMENT>
    </TEST1>
  </RESULTSHEADER>
  <RESULT METHOD="ABB" OBJECT="XSD2">
    <TITLE>SomeTitle</TITLE>
    <HEADER>
      <START_TEST>01.01.2025 12:12:12</START_TEST>
      <END_TEST>01.01.2025 12:12:12</END_TEST>
    </HEADER>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL1</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL2</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL3</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
  </RESULT>
</RESULTS>

What I would like to do is create a flow in PowerAutomate, that selects only specific values from that XML-file, so that I keep the structure of the file but reduce the content, e.g. like that:

<RESULT METHOD="ABB" OBJECT="XSD2">
<TITLE>SomeTitle</TITLE>
<HEADER>
  <START_TEST>01.01.2025 12:12:12</START_TEST>
  <END_TEST>01.01.2025 12:12:12</END_TEST>
</HEADER>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL1</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL2</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL3</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
</RESULT>

As the XML-file is very nested, I a struggeling how to filter out only specific values in that deep nested XML-values.

I tried to set up a PowerAutomate Flow by using Select function but I have no idea how to do that.

I have a XML-file that looks like that:

<RESULTS>
  <RESULTSHEADER>
    <TEST1>
      <IDENT>
        <REGISTRATION />
        <X>Value</X>
      </IDENT>
      <COMMENT>
        <TIME>01.01.2025 12:12:12</TIME>
        <TEXT>someText</TEXT>
      </COMMENT>
    </TEST1>
  </RESULTSHEADER>
  <RESULT METHOD="ABB" OBJECT="XSD2">
    <TITLE>SomeTitle</TITLE>
    <HEADER>
      <START_TEST>01.01.2025 12:12:12</START_TEST>
      <END_TEST>01.01.2025 12:12:12</END_TEST>
    </HEADER>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL1</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL2</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
    <SECTION OBJECT="CTRL">
      <TITLE>CTRL3</TITLE>
      <MEAS OBJECT="V1">
        <TITLE>V1</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
      <MEAS OBJECT="V2">
        <TITLE>V2</TITLE>
        <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label2" TEXT="Label2_Text">1</VALUE>
        <VALUE FORMAT="ALPHA" LABEL="Label3" TEXT="Label3_Text">1</VALUE>
      </MEAS>
    </SECTION>
  </RESULT>
</RESULTS>

What I would like to do is create a flow in PowerAutomate, that selects only specific values from that XML-file, so that I keep the structure of the file but reduce the content, e.g. like that:

<RESULT METHOD="ABB" OBJECT="XSD2">
<TITLE>SomeTitle</TITLE>
<HEADER>
  <START_TEST>01.01.2025 12:12:12</START_TEST>
  <END_TEST>01.01.2025 12:12:12</END_TEST>
</HEADER>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL1</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL2</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
<SECTION OBJECT="CTRL">
  <TITLE>CTRL3</TITLE>
  <MEAS OBJECT="V1">
    <TITLE>V1</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
  <MEAS OBJECT="V2">
    <TITLE>V2</TITLE>
    <VALUE FORMAT="ALPHA" LABEL="Label1" TEXT="Label1_Text">1</VALUE>
  </MEAS>
</SECTION>
</RESULT>

As the XML-file is very nested, I a struggeling how to filter out only specific values in that deep nested XML-values.

I tried to set up a PowerAutomate Flow by using Select function but I have no idea how to do that.

  • xml
  • filter
  • nested
  • power-automate
Share Improve this question asked Jan 31 at 11:23 Malte GeisslerMalte Geissler 1 1
  • Would you consider using a 3rd party connector? – Skin Commented Jan 31 at 19:55
Add a comment  | 

1 Answer 1

Reset to default 0

you can try using xpath expression like this:

xml(xpath(<replace_with_xml_file>, '//RESULT[@METHOD="ABB" and @OBJECT="XSD2"]')[0])

本文标签： filterNeed help by selecting specific values from nested XMLfile via PowerAutomateStack Overflow

版权声明：本文标题：filter - Need help by selecting specific values from nested XML-file via PowerAutomate - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745265364a2650566.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。