{"id":1197,"date":"2022-06-25T19:17:49","date_gmt":"2022-06-25T10:17:49","guid":{"rendered":"http:\/\/160.251.208.217\/?p=1197"},"modified":"2025-07-26T16:05:21","modified_gmt":"2025-07-26T07:05:21","slug":"power-apps-join-collection","status":"publish","type":"post","link":"https:\/\/it-dxblog.com\/blog\/power-apps-join-collection\/","title":{"rendered":"\u3010Power Apps\u3011\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u5217\u3092\u8ffd\u52a0\uff08\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u7d50\u5408\uff09"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u30ad\u30fc\u3067\u7d10\u3065\u3051\u305f\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u305f\u3044\u5834\u5408\u306b\u3060\u3044\u3076\u624b\u3053\u305a\u3063\u305f\u305f\u3081\u3001\u3053\u3061\u3089\u306b\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-0\"><span class=\"sgb-heading__inner sgb-heading--type2 with-icon\" style=\"background-color:var(--sgb-main-color);border-color:transparent;font-size:1.2em\"><i class=\"fa fa-check-square\" style=\"color:rgba(255,255,255,.6)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#FFF\">\u5225\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u4e00\u5217\u8ffd\u52a0\u3059\u308b\u5834\u5408<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4eca\u56de\u306f\u4e0b\u8a18\uff12\u3064\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4e00\u304b\u3089\u4f5c\u6210\u3057\u3001ID\u3092\u30ad\u30fc\u306b\uff12\u3064\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u7d50\u5408\u3057\u3001\uff11\u3064\u306e\u65b0\u3057\u3044\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u203b\u5b9f\u969b\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4e00\u304b\u3089\u66f8\u304f\u3053\u3068\u306f\u306a\u304f\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304b\u3089\u8aad\u307f\u53d6\u308b\u3053\u3068\u304c\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u7df4\u7fd2\u306e\u305f\u3081\u4e00\u304b\u3089\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>ClearCollect(Arashi_Name,\n{ID: \"0001\", Name: \"Ohno Satoshi\"},\n{ID: \"0002\", Name: \"Sakurai Sho\"},\n{ID: \"0003\", Name: \"Aiba Masaki\"},\n{ID: \"0004\", Name: \"Ninomiya Kazunari\"},\n{ID: \"0005\", Name: \"Matsumoto Jun\"}\n);\n\nClearCollect(Arashi_Color,\n{ID: \"0001\", Color: Blue},\n{ID: \"0002\", Color: Red},\n{ID: \"0003\", Color: Green},\n{ID: \"0004\", Color: Yellow},\n{ID: \"0005\", Color: Purple}\n);\n<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-sango-with-shadow\"><img loading=\"lazy\" decoding=\"async\" width=\"952\" height=\"616\" src=\"http:\/\/160.251.208.217\/wp-content\/uploads\/2022\/06\/Arashi_Name.png\" alt=\"\" class=\"wp-image-1302\" srcset=\"https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Name.png 952w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Name-300x194.png 300w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Name-768x497.png 768w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Name-940x608.png 940w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-sango-with-shadow\"><img loading=\"lazy\" decoding=\"async\" width=\"908\" height=\"615\" src=\"http:\/\/160.251.208.217\/wp-content\/uploads\/2022\/06\/Arashi_Color.png\" alt=\"\" class=\"wp-image-1303\" srcset=\"https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Color.png 908w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Color-300x203.png 300w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi_Color-768x520.png 768w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\"><\/figure>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>\/\/Arashi_Name\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306bColor\u5217\u3092\u8ffd\u52a0\u3057\u307e\u3059\n\/\/\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u306f\u8ffd\u52a0\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u65b0\u305f\u306a\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\nClearCollect(Arashi,\n   AddColumns(Arashi_Name,\"Color\",LookUp(Arashi_Color,ID=Arashi_Name[@ID],Color)))<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-sango-with-shadow\"><img loading=\"lazy\" decoding=\"async\" width=\"948\" height=\"619\" src=\"http:\/\/160.251.208.217\/wp-content\/uploads\/2022\/06\/Arashi.png\" alt=\"\" class=\"wp-image-1304\" srcset=\"https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi.png 948w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi-300x196.png 300w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi-768x501.png 768w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi-940x614.png 940w\" sizes=\"auto, (max-width: 948px) 100vw, 948px\"><\/figure>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-1\"><span class=\"sgb-heading__inner sgb-heading--type2 with-icon\" style=\"background-color:var(--sgb-main-color);border-color:transparent;font-size:1.2em\"><i class=\"fa fa-check-square\" style=\"color:rgba(255,255,255,.6)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#FFF\">\u5225\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u3059\u3079\u3066\u306e\u5217\u3092\u8ffd\u52a0\u3059\u308b\u5834\u5408<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5148\u307b\u3069\u3068\u540c\u3058\u3088\u3046\u306b\u306b\u4e0b\u8a18\u306e\uff12\u3064\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>ClearCollect(Arashi_Name,\n{ID:\"0001\",Name:\"Ohno Satoshi\"},\n{ID:\"0002\",Name:\"Sakurai Sho\"},\n{ID:\"0003\",Name:\"Aiba Masaki\"},\n{ID:\"0004\",Name:\"Ninomiya Kazunari\"},\n{ID:\"0005\",Name:\"Matsumoto Jun\"}\n);\n\nClearCollect(Arashi3,\n{ID:\"0001\",Color:\"Blue\",Birthplace:\"Tokyo\",BloodType:\"A\"},\n{ID:\"0002\",Color:\"Red\",Birthplace:\"Tokyo\",BloodType:\"A\"},{ID:\"0003\",Color:\"Green\",Birthplace:\"Chiba\",BloodType:\"AB\"},{ID:\"0004\",Color:\"Yellow\",Birthplace:\"Tokyo\",BloodType:\"A\"},{ID:\"0005\",Color:\"Purple\",Birthplace:\"Tokyo\",BloodType:\"A\"}\n);<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-sango-with-shadow\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"623\" src=\"http:\/\/160.251.208.217\/wp-content\/uploads\/2022\/06\/Arashi3.png\" alt=\"\" class=\"wp-image-1306\" srcset=\"https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3.png 951w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3-300x197.png 300w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3-768x503.png 768w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3-940x616.png 940w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Arashi_Name\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306bArashi3\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u5168\u5217\u3092\u8ffd\u52a0\u3059\u308b\u65b0\u3057\u3044\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>ClearCollect(\n    Arashi,\n    Ungroup(\n        DropColumns(\n            AddColumns(\n                Arashi3,\n                \"myGroupedColumn\",\n                Filter(\n                    Arashi_Name,\n                    ID = Arashi3[@ID]\n                )\n            ),\n            \"ID\"\n        ),\n        \"myGroupedColumn\"\n    )\n);\n<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u5165\u308c\u5b50\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u3070\u3089\u3057\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u4e2d\u306eAddColumns\u95a2\u6570\u3067\u3059\u304c\u3001\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b1\u5217\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u306fArashi3\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30921\u5217\u3068\u3057\u3066\u6271\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DropColumns\u95a2\u6570\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u306e\u306f\u3001\u30ad\u30fc\u306b\u306a\u3063\u3066\u3044\u308bID\u5217\u304c\u91cd\u8907\u3059\u308b\u305f\u3081\u3001ID\u5217\u3092\u524a\u9664\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ungroup\u3067\uff11\u5217\u3067\u653e\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u3092\u3070\u3089\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n<p><\/p><div class=\"memo alert\"><div class=\"memo_ttl dfont\"> \u6ce8\u610f<\/div>Ungroup\u3059\u308b\u6642\u306b\u5148\u307b\u3069\u524a\u9664\u3057\u305fID\u5217\u304c\u6b8b\u3063\u3066\u3044\u308b\u5834\u5408\u3001\u5217\u540d\u304c\u91cd\u8907\u3059\u308b\u305f\u3081\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3001Ungroup\u3067\u304d\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-sango-with-shadow\"><img loading=\"lazy\" decoding=\"async\" width=\"1013\" height=\"606\" src=\"http:\/\/160.251.208.217\/wp-content\/uploads\/2022\/06\/Arashi3_1.png\" alt=\"\" class=\"wp-image-1307\" srcset=\"https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3_1.png 1013w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3_1-300x179.png 300w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3_1-768x459.png 768w, https:\/\/it-dxblog.com\/blog\/wp-content\/uploads\/2022\/06\/Arashi3_1-940x562.png 940w\" sizes=\"auto, (max-width: 1013px) 100vw, 1013px\"><\/figure>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-2\"><span class=\"sgb-heading__inner sgb-heading--type2 with-icon\" style=\"background-color:var(--sgb-main-color);border-color:transparent;font-size:1.2em\"><i class=\"fa fa-check-square\" style=\"color:rgba(255,255,255,.6)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#FFF\">SharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306e\u6ce8\u610f\u70b9<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u5168\u90e8\u4f7f\u7528\u3057\u3001\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092\u5225\u306eSharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u306b\u8ffd\u52a0\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u540c\u3058\u5217\u540d\u304c\u3042\u308b\u305f\u3081\u7d50\u5408\u3067\u304d\u306a\u3044\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u306a\u305c\u304b\u3068\u3044\u3046\u3068\u3001<span class=\"keiko_blue\"><strong>SharePoint\u30ea\u30b9\u30c8\u306b\u306f\u975e\u8868\u793a\u306b\u306a\u3063\u3066\u3044\u308b\u65e2\u5b58\u306e\u5217\u304c\u5b58\u5728\u3059\u308b<\/strong><\/span>\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u305d\u306e\u305f\u3081\u3001SharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u3068SharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3059\u308b\u5834\u5408\u306f\u3059\u3079\u3066\u306e\u5217\u3092\u7d50\u5408\u3092\u3059\u308b\u306f\u4f7f\u7528\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u5fc5\u8981\u306a\u5217\u306e\u307f\u305d\u308c\u305e\u308c\u8ffd\u52a0\u3059\u308b\u65b9\u304c\u30d9\u30b9\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>ClearCollect(Arashi,       AddColumns(Arashi3,\"Color\",LookUp(Arashi3,ID=Arashi_Name[@ID],Color,\"BloodType\",LookUp(Arashi3,ID=Arashi_Name[@ID],BloodType)))<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u30ad\u30fc\u3067\u7d10\u3065\u3051\u305f\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u305f\u3044\u5834\u5408\u306b\u3060\u3044\u3076\u624b\u3053\u305a\u3063\u305f\u305f\u3081\u3001\u3053\u3061\u3089\u306b\u307e\u3068\u3081\u307e\u3059\u3002 \u4eca\u56de\u306f\u4e0b\u8a18\uff12\u3064\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4e00\u304b\u3089\u4f5c\u6210\u3057\u3001ID\u3092\u30ad\u30fc\u306b\uff12\u3064\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u7d50\u5408\u3057\u3001\uff11\u3064\u306e\u65b0\u3057\u3044\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e &#8230; <\/p>\n","protected":false},"author":2,"featured_media":2045,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[29],"tags":[170,171,172],"class_list":["post-1197","post","type-post","status-publish","format-standard","has-post-thumbnail","category-power-apps","tag-addcolumns","tag-dropcolumns","tag-ungroup","entry"],"_links":{"self":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/comments?post=1197"}],"version-history":[{"count":5,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1197\/revisions"}],"predecessor-version":[{"id":2838,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1197\/revisions\/2838"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/media\/2045"}],"wp:attachment":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/media?parent=1197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/categories?post=1197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/tags?post=1197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}