Building flow for monitoring events

[schampseix]

Hi everyone,

I give you a short context of my needs : 

We are using zabbix on our plateform for monitoring, I've connected our zabbix (by webhook -> incoming webhook teams) to display monitoring events in a specific Teams Canal in Adaptive Card format and in same way for our internal tracability to received same cards (previously receive on teams canal) to outlook.

PS : into the AC json (build through the js code) some internal zabbix parameter are injected (like event id, trigger description etc..)

The Adaptiv Card is formated on zabbix side by javascript : 

        formatted_Card_Payload = {
            themeColor: SEVERITY_COLORS[params.event_nseverity].replace('#', ''),
            summary: 'Zabbix',
            sections: [
                {
                    markdown: 'false',
                    activityTitle: params.alert_subject,
                    activitySubtitle: 'On ' + params.host_name + ' [' + params.host_ip + ']',
                    text: (params.use_default_message.toLowerCase() == 'true')
                        ? params.alert_message
                        : params.trigger_description
                }
            ],
        "type": "message",
        "attachments": [
            {
                "contentType": "application/vnd.microsoft.card.adaptive",
                "contentUrl": null,
                "content": {
                    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
                    "type": "AdaptiveCard",
                    "version": "1.0",
                    "title": "Supervision Alerts",
                    "body": [
                        {
                            "type": "TextBlock",
                            "size": "large",
                            "weight": "Bolder",
                            "text": "Supervision Alerts",
                            "style": "heading",
                            "id": "textLabel1"
                       },
                       {
                            "type": "Image",
                            "id": "XXXXX",
                            "url": "https://XXXXXXXX",
                            "spacing": "small",
                            "horizontalAlignment": "center"
                       },
                       {
                            "type": "TextBlock",
                            "size": "Medium",
                            "weight": "Bolder",
                            "text": params.alert_message,
                            "id": "textLabel1"
                       },
                       {
                            "type": "TextBlock",
                            "size": "Medium",
                            "weight": "Bolder",
                            "text": params.alert_subject,
                            "id": "textLabel1"
                       },
                       {
                            "type": "TextBlock",
                            "text": params.trigger_description,
                            "size": "Medium",
                            "wrap": true
                       },
                       {
                            "type": "TextBlock",
                            "text": "ID de l'évènement: " + params.event_id,
                            "size": "Medium",
                            "wrap": true
                       },
                       {
                            "type": "TextBlock",
                            "text": "Pour plus de détails reportez-vous à notre métrologie",
                            "size": "Medium",
                            "weight": "lighter",
                            "wrap": true
                       },
                       {
                            "type": "TextBlock",
                            "size": "Medium",
                            "weight": "Bolder",
                            "text": "Demande de compte Grafana à :"
                       },
                       {
                       "type": "Input.ChoiceSet",
                       "choices": [],
                       "choices.data": {
                        "type": "Data.Query",
                        "dataset": "graph.microsoft.com/users"
                       },
                       "id": "people-picker",
                       "value": params.grafana_contact_do_teamsid
                       }
                    ],
                    "actions": [
                      {
                          "type": "Action.OpenUrl",
                          "title": "Grafana",
                          "url": "https://XXXXXXXX",
                          "iconUrl": "https://XXXXXXX"
                      }
                    ]
                }
            }
        ]
    };

I've created the following Flow : 

1) Trigger : When New canal message is received

2) List Members Group

3) Create Variable Name : EmailList, type : String

4) Loop :  

5) Send Email with Message Body to all teams Canal member

But the mail is Blank in outlook, the source code of the mail contain only a reference to an attachement element.

So I've added a debug step on my workflow juste before the step 5) which is : 

I rerun the flow under test and I can see the Adaptive card is present into the "attachment" json part (fun fact or not .. the AC code is in string format) : 

So my final question is how can I send the AC or the AC json (after an json extraction and how to do ? and add the script behavior in the outlook body) code to my outlook step ?

I was thinking my need will be easy to implement ... maybe I'm on the wrong way ?

Thanks in advance for your help ! 🙂

[schampseix · Accepted solution]

Issue resolved all working as expected