How to setup Teams Workflows for Jira Data Center to receive updates on the tickets

Hi Zakhar, thank you very much! Just one question I have a 400 on the "Post card" with the Adaptive Card JSON I suppose.

"body": {

"error": {

"code": "BadRequest",

"message": "InvalidParameter",

"innerError": {

"code": "1",

"message": "Invalid format of cards property",

"date": "2024-07-30T12:43:55",

"request-id": "6ebed303-5573-4d2c-8847-022607c87f25",

"client-request-id": "6ebed303-5573-4d2c-8847-022607c87f25"

}

Hi @Roberto Ialino

Could you please go to edit page of the workflow and try next steps?

Screenshot 2024-08-01 at 10.50.52.png
Screenshot 2024-08-01 at 10.51.25.png
Screenshot 2024-08-01 at 11.02.12.png

Check the output and share it here. It will give more details why card is not sent.

BR,
Volodymyr B.

Hi @Volodymyr Batrukh

sorry for my delayed answer and thank you very much for your support.

I reacreated everything as from the attached image.

What is different from you screenshots at poin 8 is the Adaptive Card JSON and is equal to your point 9 (these 2 points sorry, are not clear to me 100%)

Immagine 2024-08-07 143820.png

There is for sure some problem on the JSON

Now I have Bad Request. This is the output.

{

"error": {

"code": "BadRequest",

"message": "Failed to process content in attachment with Id '62d2dd593bd741baa688ffb7ded138ce'.",

"innerError": {

"date": "2024-08-07T12:42:38",

"request-id": "18238259-27e6-4857-9032-47da41e3aa9b",

"client-request-id": "18238259-27e6-4857-9032-47da41e3aa9b"

}

Thanks a lot

Roberto

Hi @Roberto Ialino

The image on Step #8 was not accurate (we have updated it to much the card json from Step #9). Thanks for noticing it!

For the Post card in a chat or channel action use content from the Step #9 an set it as an Adaptive card for the action configuration.

As for your original error "message": "Invalid format of cards property"," please try to change Post as setting for Post card in a chat or channel action from the User to Flow bot.

Screenshot 2024-08-07 at 16.12.13.png

The option with a User seems to be broken (as there should be an option to select a user). We were able to reproduce an issue with User selected in Post as drop down.

Hope it will help you to resolve the issue.

BR,
Volodymyr B.

Hi @Volodymyr Batrukh

you json at step 9 is on my Adaptive Card input starting from "type" : "Adaptive Card" since all the json at step 9 does not work. I mean with the schema etc...

With Flow bot does not work the save for this error

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'body' validation failed in workflow operation 'Post_card_in_a_chat_or_channel': The API operation 'PostCardToConversation' is missing required property 'body/messageBody'.'.

Thank you very much.

Best regards,

Roberto

Hi @Roberto Ialino

The content for JSON Schema and Adaptive cards should be used as is, without any modifications. If you omit $schema or version or opening brackets from the Adaptive Card it will be invalid, so failure is expected.

In the end you should have something like:

Screenshot 2024-08-07 at 17.48.24.png
...

I am not sure why the option with Flow Bot is not working for your configuration (BTW we have tried to use User option on another Teams tenant and it was working). Please try to completely remove the step with card and add it from the scratch.

Regards,
Volodymyr B.

Hi @Volodymyr Batrukh I tried with the previous json version (on my previous comments) since with the full JSON provided on your initial post I have unfortunetelly an invalid parameter

Everything is as you showed but it doesn't work for me.

Thanks,

Roberto

"error": {

"code": "BadRequest",

"message": "InvalidParameter",

"innerError": {

"code": "1",

"message": "Invalid format of cards property",

"date": "2024-08-08T12:21:53",

"request-id": "fd99b3e5-8e48-4314-bb6e-131c7090d207",

"client-request-id": "fd99b3e5-8e48-4314-bb6e-131c7090d207"

}

Hi @Roberto Ialino

Thanks for providing more details.
Could you please share, if it is possible, the Adaptive Card output that was generated during the test or run (from the screenshot with error)? You can try to obfuscate/remove data from the text if it contains confidential information (i.e. user name/comment).

We suspect your Jira ticket can contain some specific data or special characters (i.e. some unicode characters from non US text) that cannot be parsed properly and it caused the failure. |

Additionally, you can try to send notification from some simple software development project in Jira (i.e. project having just summary, description without any specific custom fields).

Regards,
Volodymyr B.

Unfortunately, I don't see the 'When a Teams webhook request is received' trigger.

is this something that my MS admin has to allow?

scratch that. though I'm not able to save it without a trigger and one action. And that is not mentioned above.

Ignore me. Too much to read.

hi @Volodymyr Batrukh YES ! with a standard jira software it works so is the JSON Adapive Card that i need to check for my projects and resolve.

The output body is waht i shared and what you can see on my previous attahcment.

{

"error": {

"code": "BadRequest",

"message": "InvalidParameter",

"innerError": {

"code": "1",

"message": "Invalid format of cards property",

"date": "2024-08-09T08:52:09",

"request-id": "38dbb922-6172-4f51-8a9f-de0004ccc748",

"client-request-id": "38dbb922-6172-4f51-8a9f-de0004ccc748"

}

Thanks a lot!

Roberto

Hi @Roberto Ialino

If the notifications works for simple projects it seems there is some data in Jira tickets that can break the card. I.e. some special characters in issue Summary, or in comment or in changed values. We were testing cards for such issues, but seems not all cases are covered.

To do the further investigation could you please send as the data you have received here (please substitute sensitive data before posting content here):

Screenshot 2024-08-09 at 15.52.15.png

Another option you can do, copy the content of the adaptive card (from the screenshot above) that is failing to https://adaptivecards.io/designer/

Screenshot 2024-08-09 at 15.59.43.png

if the adaptive card is invalid, it will not be displayed and also you will see the error in the content that is causing issue (highlighted in red in the Card Payload Editor). Please share this line with us.

Regards,
Volodymyr B.

Hi @Volodymyr Batrukh and finally we resolved !!!!!!!!!!!!!!!!!!!

The error is on your JSON of the Adaptive Card at point 9 (see image below)

There was the property color with "inprogress" inside.

I changed it with "color": "Default"

Thanks a lot for your support.

Best regards,

Roberto

Immagine 2024-08-09 162245.png

@Roberto Ialino glad to hear that issue was fixed for you. Yeah, there are few available colors we can use in adaptive cards and if mapping doesn't fit it can break the card...

Thanks a lot for helping to identify the issue it will help other community members for sure. We will update the guide with up to date card schema.

Regards,
Volodymyr B.

Hi @Volodymyr Batrukh yes it could be useful for all. Thank you very much !

We also need to fix the fact that the arrival of the adaptive card on MS Teams does not play a sound (sound is on) and the notifications are not in the MS Teams activity list. I wll check on the next days.

Best regards,

Roberto

I'm very new to the teams workflow. I set this up following the instructions but when I went to test, I get:

Flow '1aab7615-3530-4f38-b836-d151a2b2db75' cannot be installed.

Can someone direct me as to how to proceed?

thanks.

Hi @Eric Sebian is too much generic this error. Please give more details o post a question on the power platform community https://community.powerplatform.com/

If you follow all the steps described by Zakhar should not happens unless you don't have a licence also free for power automate.

Best regards,

Roberto

I need a license for power automate?

this is what I have. But when I update a ticket in the comments, I get nothing.

Oh, and here is the web hook.

Hi @Eric Sebian is a bit hard to help you. Try to create andother diffeent flow (an easy flow) and check if you have the same error first. If yes probably better write to https://community.powerplatform.com/.

Best regards,

Roberto

Hi @Eric Sebian

The webhook for the first step "When a Teams webhook request is received" is generated only after saving the workflow. So you may not find the webhook url right after adding the step.

Regards,
Volodymyr B.

Gotcha. I figured that out, but it's still failing. Do I need MS power automate for this to work? MS Support is saying that I might.

@Eric Sebian Power Automate and flows should be automatically added if you have a license for Office 365 products (i.e. Teams). And you will need some additional PA license in order to use Premium triggers and actions in you flows, but it not the case for this tutorial.

Please follow this instruction and try to sign in to PA - https://learn.microsoft.com/en-us/power-automate/sign-up-sign-in. If your can find your created flow there, you should be good.

One more point that should be checked - the webhook URL from the first step should be encoded as it will not work in Jira (please check Jira logs for the errors. com.atlassian.webhooks should be enabled in Logging and Profiling):

HTTP POST URL should be decoded or all ‘%2F' should be replaced with the '/’, otherwise Jira Webhook will throw 403 error code

The domain for the webhook should be added to the Allow list in order to send data to the webhook. otherwise, it could be blocked.

For what I can see "Flow '' is not installed can happen when the flow is misconfiguration".

- Volodymyr B.

I have power automate. but not premium. see image.

@Eric Sebian we are not using PREMIUM actions for this flow, so your license should work properly.

As for the error you can see while trying to run the flow manually - it seems that is related to how Parse Json test run is working, as we should put the test data there (type - "object", attachments - JSON with Jira event). I can see this error as well even with using valid data that should be parsed.

If you are not seeing any data in run history for your flow I can assume the trigger is not working and you have never received any messages to that endpoint. And the reason for that can be - Jira Webhook is not sending data due to wrong URL, as it should be encoded (see my previous comment). Jira is blocking requests to the workflow generated domain (webhook URL domain from "When a Teams webhook request is received").

Regards,
Volodymyr B.

To test a flow without Jira you can use Postman and send POST request to the URL generated by the first step:

Screenshot 2024-08-14 at 18.36.19.png

with some test data:

{

"timestamp": 1721915955206,

"webhookEvent": "jira:issue_updated",

"issue_event_type_name": "issue_updated",

"user": {

"self": "https://localhost:2990/jira/rest/api/2/user?username=admin",

"name": "admin",

"key": "admin",

"emailAddress": "admin@test.com",

"avatarUrls": {

"48x48": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=48",

"24x24": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=24",

"16x16": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=16",

"32x32": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=32"

 },

"displayName": "Admin Admin",

"active": true,

"timeZone": "UTC"

 },

"issue": {

"id": "10219",

"self": "https://localhost:2990/jira/rest/api/2/issue/10219",

"key": "T-4",

"fields": {

"issuetype": {

"self": "https://localhost:2990/jira/rest/api/2/issuetype/10002",

"id": "10002",

"description": "A task that needs to be done.",

"iconUrl": "https://localhost:2990/jira/secure/viewavatar?size=xsmall&avatarId=10318&avatarType=issuetype",

"name": "Task",

"subtask": false,

"avatarId": 10318

 },

"timespent": null,

"project": {

"self": "https://localhost:2990/jira/rest/api/2/project/10401",

"id": "10401",

"key": "T",

"name": "Test project",

"projectTypeKey": "business",

"avatarUrls": {

"48x48": "https://localhost:2990/jira/secure/projectavatar?avatarId=10324",

"24x24": "https://localhost:2990/jira/secure/projectavatar?size=small&avatarId=10324",

"16x16": "https://localhost:2990/jira/secure/projectavatar?size=xsmall&avatarId=10324",

"32x32": "https://localhost:2990/jira/secure/projectavatar?size=medium&avatarId=10324"

 }

 },

"priority": {

"self": "https://localhost:2990/jira/rest/api/2/priority/2",

"iconUrl": "https://localhost:2990/jira/images/icons/priorities/high.svg",

"name": "High",

"id": "2"

 },

"assignee": {

"self": "https://localhost:2990/jira/rest/api/2/user?username=admin",

"name": "admin",

"key": "admin",

"emailAddress": "admin@test.com",

"avatarUrls": {

"48x48": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=48",

"24x24": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=24",

"16x16": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=16",

"32x32": "https://www.gravatar.com/avatar/dac3582b036e18b911d98494b925c9b7?d=mm&s=32"

 },

"displayName": "Admin Admin",

"active": true,

"timeZone": "UTC"

 },

"updated": "2024-07-25T13:59:15.201+0000",

"status": {

"self": "https://localhost:2990/jira/rest/api/2/status/10000",

"description": "",

"iconUrl": "https://localhost:2990/jira/",

"name": "To Do",

"id": "10000",

"statusCategory": {

"self": "https://localhost:2990/jira/rest/api/2/statuscategory/2",

"id": 2,

"key": "new",

"colorName": "default",

"name": "To Do"

 }

 },

"components": [],

"description": "Test description",

"summary": "Test summary",

 }

 },

"changelog": {

"id": "10442",

"items": [

 {

"field": "priority",

"fieldtype": "jira",

"from": "3",

"fromString": "Medium",

"to": "2",

"toString": "High"

 }

 ]

 }

}

If the flow works properly there is definitely an issue with Jira webhook configuration that cannot send the request.

- Volodymyr B.