{"id":6993,"date":"2023-02-19T17:16:41","date_gmt":"2023-02-19T08:16:41","guid":{"rendered":"https:\/\/mocabrown.com\/blog\/?p=6993"},"modified":"2023-02-21T20:29:57","modified_gmt":"2023-02-21T11:29:57","slug":"post-6993","status":"publish","type":"post","link":"https:\/\/mocabrown.com\/blog\/archives\/6993","title":{"rendered":"Power Automate\u3067\u914d\u5217\u306e\u6570\u5024\u3092\u30eb\u30fc\u30d7\u3092\u4f7f\u308f\u305a\u9ad8\u901f\u306b\u5408\u8a08\u3059\u308b"},"content":{"rendered":"\n<p>\u914d\u5217\u306b\u306a\u3089\u3093\u3060 [1,2,3,4,5]\u306e\u3088\u3046\u306a\u6570\u5024\u306e\u5408\u8a08\u3092\u51fa\u3057\u305f\u3044\u3088\u3046\u306a\u30b1\u30fc\u30b9\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u6b8b\u5ff5\u306a\u304c\u3089Power Automate\u306b\u306f\u3053\u308c\u3092\u76f4\u63a5\u3067\u304d\u308b\u95a2\u6570\u306f\u5185\u5bb9\u3067\u3059\u3002\u30eb\u30fc\u30d7\u3092\u7528\u3044\u3066\u8db3\u3057\u3053\u3081\u3070\u3088\u3044\u3067\u3059\u304c\u3068\u3066\u3082\u9045\u3044\u3002\u305d\u3053\u3067\u3001xPath\u95a2\u6570\u3092\u4f7f\u3063\u305f\u65b9\u6cd5\u3092\u898b\u3064\u3051\u307e\u3057\u305f\u306e\u3067\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/qiita.com\/DaddyDaddy\/items\/a2d2c9b03d3ad3ca5b3e\" data-type=\"URL\" data-id=\"https:\/\/qiita.com\/DaddyDaddy\/items\/a2d2c9b03d3ad3ca5b3e\" target=\"_blank\">\u3053\u3061\u3089\u306e\u5185\u5bb9\u3001Qiita\u306b\u3082\u6295\u7a3f\u3057\u307e\u3057\u305f\uff01<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tachytelic-net wp-block-embed-tachytelic-net\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"KvvGv19XZu\"><a href=\"https:\/\/www.tachytelic.net\/2021\/06\/power-automate-instant-sum-array\/\">Instantly sum an array with Power Automate<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Instantly sum an array with Power Automate&#8221; &#8212; Tachytelic.net\" src=\"https:\/\/www.tachytelic.net\/2021\/06\/power-automate-instant-sum-array\/embed\/#?secret=0gPH6bklvW#?secret=KvvGv19XZu\" data-secret=\"KvvGv19XZu\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>\u304b\u306a\u308a\u63a2\u3057\u3066\u305f\u3069\u308a\u3064\u305f\u306e\u304c\u4e0a\u8a18\u306e\u30b5\u30a4\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u6280\u306f\u4f8b\u3048\u3070JSON\u3067\u53d6\u5f97\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u3092\u5408\u8a08\u3059\u308b\u3088\u3046\u306a\u30b1\u30fc\u30b9\u3067\u5229\u7528\u3067\u304d\u305d\u3046\u3067\u3059\u3002xPath\u3067\u306e\u5408\u8a08\u3092\u5b9f\u884c\u3059\u308b\u969b\u306b\u306f\u3001\u307e\u305a\u6570\u5024\u3092[1,2,3,4,5]\u306e\u3088\u3046\u306a\u914d\u5217\u306e\u5f62\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306b\u3064\u3044\u3066\u306f\u300c<a href=\"https:\/\/mocabrown.com\/blog\/archives\/6983\" data-type=\"post\" data-id=\"6983\">JSON\u304b\u3089\u30b7\u30f3\u30d7\u30eb\u306a\u914d\u5217\u306b\u9ad8\u901f\u306b\u5909\u63db\u3059\u308b<\/a>\u300d\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">xPath\u95a2\u6570\u3092\u3064\u304b\u3046<\/h2>\n\n\n\n<p>\u30a2\u30ec\u30a4\u5909\u6570\u306b[1,2,3,4,5]\u3068\u3044\u3046\u914d\u5217\u3092\u7528\u610f\u3057\u307e\u3057\u305f\u3002\u3064\u304e\u306b\u3001\u300c\u4f5c\u6210\u300d\u3092\u4f7f\u3063\u3066root\u306e\u4e0b\u306bNumbers\u3068\u3044\u3046\u30ad\u30fc\u306e\u3042\u308bJSON\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002Numbers\u306e\u5024\u306f\u6700\u521d\u306b\u4f5c\u3063\u305f\u30a2\u30ec\u30a4\u3092\u52d5\u7684\u306b\u306f\u3081\u8fbc\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"420\" src=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-435.png\" alt=\"\" class=\"wp-image-6994\" srcset=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-435.png 499w, https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-435-450x379.png 450w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/figure>\n\n\n\n<p>\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3001\u4f5c\u6210\u306e\u4e2d\u8eab\u306f\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u6bb5\u968e\u3067\u306f\u5178\u578b\u7684\u306aJSON\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"root\": {\n    \"Numbers\": &#91;\n      1,\n      2,\n      3,\n      4,\n      5\n    ]\n  }\n}<\/code><\/pre>\n\n\n\n<p>\u3082\u3046\u4e00\u3064\u300c\u4f5c\u6210\u300d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u305d\u306e\u4e2d\u306b\u306fxpath\u95a2\u6570\u3092\u3064\u304b\u3063\u305f\u4e0b\u8a18\u306e\u3088\u3046\u306a\u5f0f\u3092\u3044\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"247\" src=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-436-620x247.png\" alt=\"\" class=\"wp-image-6995\" srcset=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-436-620x247.png 620w, https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-436-450x179.png 450w, https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-436-768x306.png 768w, https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-436.png 842w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>xpath(xml(outputs('\u4f5c\u6210')),'sum(\/root\/Numbers)')<\/code><\/pre>\n\n\n\n<p>JSON\u304cxml\u95a2\u6570\u3067XML\u306b\u5909\u63db\u3055\u308c\u3066\u3044\u307e\u3059\u306d\u3002<\/p>\n\n\n\n<p>\u3044\u3088\u3044\u3088\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3001\u7d50\u679c\u3068\u3057\u3066\u914d\u5217\u306e\u4e2d\u8eab 1+2+3+4+5\u306e\u5408\u8a0815\u304c\u53d6\u5f97\u3067\u304d\u307e\u3057\u305f\uff01\uff01<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"541\" height=\"393\" src=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-437.png\" alt=\"\" class=\"wp-image-6996\" srcset=\"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-437.png 541w, https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-437-450x327.png 450w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">xpath\u95a2\u6570\u3063\u3066\uff1f<\/h2>\n\n\n\n<p>DOCS\u3067xpath\u95a2\u6570\u306b\u3064\u3044\u3066\u89e3\u8aac\u3055\u308c\u3066\u3044\u308b\u90e8\u5206\u3067\u3059\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>XML \u3067 XPath (XML Path Language) \u5f0f\u3068\u4e00\u81f4\u3059\u308b\u30ce\u30fc\u30c9\u307e\u305f\u306f\u5024\u3092\u8abf\u3079\u3066\u3001\u4e00\u81f4\u3059\u308b\u30ce\u30fc\u30c9\u307e\u305f\u306f\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002 XPath \u5f0f\u307e\u305f\u306f\u5358\u306b &#8220;XPath&#8221; \u306f\u3001XML \u30b3\u30f3\u30c6\u30f3\u30c4\u5185\u306e\u30ce\u30fc\u30c9\u307e\u305f\u306f\u8a08\u7b97\u5024\u3092\u9078\u629e\u3067\u304d\u308b\u3088\u3046\u306b\u3001XML \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u69cb\u9020\u5185\u306e\u79fb\u52d5\u3092\u88dc\u52a9\u3057\u307e\u3059\u3002<\/p>\n<cite><a href=\"https:\/\/learn.microsoft.com\/ja-jp\/azure\/logic-apps\/workflow-definition-language-functions-reference#xpath\">https:\/\/learn.microsoft.com\/ja-jp\/azure\/logic-apps\/workflow-definition-language-functions-reference#xpath<\/a><\/cite><\/blockquote>\n\n\n\n<p>\u306a\u308b\u307b\u3069\u3002\u3055\u3063\u304d\u306e\u5f0f\u3000\u300cxpath(xml(outputs(&#8216;\u4f5c\u6210&#8217;)),&#8217;sum(\/root\/Numbers)&#8217;)\u300d\u3092\u898b\u308b\u3068\u3001xpath\u306e\u7b2c\uff11\u5f15\u6570\u306b\u306f\u3001\u3082\u3068\u3082\u3068JSON\u3067\u3042\u308b\u4f5c\u6210\u306eoutputs\u3092xml\u95a2\u6570\u3092\u4f7f\u3063\u3066xml\u306b\u5909\u63db\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>xpath\u95a2\u6570\u306fxml\u306e\u4e2d\u304b\u3089\u6307\u5b9a\u3057\u305f\u30ce\u30fc\u30c9\uff08\u4eca\u56de\u306e\u5834\u5408\u306f\u300c\/root\/Numbers\u300d\uff09\u3092\u53d6\u308a\u51fa\u3057\u3066sum\u95a2\u6570\u306b\u6e21\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002\u3053\u306esum\u95a2\u6570\u306fPower Automate\u306e\u95a2\u6570\u3067\u306f\u306a\u304f\u3001<a rel=\"noreferrer noopener\" href=\"https:\/\/qiita.com\/rllllho\/items\/cb1187cec0fb17fc650a\" data-type=\"URL\" data-id=\"https:\/\/qiita.com\/rllllho\/items\/cb1187cec0fb17fc650a\" target=\"_blank\">XPath \u5f0f<\/a>\u306e\u95a2\u6570\u3089\u3057\u3044\u3002XML\u306e\u4e2d\u304b\u3089\u9069\u5207\u306a\u5024\u3092\u62bd\u51fa\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u5f0f\u306a\u3093\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<p>DOCS\u3092\u3088\u3080\u3068\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u542b\u3093\u3060\u30ce\u30fc\u30c9\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b\u3068\u3044\u3046\u3053\u3068\u3082\u3067\u304d\u308b\u3088\u3046\u3067\u3059\u3002\u3046\u307e\u304f\u3064\u304b\u3046\u3068PowerAutomate\u306e\u6761\u4ef6\u3092\u3064\u304b\u308f\u305a\u306b\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u306e\u5834\u5408\u306e\u307f\u8db3\u3057\u3053\u3080\u3068\u3044\u3046\u3088\u3046\u306a\u51e6\u7406\u3082\u3067\u304d\u305d\u3046\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u304b\u306a\u308a\u5f37\u529b\u3067\u30ec\u30a2\u306a\u65b9\u6cd5\uff1f<\/h2>\n\n\n\n<p>\u6570\u5024\u3092\u5408\u8a08\u3059\u308b\u65b9\u6cd5\u306f\u3044\u308d\u3044\u308d\u63a2\u3057\u307e\u3057\u305f\u304c\u306a\u304b\u306a\u304b\u3053\u308c\u3060\u3051\u4e00\u767a\u3067\u9ad8\u901f\u306b\u51e6\u7406\u3067\u304d\u308b\u65b9\u6cd5\u306f\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u30ec\u30a2\u3067\u5f37\u529b\u306a\u624b\u6cd5\u3060\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u305c\u3072\u6d3b\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u307b\u304b\u306b\u3082<a href=\"https:\/\/mocabrown.com\/blog\/powerautomate\" data-type=\"URL\" data-id=\"https:\/\/mocabrown.com\/blog\/powerautomate\">Power Automate\u306e\u9006\u5f15\u304dTIPS\u3092\u7d39\u4ecb<\/a>\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u304a\u5f79\u306b\u7acb\u3066\u308b\u3068\u3046\u308c\u3057\u3044\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u914d\u5217\u306b\u306a\u3089\u3093\u3060 [1,2,3,4,5]\u306e\u3088\u3046\u306a\u6570\u5024\u306e\u5408\u8a08\u3092\u51fa\u3057\u305f\u3044\u3088\u3046\u306a\u30b1\u30fc\u30b9\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u6b8b\u5ff5\u306a\u304c\u3089Power Automate\u306b\u306f\u3053\u308c\u3092\u76f4\u63a5\u3067\u304d\u308b\u95a2\u6570\u306f\u5185\u5bb9\u3067\u3059\u3002\u30eb\u30fc\u30d7\u3092\u7528\u3044\u3066\u8db3\u3057\u3053\u3081\u3070\u3088\u3044\u3067\u3059\u304c\u3068\u3066\u3082\u9045\u3044\u3002\u305d\u3053\u3067\u3001 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6994,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[166,14],"tags":[179,178,177],"class_list":["post-6993","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerautomate","category-14","tag-qiita","tag-xml","tag-xpath"],"jetpack_featured_media_url":"https:\/\/mocabrown.com\/blog\/wp-content\/uploads\/image-435.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/posts\/6993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/comments?post=6993"}],"version-history":[{"count":4,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/posts\/6993\/revisions"}],"predecessor-version":[{"id":7404,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/posts\/6993\/revisions\/7404"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/media\/6994"}],"wp:attachment":[{"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/media?parent=6993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/categories?post=6993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mocabrown.com\/blog\/wp-json\/wp\/v2\/tags?post=6993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}