{"id":1647,"date":"2022-08-23T22:10:05","date_gmt":"2022-08-23T13:10:05","guid":{"rendered":"http:\/\/160.251.208.217\/?p=1647"},"modified":"2023-08-15T15:06:05","modified_gmt":"2023-08-15T06:06:05","slug":"power-apps-collection","status":"publish","type":"post","link":"https:\/\/it-dxblog.com\/blog\/power-apps-collection\/","title":{"rendered":"\u3010Power Apps\u3011\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u64cd\u4f5c"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u30a2\u30d7\u30ea\u306e\u5b9f\u884c\u4e2d\u306b\u4fdd\u6301\u3057\u305f\u3044\u5024\u304c\u3042\u308b\u5834\u5408\u3001\u5909\u6570\u304b\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<br>\u4eca\u56de\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u307e\u3068\u3081\u3066\u307f\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\">Collection\u3068\u306f<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u3084\u7e70\u308a\u8fd4\u3057\u5229\u7528\u3059\u308b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30ae\u30e3\u30e9\u30ea\u30fc<\/strong>\u3084<strong>\u30d5\u30a9\u30fc\u30e0<\/strong>\u3001<strong>\u30c6\u30fc\u30d6\u30eb<\/strong>\u306f\u3001<strong>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9<\/strong>\u3068\u3057\u3066<strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<br>\u307e\u305f<strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u304c\u30af\u30e9\u30a6\u30c9\u3067\u306f\u306a\u304f\u30ed\u30fc\u30ab\u30eb\u30c7\u30d0\u30a4\u30b9\u306b\u4fdd\u5b58\u3055\u308c\u308b\u305f\u3081\u3001<strong><span class=\"keiko_blue\">\u8aad\u307f\u8fbc\u307f\u6642\u9593\u3092\u77ed\u7e2e<\/span><\/strong>\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n<div id=\"sgb-list-id-1\">\n<div class=\"wp-block-sgb-list\"><div class=\"li-chevron\"><ul style=\"border-color:var(--sgb-main-color)\"><li><strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u306f\u3069\u306e<strong>\u30b9\u30af\u30ea\u30fc\u30f3<\/strong>\u304b\u3089\u3082\u4f7f\u7528\u53ef\u80fd<\/li><li>\u5217\u306e\u3059\u3079\u3066\u306e\u5024\u306f\u540c\u3058<strong>\u30c7\u30fc\u30bf\u578b<\/strong>\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308b<\/li><li>\u4e00\u5ea6\u306b<strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u306b\u683c\u7d0d\u3067\u304d\u308b\u6700\u5927\u6570\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067500\u884c\u3067\u3059\u304c\u3001<strong>\u59d4\u4efb\u5236\u9650<\/strong>\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u6700\u59272000\u884c\u307e\u3067\u5897\u3084\u3059\u3053\u3068\u304c\u53ef\u80fd<\/li><li><strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u306f\u30a2\u30d7\u30ea\u306e\u5b9f\u884c\u4e2d\u306e\u307f\u4fdd\u6301\u3055\u308c\u308b\u3002\u30a2\u30d7\u30ea\u3092\u9589\u3058\u308b\u3068\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u5024\u306f\u30ea\u30bb\u30c3\u30c8\u3055\u308c\u308b<\/li><\/ul><\/div><\/div>\n<\/div>\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:#FFF\"><\/i><span class=\"sgb-heading__text\" style=\"color:#FFF\">Collection\u306e\u95a2\u6570<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Collection\u3092\u64cd\u4f5c\u3059\u308b\u95a2\u6570\u3092\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_red\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u95a2\u6570\u306f\u3059\u3079\u3066\u300cOn\u300d\u3067\u59cb\u307e\u308b\u52d5\u4f5c\u306e\u6570\u5f0f\u5185\u3067\u306e\u307f\u4f7f\u7528\u53ef\u80fd\u3067\u3059\u3002<\/span><br>\u4f8b\uff1aOnStart, OnVisible, OnSelection\u306a\u3069<\/p>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-2\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\">Collect\u95a2\u6570<\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u3092\u4f5c\u6210\u3059\u308b\u969b\u3084\u65e2\u5b58\u306e<strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong>\u306b<strong>\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0<\/strong>\u3059\u308b\u969b\u306b\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>\/\/SharePoint\u30ea\u30b9\u30c8\u306e\u30c7\u30fc\u30bf\u3059\u3079\u3066\u3092\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u683c\u7d0d\u3059\u308b\u6642\n\nCollect(CollectionName, SharePoint\u30ea\u30b9\u30c8\u306e\u540d\u524d)<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u66f8\u304f\u3068SharePoint\u30ea\u30b9\u30c8\u306b\u3042\u308b\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092Collection\u306b\u683c\u7d0d\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-3\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\">Clear\u95a2\u6570<\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u5185\u306e\u3059\u3079\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\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>\/\/\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u683c\u7d0d\u3057\u305f\u3059\u3079\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\n\nClear(CollectionName)<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-4\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\">ClearCollect\u95a2\u6570<\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u4e00\u65e6\u521d\u671f\u5316\u3057\u3066\u304b\u3089\u3001\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\u969b\u306b\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>\/\/ClarCollect\u95a2\u6570\u306fClear\uff0bCollect\u4e21\u65b9\u3092\u5099\u3048\u3066\u3044\u307e\u3059\n\nClearCollect(\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u540d, \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\uff09<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-5\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\">Patch\u95a2\u6570<\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3084\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u5bfe\u3057\u3066\u30ec\u30b3\u30fc\u30c9\u306e\u8ffd\u52a0\u3001\u5909\u66f4\u3092\u884c\u3046\u95a2\u6570\u3067\u3059\u3002\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u306f\u30ec\u30b3\u30fc\u30c9\u306e\u4e00\u90e8\u306e\u60c5\u5831\u3092\u5909\u66f4\u3059\u308b\u6642\u306b\u5229\u7528\u3055\u308c\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>\/\/\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306bPatch\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b\n\nClearCollect(myCollection,classTestScore);\nPatch(\n    myCollection,\n    Defaults(myCollection),\n    {SerialNo:37, FullName:\"\u5c71\u7530\u3000\u592a\u90ce\", TestScore: 85}\n)<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-6\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong>Remove\u95a2\u6570\u3001RemoveIf\u95a2\u6570<\/strong><\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3084\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u304b\u3089\u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3059\u308b\u95a2\u6570\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>\/\/\u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u306e\u524a\u9664\n\/\/Remove\nRemove(myCollection,LookUp(myCollection, SerialNo=37);\n\n\/\/RemoveIf\nRemoveIf(myCollection, SerialNo=37);<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-7\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong><strong>Concarrent\u95a2\u6570<\/strong><\/strong><\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u8aad\u307f\u8fbc\u3080\u5834\u5408\u306b\u3001\u540c\u6642\u5b9f\u884c\u3092\u884c\u3044\u305f\u3044\u5834\u5408\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\u4e26\u5217\u3067\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f\u6642\u9593\u3092\u6e1b\u3089\u3059\u3053\u3068\u304c\u3067\u304d\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\u3092\u540c\u6642\u5b9f\u884c\u3059\u308b\u3000\nConcurrent(\n    ClearCollect( myCollection, TestScore ),\n    ClearCollect( myCollection1, StudentsData )\n)<\/code><\/pre><\/div>\n\n\n<p>  <a class=\"reference table\" href=\"https:\/\/docs.microsoft.com\/ja-jp\/power-platform\/power-fx\/reference\/function-concurrent\" target=\"_blank\" rel=\"noopener noreferrer\">\n    <span class=\"tbcell refttl\">\u53c2\u8003<\/span>\n    <span class=\"tbcell refcite\">Power Apps \u3067\u306e Concurrent \u95a2\u6570<span>Microsoft Docs<\/span><\/span>\n  <\/a><\/p>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-8\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong><strong>ForAll\u95a2\u6570<\/strong><\/strong><\/span><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u5185\u306e\u8907\u6570\u306e\u30ec\u30b3\u30fc\u30c9\u306b\u5bfe\u3057\u3066\u64cd\u4f5c\u3092\u884c\u3046\u3068\u304d\u306fForAll\u95a2\u6570\u3092\u5229\u7528\u3057\u307e\u3059\u3002ForAll\u95a2\u6570\u306f\u3059\u3079\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u306b\u5bfe\u3057\u3066\u6570\u5f0f\u3092\u5b9f\u884c\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>\/\/\u307e\u305a\u4e0b\u8a18\u306eCollection\u3092\u4f5c\u6210\u3057\u307e\u3059\n\nClearCollect(SLAMDUNK,\n    Table(\n        { SerialNo: 10,    FullName: \"SAKURAGI Hanamichi\",  Position: \"PF\", Height:189.2, Weight: 83},\n        { SerialNo: 14,    FullName: \"MITSUI Hisashi\",  Position: \"SG\" , Height:184, Weight: 70},\n        { SerialNo: 11,    FullName: \"RUKAWA Kaede\",  Position: \"SF\" , Height:187, Weight: 75 },\n        { SerialNo: 7,    FullName: \"MIYAGI Ryota\",  Position: \"PG\", Height:168 , Weight: 59},\n        { SerialNo: 4,    FullName: \"AKAGI Takenori\",  Position: \"C\" , Height:197, Weight: 93}\n    )\n)\n\n\/\/ForAll\u3092\u5229\u7528\u3057\u3066\u3001Weight\u304c70\u4ee5\u4e0a\u306eSerialNo\u3068FullName\u3068Weight\u3092\u65b0\u3057\u3044\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u683c\u7d0d\u3057\u307e\u3059\nForAll(\n    SLAMDUNK,\n    If(\n        Weight &gt;= 70,\n        Collect(\n            Taller,\n            {\n                SerialNo: SerialNo,\n                FullName: FullName,\n                Weight: Weight\n            }\n        )\n    )\n)<\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-9\"><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\">\u4f7f\u3044\u65b9\u4f8b<\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u3044\u305d\u3046\u306a\u4f8b\u3092\u3044\u304f\u3064\u304b\u3042\u3052\u3066\u304a\u304d\u307e\u3059\u3002\u5c11\u3057\u305a\u3064\u601d\u3044\u3064\u3044\u305f\u3089\u5897\u3084\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-10\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong><strong>\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\uff11\u884c\u65b0\u3057\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/strong><\/strong><\/span><\/span><\/h3>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>\/\/\u4e0b\u8a18\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b1\u884c\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\n\nClearCollect(SLAMDUNKa,\n    { SerialNo: 10,    FullName: \"SAKURAGI Hanamichi\",  Position: \"PF\", Height:189.2, Weight: 83},\n    { SerialNo: 14,    FullName: \"MITSUI Hisashi\",  Position: \"SG\" , Height:184, Weight: 70},\n    { SerialNo: 11,    FullName: \"RUKAWA Kaede\",  Position: \"SF\" , Height:187, Weight: 75 }\n    )\n)\n\n\/\/\u3084\u308a\u65b9\u2460\uff1a\u8ffd\u52a0\u3057\u305f\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u5909\u6570\u306b\u683c\u7d0d\nSet(\n    AddMember,\n    { SerialNo: 7,    FullName: \"MIYAGI Ryota\",  Position: \"PG\", Height:168 , Weight: 59}\n);\n\n\/\/\u3084\u308a\u65b9\u2460\uff1a\u3055\u304d\u307b\u3069\u306e\u5909\u6570\u3092\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u8ffd\u52a0\nClearCollect(SLUMDUNK,SLAMDUNKa);\nCollect(SLUMDUNK, AddMember);\n\n\/\/\u3084\u308a\u65b9\u2461\uff1aPatch\u95a2\u6570\u3092\u4f7f\u7528\nClearCollect(SLUMDUNK,SLAMDUNKa);\nPatch(\n    SLUMDUNK,\n    Defaults(SLUMDUNK),\n    { SerialNo: 7,    FullName: \"MIYAGI Ryota\",  Position: \"PG\", Height:168 , Weight: 59}\n)\n<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-11\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong><strong>\u65e2\u5b58\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u8907\u6570\u884c\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/strong><\/strong><\/span><\/span><\/h3>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>\/\/\u4e0b\u8a18\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b1\u884c\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\n\nClearCollect(SLAMDUNKa,\n    { SerialNo: 10,    FullName: \"SAKURAGI Hanamichi\",  Position: \"PF\", Height:189.2, Weight: 83},\n    { SerialNo: 14,    FullName: \"MITSUI Hisashi\",  Position: \"SG\" , Height:184, Weight: 70},\n    { SerialNo: 11,    FullName: \"RUKAWA Kaede\",  Position: \"SF\" , Height:187, Weight: 75 }\n    )\n)\n\n\/\/\u8ffd\u52a0\u3057\u305f\u3044\u8907\u6570\u884c\u3092\u65b0\u3057\u3044\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u683c\u7d0d\u3057\u307e\u3059\nClearCollect(\n    AddMembers,\n        { SerialNo: 7,    FullName: \"MIYAGI Ryota\",  Position: \"PG\", Height:168 , Weight: 59},\n        { SerialNo: 4,    FullName: \"AKAGI Takenori\",  Position: \"C\" , Height:197, Weight: 93}\n);\n\n\/\/\u8907\u6570\u884c\u3092\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u8ffd\u52a0\u3059\u308b\nClearCollect(SLAMDUNK, SLAMDUNKa);\nCollect(SLAMDUNK, AddMembers);<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-sgb-headings sgb-heading\" id=\"i-12\"><span class=\"sgb-heading__inner sgb-heading--type1 with-icon\" style=\"background-color:transparent;border-color:var(--sgb-main-color);font-size:1.2em\"><i class=\"fa fa-chevron-circle-right\" style=\"color:var(--wp--preset--color--sango-main)\"><\/i><span class=\"sgb-heading__text\" style=\"color:#333\"><strong><strong>\u30ec\u30b3\u30fc\u30c9\u306e\u5024\u3092\u5909\u66f4\u3059\u308b<\/strong><\/strong><\/span><\/span><\/h3>\n\n\n\n<div class=\"wp-block-sgb-codebox pre_tag\"><span><i class=\"fa fa-code\"><\/i>Apps<\/span><pre><code>\/\/\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3059\u308b\nClearCollect(myStore,\n{ID:101, Name: \"Desktop PC\", Quantity: 10},\n{ID:102, Name: \"Monitor\", Quantity: 40},\n{ID:103, Name: \"Laptop\", Quantity: 20}\n);\n\n\/\/\u30ec\u30b3\u30fc\u30c9\u306e\u8907\u6570\u306e\u5024\u3092\u5909\u66f4\u3059\u308b\nPatch(\n    myStore,\n    LookUp(myStore,ID=103),\n    {Name: \"Mac Laptop\", Quantity: 30}\n)<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u30a2\u30d7\u30ea\u306e\u5b9f\u884c\u4e2d\u306b\u4fdd\u6301\u3057\u305f\u3044\u5024\u304c\u3042\u308b\u5834\u5408\u3001\u5909\u6570\u304b\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u307e\u3068\u3081\u3066\u307f\u307e\u3059\u3002 \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u3084\u7e70\u308a\u8fd4\u3057\u5229\u7528\u3059\u308b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002 \u30ae\u30e3\u30e9\u30ea\u30fc\u3084\u30d5\u30a9\u30fc\u30e0\u3001\u30c6\u30fc\u30d6 &#8230; <\/p>\n","protected":false},"author":2,"featured_media":2010,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[29],"tags":[167],"class_list":["post-1647","post","type-post","status-publish","format-standard","has-post-thumbnail","category-power-apps","tag-collection","entry"],"_links":{"self":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1647","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=1647"}],"version-history":[{"count":5,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1647\/revisions"}],"predecessor-version":[{"id":3007,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/posts\/1647\/revisions\/3007"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/media\/2010"}],"wp:attachment":[{"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/media?parent=1647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/categories?post=1647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/it-dxblog.com\/blog\/wp-json\/wp\/v2\/tags?post=1647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}