Extract multiple URL from Email body and creat multiple item in Sharepoint

[Ruben_Merino]

Hello

How can I take multiple url from Email and creat a item for each one of them.

I need in Sharepoint List creat a item for each on of them.

I traid this option https://powerusers.microsoft.com/t5/Building-Flows/Extract-URL-from-Email-body/td-p/690807, and it's work for 1 url but I don't how to iterate. 

[v-xiaochen-msft · Accepted solution]

Hi @Ruben_Merino ,

I did a test for you.

substring(variables('Var'),indexOf(variables('Var'),'http'),sub(add(indexOf(variables('Var'),'com'),3),indexOf(variables('Var'),'http')))

substring(variables('Var2'),add(indexOf(variables('Var2'),'com'),3))

The result is as follows:

Best Regards,

Wearsky

[Ruben_Merino]

Hi @v-xiaochen-msft 

First, thank for your help and supot. 

It's possible make than lenght of first substring don't stop in "com", and vary acordin to url.

For exemple, extract url as this:

[v-xiaochen-msft]

Hi @Ruben_Merino ,

If your url ending is dynamic ,it's difficult to get the url.

As you can see, my solution is based on the beginning and the ending of the url.

So, If I cannot find the regular pattern from the end of the url, can I find the regular pattern from the head?

Is there any regular pattern in the text in front of 'http'?

Best Regards,

Wearsky

[Ruben_Merino]

Hi @v-xiaochen-msft 

Thanks for answerme so fast.

Unfortunately there aren't any regular pattern. Some emails send only url and others some text before of URL.

[Ruben_Merino]

hi @v-xiaochen-msft 

In any case, thanks  a lot for your help and suport. 

Best Regards