【Power Automate】Teamsチャネルの投稿をSharePointリストに転記する

{"id":"4408512f-5e11-4046-9f6b-6edbeda7343b","brandColor":"#8C3900","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-fd87a1ff-b982-4fa1-b9d6-aaaf563a5575"}},"shared_office365users":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365users/connections/8bf5610fb58e465ba2d5a1c531895206"}},"shared_teams":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_teams/connections/5b03efb8afa44f8f9a6baeda47eab776"}},"shared_teams_1":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_teams/connections/3bdeec61ac09485eb1f9edfa74ea42b9"}},"shared_sharepointonline_1":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/3a9c5a4dfcde44e3b452876d0eb0f8f9"}},"shared_office365users_1":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365users/connections/shared-office365user-e412c8d6-0f8f-4860-89b9-c5e5d8c0eb99"}}},"connectorDisplayName":"制御","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"スコープ","operationDefinition":{"type":"Scope","actions":{"メッセージを取得します":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_teams_1","operationId":"GetMessagesFromChannel","apiId":"/providers/Microsoft.PowerApps/apis/shared_teams"},"parameters":{"groupId":"xxx","channelId":"xxx"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"description":"投稿一覧を取得","runtimeConfiguration":{"paginationPolicy":{"minimumItemCount":100000}},"metadata":{"operationMetadataId":"3310a8a9-0945-4921-ac68-f7c72f0fdf4c"}},"アレイのフィルター処理":{"type":"Query","inputs":{"from":"@outputs('メッセージを取得します')?['body/value']","where":"@equals(empty(item()?['deletedDateTime']), true)"},"runAfter":{"メッセージを取得します":["Succeeded"]},"description":"削除済み投稿を除外（エラー原因となるため）","metadata":{"operationMetadataId":"196c126f-69f8-40ff-8dcd-9296feaec788"}},"作成":{"type":"Compose","inputs":"@sort(body('アレイのフィルター処理_2'), 'createdDateTime')","runAfter":{"アレイのフィルター処理_2":["Succeeded"]},"description":"作成日（昇順）で並び替え","metadata":{"operationMetadataId":"4753a5a2-f58e-4572-9459-acb6ad9f164a"}},"Apply_to_each":{"type":"Foreach","foreach":"@outputs('作成')","actions":{"メッセージ詳細を取得する":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_teams_1","operationId":"GetMessageDetails","apiId":"/providers/Microsoft.PowerApps/apis/shared_teams"},"parameters":{"messageId":"@items('Apply_to_each')?['id']","threadType":"channel","body/recipient/groupId":"xxx","body/recipient/channelId":"xxx","body/recipient/parentMessageId":"@items('Apply_to_each')?['replyToId']"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"description":"各メッセージの詳細を取得","metadata":{"operationMetadataId":"078abd76-9f44-497b-897c-bf3f6aac56b6"}},"項目の作成":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_sharepointonline_1","operationId":"PostItem","apiId":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline"},"parameters":{"dataset":"xxx","table":"xxx","item/createdDateTime":"@outputs('メッセージ詳細を取得する')?['body/createdDateTime']","item/lastEditedDateTime":"@outputs('メッセージ詳細を取得する')?['body/lastEditedDateTime']","item/subject":"@outputs('メッセージ詳細を取得する')?['body/subject']","item/body":"@outputs('メッセージ詳細を取得する')?['body/body/content']","item/from/Claims":"@outputs('ユーザー_プロフィールの取得_(V2)')?['body/userPrincipalName']","item/reactionsCount":"@length(outputs('メッセージ詳細を取得する')?['body/reactions'])","item/messageLink":"@outputs('メッセージ詳細を取得する')?['body/messageLink']"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"ユーザー_プロフィールの取得_(V2)":["Succeeded","Failed"]},"metadata":{"operationMetadataId":"f105d423-55b3-4aef-af1c-16029b24ca7f"}},"ユーザー_プロフィールの取得_(V2)":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_office365users_1","operationId":"UserProfile_V2","apiId":"/providers/Microsoft.PowerApps/apis/shared_office365users"},"parameters":{"id":"@outputs('メッセージ詳細を取得する')?['body/from/user/id']"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"メッセージ詳細を取得する":["Succeeded"]},"description":"投稿者の詳細を取得","metadata":{"operationMetadataId":"8ada6907-9d92-4ada-a43d-39fd8aced649"}}},"runAfter":{"作成":["Succeeded"]},"metadata":{"operationMetadataId":"beca4e2f-ab9b-449a-bd3b-90a93fd67af5"}},"アレイのフィルター処理_2":{"type":"Query","inputs":{"from":"@body('アレイのフィルター処理')","where":"@equals(item()?['messageType'], 'message')"},"runAfter":{"アレイのフィルター処理":["Succeeded"]},"description":"メッセージのみに絞込（システムメッセージを除外）","metadata":{"operationMetadataId":"0cf0f2f2-5c7f-4df8-b090-6a3d5c2de3d2"}}},"runAfter":{},"metadata":{"operationMetadataId":"26a3223b-2e88-4bb2-a6ac-f09581b85341"}}}