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:
- 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).
- I need to be able to recognize when there's multiple URLs, and repeat actions until all have been covered
- I need to take those URLs and rehost the content on Sharepoint (I believe I know how to do this)
My thoughts are:
- Maybe I should be trying to convert the URL list into an array? I'm unsure of how to do that.
- I'm unsure of how to potentially do the steps of "repeat until list is done" on an array.
- 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.
