{
  "name": "1200139d-495b-4846-8379-10c8abc2117a",
  "id": "/providers/Microsoft.Flow/flows/1200139d-495b-4846-8379-10c8abc2117a",
  "type": "Microsoft.Flow/flows",
  "properties": {
    "apiId": "/providers/Microsoft.PowerApps/apis/shared_logicflows",
    "displayName": "Clean Azure VPN Alerts",
    "definition": {
      "metadata": {
        "workflowEntityId": null,
        "processAdvisorMetadata": null,
        "flowChargedByPaygo": null,
        "flowclientsuspensionreason": "None",
        "flowclientsuspensiontime": null,
        "flowclientsuspensionreasondetails": null,
        "creator": {
          "id": "4a35c6fc-e945-4f70-8791-ba7ea5900e7f",
          "type": "User",
          "tenantId": "e417d5cc-e5d8-4cad-b2cd-c5ef82dea0a0"
        },
        "provisioningMethod": "FromDefinition",
        "failureAlertSubscription": true,
        "clientLastModifiedTime": "2025-04-10T06:58:29.3779237Z",
        "connectionKeySavedTimeKey": "2025-04-10T06:58:29.3779237Z",
        "creationSource": "Portal",
        "modifiedSources": "Portal"
      },
      "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
      "contentVersion": "1.0.0.0",
      "parameters": {
        "$authentication": {
          "defaultValue": {
            
          },
          "type": "SecureObject"
        },
        "$connections": {
          "defaultValue": {
            
          },
          "type": "Object"
        }
      },
      "triggers": {
        "When_a_new_email_arrives_(V3)": {
          "splitOn": "@triggerOutputs()?['body/value']",
          "type": "OpenApiConnectionNotification",
          "inputs": {
            "parameters": {
              "includeAttachments": false,
              "importance": "Any",
              "fetchOnlyWithAttachment": false,
              "folderPath": "Inbox"
            },
            "host": {
              "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
              "connectionName": "shared_office365",
              "operationId": "OnNewEmailV3"
            },
            "authentication": "@parameters('$authentication')"
          }
        }
      },
      "actions": {
        "Condition_1": {
          "actions": {
            "DeleteEmail1": {
              "runAfter": {
                "For_each": [
                  "Succeeded"
                ]
              },
              "metadata": {
                "flowSystemMetadata": {
                  "portalOperationIconOverride": "https://conn-afd-prod-endpoint-bmc9bqahasf3grgk.b01.azurefd.net/releases/v1.0.1722/1.0.1722.3975/office365/icon.png",
                  "portalOperationBrandColorOverride": "#0078D4",
                  "portalOperationId": "/providers/Microsoft.PowerApps/apis/shared_office365/apiOperations/DeleteEmail_V2"
                }
              },
              "type": "OpenApiConnection",
              "inputs": {
                "parameters": {
                  "messageId": "@triggerOutputs()?['body/id']"
                },
                "host": {
                  "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
                  "connectionName": "shared_office365",
                  "operationId": "DeleteEmail_V2"
                },
                "authentication": "@parameters('$authentication')"
              }
            },
            "Get_emails_(V3)": {
              "type": "OpenApiConnection",
              "inputs": {
                "parameters": {
                  "from": "[email protected]",
                  "fetchOnlyUnread": true,
                  "searchQuery": "subject:'Activated Severity'",
                  "top": 25
                },
                "host": {
                  "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
                  "connectionName": "shared_office365",
                  "operationId": "GetEmailsV3"
                },
                "authentication": "@parameters('$authentication')"
              }
            },
            "For_each": {
              "foreach": "@outputs('Get_emails_(V3)')?['body/value']",
              "actions": {
                "Delete_email_(V2)": {
                  "type": "OpenApiConnection",
                  "inputs": {
                    "parameters": {
                      "messageId": "@item()?['id']"
                    },
                    "host": {
                      "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
                      "connectionName": "shared_office365",
                      "operationId": "DeleteEmail_V2"
                    },
                    "authentication": "@parameters('$authentication')"
                  }
                }
              },
              "runAfter": {
                "Get_emails_(V3)": [
                  "Succeeded"
                ]
              },
              "type": "Foreach"
            }
          },
          "runAfter": {
            
          },
          "else": {
            "actions": {
              
            }
          },
          "expression": {
            "and": [
              {
                "equals": [
                  "@triggerOutputs()?['body/subject']",
                  "Azure: Deactivated Severity: 3 VPNConnection"
                ]
              }
            ]
          },
          "type": "If"
        }
      },
      "outputs": {
        
      }
    },
    "connectionReferences": {
      "shared_office365": {
        "connectionName": "shared-office365-96b1849c-c7f2-4c88-8789-5410edf28b88",
        "source": "Embedded",
        "id": "/providers/Microsoft.PowerApps/apis/shared_office365",
        "tier": "NotSpecified",
        "apiName": "office365"
      }
    },
    "flowFailureAlertSubscribed": false,
    "isManaged": false
  }
}

https://github.com/pariswells/public-code/blob/master/PowerApps/CleanAzureVPNAlerts_20250410070955.zip