Images uploaded to a Microsoft form connected to Jira by a Flow do not show up in Jira ticket.

Question

I have a simple form created in Office 365 where people can upload attachments, including images. This form is connected to Jira through a microsoft flow. The ticket creation is working great, however the image appears as an un-clickable URL rather than as an image. Is there any way to make this appear in the ticket?

Jason D_5bgj82 · Answer

[{"name":"image.png","link":"https://my.sharepoint.com/personal/user/Documents/Applications/Microsoft%20Forms/Create%20Issue%20(Jira)/Question/ image.png","id":"01K5HU62TE4MGT47UVC7JCKPHBUBVFDAYOP","type":null,"size":312201,"referenceId":"01K5HU262XESD3LAI6P7ND35VX3RPKGBU46","driveId":"b!8o22RPSOaAJ0qcracV3D5hmFBuJJu02MtOrTbn4g4lWYnc5jstatkdA"," uploadSessionUrl":null}]

Can someone support with just extracting the https link from the string of text with power automate.  I was looking to use the "slice" function and point to the start of the string with "https:" and the end to the string with ".png" .   Is this a viable option to extract the https url?

Sylvia Taube · Answer

ended up being able to parse the attachments collected using:

{    "type": "array",    "items": {        "type": "object",        "properties": {            "name": {                "type": "string"            },            "link": {                "type": "string"            },            "id": {                "type": "string"            },            "type": {},            "size": {                "type": "integer"            },            "referenceId": {                "type": "string"            },            "driveId": {                "type": "string"            },            "status": {                "type": "integer"            },            "uploadSessionUrl": {}        },        "required": [            "name",            "link",            "id",            "type",            "size",            "referenceId",            "driveId",            "status",            "uploadSessionUrl"        ]    }}Then using the response 'id' in the 'Get file content module then used that in the Post call {
"$content-type": "multipart/form-data",
"$multipart": [
{
"headers": {
"Content-Disposition": "form-data; name=\"file\"; filename=NAME"
},
"body": @{body('Get_file_content')}
}
]
}

David Gabaldón · Answer

Hi Sarah.

In the Power Automate flow you can put in the 'Create a new issue' step that put what it retrieves from the Attachment field and it will write something like this:

[{"name":"image.png","link":"https://my.sharepoint.com/personal/user/Documents/Applications/Microsoft%20Forms/Create%20Issue%20(Jira)/Question/ image.png","id":"01K5HU62TE4MGT47UVC7JCKPHBUBVFDAYOP","type":null,"size":312201,"referenceId":"01K5HU262XESD3LAI6P7ND35VX3RPKGBU46","driveId":"b!8o22RPSOaAJ0qcracV3D5hmFBuJJu02MtOrTbn4g4lWYnc5jstatkdA"," uploadSessionUrl":null}]
Link paremeter is the URL to the image.

In Jira you can create a job with scriptrunner that is launched with the 'Crete Issue' event, which collects the previous text, takes the link value to put it in the description and that way it will be a working URL.