はじめに

この記事ではPower Automateで

Excel
SharePoint List(Microsoft List)
Dataverse

に対してBulk Insert(複数データの一括登録)の方法をまとめています。(長くなったのでそれぞれ別記事にまとめました。)

Power Automateではこれらのデータソースに対してレコードを作成するアクションを標準で搭載してはいますが、どれも1件ずつの登録しかできません。

これでは例えば500件のデータを登録したい場合など、ループアクションが必要になり、APIコール数もこれだけで500回も消費してしまいます。

このような事態を避けるためにも1回のアクションで複数件のデータを登録する方法をこの記事ではまとめています。

あくまでもここで紹介しているのは一例に過ぎないのでご注意ください。

Bulk Insert

登録を行う元データは以下のようなデータです。

[
  {
    "Date": "2023-01-07T09:17:30.069Z",
    "GUID": "37e77bde-5d1f-4f91-a8f7-59d14be8c589",
    "Number": 0,
    "Text": "a"
  },
  {
    "Date": "2023-01-08T09:17:30.070Z",
    "GUID": "cc58a917-caee-4136-87dc-e407fcba2b2f",
    "Number": 1,
    "Text": "b"
  },
  {
    "Date": "2023-01-09T09:17:30.070Z",
    "GUID": "7f31a56b-61d8-4b78-a0b8-298f93ae1b2a",
    "Number": 2,
    "Text": "c"
  },
  {
    "Date": "2023-01-10T09:17:30.070Z",
    "GUID": "bf143cd8-4c87-4d87-ac93-ffbc8cd09341",
    "Number": 3,
    "Text": "d"
  },
  {
    "Date": "2023-01-11T09:17:30.070Z",
    "GUID": "d9801702-a8a4-491d-8aa9-1086e1530ec0",
    "Number": 4,
    "Text": "e"
  },
  {
    "Date": "2023-01-12T09:17:30.070Z",
    "GUID": "75447c36-7124-433a-a0cd-b02b91cebcd3",
    "Number": 5,
    "Text": "f"
  },
  {
    "Date": "2023-01-13T09:17:30.070Z",
    "GUID": "675304f7-76e8-4d54-a960-525102034fd2",
    "Number": 6,
    "Text": "g"
  },
  {
    "Date": "2023-01-14T09:17:30.070Z",
    "GUID": "eaaec966-4d7b-4858-a46a-4d73f65c4d0a",
    "Number": 7,
    "Text": "h"
  },
  {
    "Date": "2023-01-15T09:17:30.070Z",
    "GUID": "69cfe8ba-136c-4c07-bfe7-4f99feaba531",
    "Number": 8,
    "Text": "i"
  },
  {
    "Date": "2023-01-16T09:17:30.070Z",
    "GUID": "52c355d1-8f51-4024-b6d3-63ec3af8cfea",
    "Number": 9,
    "Text": "j"
  },
  {
    "Date": "2023-01-17T09:17:30.070Z",
    "GUID": "0a37fc24-0a18-4bc9-a8c7-d40ad6e8caab",
    "Number": 10,
    "Text": "k"
  },
  {
    "Date": "2023-01-18T09:17:30.070Z",
    "GUID": "f6f29092-b635-4648-8dc9-20643aca087e",
    "Number": 11,
    "Text": "l"
  },
  {
    "Date": "2023-01-19T09:17:30.070Z",
    "GUID": "d8c16b79-bf9a-4957-b8ca-1c79f368fcf8",
    "Number": 12,
    "Text": "m"
  },
  {
    "Date": "2023-01-20T09:17:30.070Z",
    "GUID": "28cf55d2-4981-439c-8140-8dace22ba286",
    "Number": 13,
    "Text": "n"
  },
  {
    "Date": "2023-01-21T09:17:30.070Z",
    "GUID": "07277292-db8a-46b3-baa4-b9cb78dea83f",
    "Number": 14,
    "Text": "o"
  },
  {
    "Date": "2023-01-22T09:17:30.070Z",
    "GUID": "61fc2c39-18e3-40c1-b73b-8e81b663fdb1",
    "Number": 15,
    "Text": "p"
  },
  {
    "Date": "2023-01-23T09:17:30.070Z",
    "GUID": "fac963bc-750a-44d6-ae4d-fd74268bf2a1",
    "Number": 16,
    "Text": "q"
  },
  {
    "Date": "2023-01-24T09:17:30.070Z",
    "GUID": "188102cc-0894-49b7-81e1-7afaac85727a",
    "Number": 17,
    "Text": "r"
  },
  {
    "Date": "2023-01-25T09:17:30.070Z",
    "GUID": "7e1d8392-5c91-4c7b-97b7-5f328ad8f348",
    "Number": 18,
    "Text": "s"
  },
  {
    "Date": "2023-01-26T09:17:30.070Z",
    "GUID": "c10e60f2-2eba-4de8-858f-bde9efce695b",
    "Number": 19,
    "Text": "t"
  },
  {
    "Date": "2023-01-27T09:17:30.070Z",
    "GUID": "19a439bf-ed82-436a-a306-89715c694387",
    "Number": 20,
    "Text": "u"
  },
  {
    "Date": "2023-01-28T09:17:30.070Z",
    "GUID": "aef6e72b-ed60-4bf7-927c-5b1d52dab12d",
    "Number": 21,
    "Text": "v"
  },
  {
    "Date": "2023-01-29T09:17:30.070Z",
    "GUID": "9815a8dc-0eb2-4f4a-bed3-e1118b99c05f",
    "Number": 22,
    "Text": "w"
  },
  {
    "Date": "2023-01-30T09:17:30.070Z",
    "GUID": "d00d638c-75e3-47a0-b934-4634549ad092",
    "Number": 23,
    "Text": "x"
  },
  {
    "Date": "2023-01-31T09:17:30.070Z",
    "GUID": "26ea7a2a-1fa1-4df5-a832-bc10ef0f9188",
    "Number": 24,
    "Text": "y"
  },
  {
    "Date": "2023-02-01T09:17:30.070Z",
    "GUID": "00845e34-cfd2-46ab-b54c-17a5352e5dc0",
    "Number": 25,
    "Text": "z"
  },
  {
    "Date": "2023-02-02T09:17:30.070Z",
    "GUID": "5b39d593-bdd9-49a0-a45c-42e782ba60c9",
    "Number": 26,
    "Text": "A"
  },
  {
    "Date": "2023-02-03T09:17:30.070Z",
    "GUID": "9bfa8ff0-4742-4c38-8695-c06640146037",
    "Number": 27,
    "Text": "B"
  },
  {
    "Date": "2023-02-04T09:17:30.070Z",
    "GUID": "68c820ff-859c-45db-b568-241d82d8eafa",
    "Number": 28,
    "Text": "C"
  },
  {
    "Date": "2023-02-05T09:17:30.070Z",
    "GUID": "b94a711b-a168-4739-ad0f-299e9d180ff7",
    "Number": 29,
    "Text": "D"
  },
  {
    "Date": "2023-02-06T09:17:30.070Z",
    "GUID": "926b2690-e641-463a-9e58-66185f9559fc",
    "Number": 30,
    "Text": "E"
  },
  {
    "Date": "2023-02-07T09:17:30.070Z",
    "GUID": "522d12de-a389-4d7f-9100-571644a9c9b9",
    "Number": 31,
    "Text": "F"
  },
  {
    "Date": "2023-02-08T09:17:30.070Z",
    "GUID": "f1ddba1e-998e-4229-8a0d-f8ad8d573769",
    "Number": 32,
    "Text": "G"
  },
  {
    "Date": "2023-02-09T09:17:30.070Z",
    "GUID": "e6104e10-2bfd-4a91-8de3-95cad63ecc76",
    "Number": 33,
    "Text": "H"
  },
  {
    "Date": "2023-02-10T09:17:30.070Z",
    "GUID": "e016ec6e-5f50-448c-a546-06d875dcf2cd",
    "Number": 34,
    "Text": "I"
  },
  {
    "Date": "2023-02-11T09:17:30.070Z",
    "GUID": "0f96cfee-0c78-4c4b-ac0a-064844e3588e",
    "Number": 35,
    "Text": "J"
  },
  {
    "Date": "2023-02-12T09:17:30.070Z",
    "GUID": "34b1de54-2a8a-4880-8cbc-60c02d232969",
    "Number": 36,
    "Text": "K"
  },
  {
    "Date": "2023-02-13T09:17:30.070Z",
    "GUID": "0e763ae4-3761-4142-94b0-6b38fd497aee",
    "Number": 37,
    "Text": "L"
  },
  {
    "Date": "2023-02-14T09:17:30.070Z",
    "GUID": "b836ce7c-2569-48d0-8d2f-a549d942cffb",
    "Number": 38,
    "Text": "M"
  },
  {
    "Date": "2023-02-15T09:17:30.071Z",
    "GUID": "bd633c26-1c97-450c-b3de-ed8045f16a1c",
    "Number": 39,
    "Text": "N"
  },
  {
    "Date": "2023-02-16T09:17:30.071Z",
    "GUID": "7cab0dfe-5972-45d0-9d6b-d54c95a3704e",
    "Number": 40,
    "Text": "O"
  },
  {
    "Date": "2023-02-17T09:17:30.071Z",
    "GUID": "796c1cbe-04a1-4916-8691-78c09e4a1b94",
    "Number": 41,
    "Text": "P"
  },
  {
    "Date": "2023-02-18T09:17:30.071Z",
    "GUID": "9e1b78d5-5026-4c2b-965a-f71d41609f45",
    "Number": 42,
    "Text": "Q"
  },
  {
    "Date": "2023-02-19T09:17:30.071Z",
    "GUID": "fa77db67-cd7b-4a4e-a4cc-e97314baf40d",
    "Number": 43,
    "Text": "R"
  },
  {
    "Date": "2023-02-20T09:17:30.071Z",
    "GUID": "41b61e19-395f-4514-a287-286a445b6408",
    "Number": 44,
    "Text": "S"
  },
  {
    "Date": "2023-02-21T09:17:30.071Z",
    "GUID": "3ec3790b-a1b4-4b6e-8cd3-c328a78a3c4b",
    "Number": 45,
    "Text": "T"
  },
  {
    "Date": "2023-02-22T09:17:30.071Z",
    "GUID": "0d947f67-bb4b-4e02-ab5a-3f796633cfac",
    "Number": 46,
    "Text": "U"
  },
  {
    "Date": "2023-02-23T09:17:30.071Z",
    "GUID": "3074ec4a-2a48-4c8d-b201-50887041eada",
    "Number": 47,
    "Text": "V"
  },
  {
    "Date": "2023-02-24T09:17:30.071Z",
    "GUID": "d96027b4-e9fe-44e8-aab7-0e793c38df2f",
    "Number": 48,
    "Text": "W"
  },
  {
    "Date": "2023-02-25T09:17:30.071Z",
    "GUID": "382a9107-20be-4352-8bd6-1ad1535dd473",
    "Number": 49,
    "Text": "X"
  },
  {
    "Date": "2023-02-26T09:17:30.071Z",
    "GUID": "8043a45b-7af5-43af-baf9-4da031125fb2",
    "Number": 50,
    "Text": "Y"
  },
  {
    "Date": "2023-02-27T09:17:30.071Z",
    "GUID": "681f7b4e-d471-45af-9479-907e8e2553f6",
    "Number": 51,
    "Text": "Z"
  }
]