How to send a message to a teams channel via Power Automate

[Martin Hirsch]

We are using connectors to send messages about new tickets to a teams channel. MS will not longer support this, so we have to use power automate. No i want to use webhooks, but in my workflow the followin error occurs:

Setting in Jira Automation:

ExpressionEvaluationFailed. The execution of template action 'Send_each_adaptive_card' failed: the result of the evaluation of 'foreach' expression 'Test@{triggerBody()}' is of type 'String'. The result must be a valid array.

Any idea to this?

[Vikrant Yadav · Accepted solution]

Hi @Martin Hirsch  You have to use Workflow in MS Team , create flow similar to below screenshot : 

[Martin Hirsch]

Thanks for help. Now i'm getting this error:

ExpressionEvaluationFailed. The execution of template action 'Send_each_adaptive_card' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body']?['attachments']' is of type 'Null'. The result must be a valid array.

[Hugo Fernandes]

Is there an update about this issue?

[Vikrant Yadav]

@Martin Hirsch @Hugo Fernandes Try to add compose action before send each adaptive card and put dynamic content body only. It seems that body.attachment is not a correct dynamic content. 

[Andras M]

@Vikrant Yadav when selecting Body (with capital B?) for Compose as dynamic content (and also for Send each adaptive card)

still I got an error message

ExpressionEvaluationFailed. The execution of template action 'Send_each_adaptive_card' failed: the result of the evaluation of 'foreach' expression '@triggerBody()' is of type 'Object'. The result must be a valid array.

Also, when selecting Compose Output for the Send each adaptive cart, got error

ExpressionEvaluationFailed. The execution of template action 'Send_each_adaptive_card' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'Object'. The result must be a valid array.

[Vikrant Yadav]

Hi @Andras M 

In Jira, Use Send Web Request action and in body select "Custom Data" . In Custom Data, capture only those fields in which you want to post on MS Teams Channel. 

In MS Team >> 

1. When a Teams Webhook request is recevied

2. Initialie variable >> Give name , type should be Object >> in value select Body dynamic content. 

3. Compose item : write expression >> variables('JiraData')?['Summary'] 

4. Post a message in a chat. In message i have selected Compose output.  

[Vikrant Yadav]

Hi @Andras M  @Martin Hirsch  Checkout short video created for you : https://www.youtube.com/watch?v=7OAquAcJaAo

[Andras M]

Hi @Vikrant Yadav thank for your time and effort, now the notification works perfectly with the solution you provided. Simple, but effective. Cheers

[Vikrant Yadav]

Thanks @Andras M  Glad to hear i am able to help you out!

[Martin Hirsch]

Thank you very much. One problem: I'm getting two posts in teams. One with the summary ane another one with the issue key. But i don't have the issue key in the web message. Only the summary and the description.

[Vikrant Yadav]

@Martin Hirsch  Might be two workflows are running that’s why two notifications are coming. 

Kindly check number of workflows are enabled. 

[Martin Hirsch]

You are right. Thank you very much.