Power Automate メモ

{"id":"a01b0c72-adbf-43f1-8510-27c7a1202c45","brandColor":"#8C3900","connectionReferences":{"shared_teams":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_teams/connections/shared-teams-864099d5-54a7-4002-93b6-565ecf481128"}},"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-15e7a58d-6555-418d-a955-a6b286a76a7b"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"いいね分析_by_List_","operationDefinition":{"type":"Scope","actions":{"Get_items":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_sharepointonline","operationId":"GetItems","apiId":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline"},"parameters":{"dataset":"https://shimakuma.sharepoint.com/sites/testforflow","table":"0a0dcba8-686b-4e32-9d63-f1c1686ac267"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"metadata":{"operationMetadataId":"69e54ec9-a8a5-4dca-bb35-828c61262aa5"}},"Apply_to_each":{"type":"Foreach","foreach":"@outputs('Get_items')?['body/value']","actions":{"Reactions_取得＆解析":{"type":"Scope","actions":{"Filter_array_yes":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'like')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"97c83fc7-c9be-4502-8551-dbbe1a1054ca"}},"Filter_array_heart":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'heart')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"7c92990a-581e-4c87-9703-f588d1400ac2"}},"Filter_array_laugh":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'laugh')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"d0818a23-fc47-44fa-b10e-48b64804b29f"}},"Filter_array_surprised":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'surprised')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"67238927-2e93-4558-8b98-4342b9efc26d"}},"Filter_array_sad":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'sad')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"63dfac04-af85-4fca-a4e0-e206d3ad3652"}},"Filter_array_angry":{"type":"Query","inputs":{"from":"@outputs('Get_message_details_InChannel')?['body/reactions']","where":"@equals(item()?['reactionType'], 'angry')"},"runAfter":{"Get_message_details_InChannel":["Succeeded"]},"metadata":{"operationMetadataId":"12c6cd61-4b5a-44ca-a354-94ec0db9e747"}},"Append_to_array_variable":{"type":"AppendToArrayVariable","inputs":{"name":"ColumnSets","value":{"type":"ColumnSet","width":"stretch","columns":[{"type":"Column","items":[{"type":"TextBlock","text":"[@{if(empty(outputs('Get_message_details_InChannel')?['body/subject']), '★無件名', outputs('Get_message_details_InChannel')?['body/subject'])}](@{outputs('Get_message_details_InChannel')?['body/messageLink']})","wrap":true}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_yes'))}"}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_heart'))}"}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_laugh'))}"}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_surprised'))}"}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_sad'))}"}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(body('Filter_array_angry'))}"}]}]}},"runAfter":{"Filter_array_angry":["Succeeded"],"Filter_array_laugh":["Succeeded"],"Filter_array_sad":["Succeeded"],"Filter_array_surprised":["Succeeded"],"Filter_array_yes":["Succeeded"],"Apply_to_each_2":["Succeeded"]},"metadata":{"operationMetadataId":"c3d3897b-19af-4087-b6ab-3c70c19d8f49"}},"Get_message_details_InChannel":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_teams","operationId":"GetMessageDetails","apiId":"/providers/Microsoft.PowerApps/apis/shared_teams"},"parameters":{"messageId":"@items('Apply_to_each')?['MessageID']","threadType":"channel","body/recipient/groupId":"a70cc9a6-85a4-4b73-974a-c005f11ca2b5","body/recipient/channelId":"19:b55252f93b12444ea97ffd5ac9a26abc@thread.tacv2"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"metadata":{"operationMetadataId":"06210aad-f59f-4c39-aae8-8ab53571ea91"}},"Apply_to_each_2":{"type":"Foreach","foreach":"@body('Filter_array_heart')","actions":{"Append_to_array_variable_users":{"type":"AppendToArrayVariable","inputs":{"name":"Users","value":"@items('Apply_to_each_2')['user/user']"},"runAfter":{},"metadata":{"operationMetadataId":"61130b81-055a-4e5d-9d08-48cb6630a8de"}}},"runAfter":{"Filter_array_heart":["Succeeded"]},"metadata":{"operationMetadataId":"45262231-467c-4ce9-91bb-a09e6826afba"}}},"runAfter":{},"metadata":{"operationMetadataId":"f73d3379-e546-490b-a4fc-fb92bfbf0b4a"}}},"runAfter":{"Get_items":["Succeeded"]},"metadata":{"operationMetadataId":"8973cb6d-bbea-4dc5-bb94-1189050db6a6"}},"結果投稿":{"type":"Scope","actions":{"Post_adaptive_card_in_a_chat_or_channel":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_teams","operationId":"PostCardToConversation","apiId":"/providers/Microsoft.PowerApps/apis/shared_teams"},"parameters":{"poster":"Flow bot","location":"Chat with Flow bot","body/recipient":"@{triggerOutputs()['headers']['x-ms-user-email-encoded']};","body/messageBody":"{\n    \"type\": \"AdaptiveCard\",\n    \"$schema\": \"http://adaptivecards.io/schemas/adaptive-card.json\",\n    \"version\": \"1.4\",\n    \"msteams\": {\n        \"width\": \"full\"\n    },\n    \"body\": \n@{variables('ColumnSets')}\n}"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"metadata":{"operationMetadataId":"3ada5b80-d41e-4007-93de-fdce2534ba9f"}}},"runAfter":{"Apply_to_each":["Succeeded"]},"metadata":{"operationMetadataId":"fcfd03b0-ae6e-4948-9bba-032adc98a8c9"}},"投稿者情報投稿":{"type":"Scope","actions":{"Compose_UniqueUsers":{"type":"Compose","inputs":"@union(variables('Users'),variables('Users'))","runAfter":{},"metadata":{"operationMetadataId":"688a4b48-35b4-475c-bb53-2fccb446ba5f"}},"Select":{"type":"Select","inputs":{"from":"@outputs('Compose_UniqueUsers')","select":{"type":"ColumnSet","width":"stretch","columns":[{"type":"Column","items":[{"type":"TextBlock","text":"@{item()['displayName']}","wrap":true}]},{"type":"Column","items":[{"type":"TextBlock","text":"@{length(intersection(variables('Users'),array( item())))}"}]}]}},"runAfter":{"Compose_UniqueUsers":["Succeeded"]},"metadata":{"operationMetadataId":"22620811-ed59-4ea6-874a-6b79d37d0eac"}},"Post_adaptive_card_in_a_chat_or_channel_2":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_teams","operationId":"PostCardToConversation","apiId":"/providers/Microsoft.PowerApps/apis/shared_teams"},"parameters":{"poster":"Flow bot","location":"Chat with Flow bot","body/recipient":"@{triggerOutputs()['headers']['x-ms-user-email-encoded']};","body/messageBody":"{\n    \"type\": \"AdaptiveCard\",\n    \"$schema\": \"http://adaptivecards.io/schemas/adaptive-card.json\",\n    \"version\": \"1.4\",\n    \"msteams\": {\n        \"width\": \"full\"\n    },\n    \"body\": \n@{body('Select')}\n}"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"Select":["Succeeded"]},"metadata":{"operationMetadataId":"5dac3285-acb7-418d-b237-f557d78121dc"}}},"runAfter":{"結果投稿":["Succeeded"]},"metadata":{"operationMetadataId":"8533d028-f32c-4aea-b085-af1ed7e7d5f7"}}},"runAfter":{"Initialize_variable_UserInfos":["Succeeded"]},"metadata":{"operationMetadataId":"fd9753c1-2b56-4256-b7f5-e0b808e20d85"}}}