Grabbing multiple URLs from an email to rehost content

[StrongholdSnail]

Hey all. I'm still a relative PowerAutomate newbie, but I've been charged with managing my team's automations. A lot of them are basically "get information, push it to Planner." I've already spent a decent amount of time learning about how to get information from Microsoft Form responses and passing those answers (along with their attachments) to Planner in the form of rehosting them on Sharepoint.

At the moment I'm looking to do the same with Jira; however, due to some hiccups, I'm having trouble conceptualizing how I do this. I'm kind of new to working with arrays and expressions, so please bear with me.

What I have so far:

• I have an automation from Jira that sends me the details of a ticket, along with a list of the URLs of the attachments.

What I've tried:

• I've tried putting the URLs in a bulleted list, or at least separated by <br>'s. I've then tried to get the URLs using substring() and replace(), like this tutorial. I realized I didn't know how to get all of the URLs, as there's a variable amount of attachments I might get.
• I've tried formatting the email and URLs like a table, then convert it to XML so that I might be able to reference it with xpath(), like in this tutorial. I had some issues with converting the table to XML, and I'm unsure of how I would have the automation "repeat until there are no more table rows to reference." Currently I have a data (via Compose) of a full HTML table, but using the xml() function on it gives me the same code as my input.

So at this point I'm unsure of where to start building, and could use help putting me in the right direction. In plain terms:

1. I need a cloud flow that, on email receipt, extracts URLs with the same start string (but not the same end string, since there are multiple file formats).
2. I need to be able to recognize when there's multiple URLs, and repeat actions until all have been covered
3. I need to take those URLs and rehost the content on Sharepoint (I believe I know how to do this)

My thoughts are:

1. Maybe I should be trying to convert the URL list into an array? I'm unsure of how to do that.
   1. I'm unsure of how to potentially do the steps of "repeat until list is done" on an array.
2. Maybe I should keep going with the table idea and figure out how to export it into XML properly?

Any help is appreciated. I currently do not have the power to license any external connectors like Encodian, so I would appreciate if these used the default connectors/functions of Power Automate.

[AlexEncodian]

@StrongholdSnail 

Try Encodian's Utility - Extract URL's from Text action which will extract all the URLs in the text provided as an array of URLs. 

Its also a Utility action (identified by "Utility" prefix) meaning it only consumes 0.05 Encodian credits. So a standard plan could do 10,000 extractions a month.

[StrongholdSnail]

From my original message:

I currently do not have the power to license any external connectors like Encodian, so I would appreciate if these used the default connectors/functions of Power Automate.

---

Would appreciate that you not try to promote yourself without reading.

[S-Venkadesh]

Hi @StrongholdSnail ,
It seems that you're having difficulty extracting URLs from the response content received from JIRA-Ticket. Could you please provide some screenshots of your work along with sample data illustrating where you're encountering this issue?
Best Regards,
Venkadesh Sundaramurthy

[StrongholdSnail]

Sorry, it isn't specifically from a Jira ticket. I have output attachment URLs from a Jira ticket into an email in plain text. An example of the email would look like:

---

A new ticket is in the Web Updates queue.

Reporter:
Email:

Title: Final test
Due:
Link: https://obfuscated.jirainstance.ca/browse/11649
Summary: Bacom ipsum.

Attachment	Link
foo1.png	https://obfuscated.jirainstance.ca/browse/foo1.png
foo2.png	https://obfuscated.jirainstance.ca/browse/foo2.png

---

I could also change the formatting above to have the URLs on their own lines, instead of a table.

[S-Venkadesh]

Hi @StrongholdSnail ,
I've created a flow based on the sample email you provided, and I'm now able to extract the URLs.
Please refer to the snapshot below for detailed steps and information.

Output :

I hope this information is helpful. If it is, please consider giving a thumbs up 👍.

Best regards,
Venkadesh Sundaramurthy

[StrongholdSnail]

Thanks! I'll try it out and see what happens.

[S-Venkadesh]

@StrongholdSnail 
Welcome! Don't forgot to hit the like button !!