How to extract a link from text in Approval comments ?

[matfenix]

Hello,

I have a flow where I create some website for the users after they correctly fill in the form. 
Then using the approval flow I we put some information in the comment section such as link to a website we just created.

In comment section of approval users will place some text and website to the newly created place.

I wish to extract (and place it to sharepoint list item where the data from form is placed) only the link to a website and not a full text + link. Is there a way to do it please?

[Expiscornovus · Accepted solution]

Hi @matfenix,

You could for example use a couple of split functions to split on the 'https://' part and the white space character directly after the link. I am also using an indexOf function to check if the comments actually contains a https hyperlink

Below is an example

if(equals(indexOf(items('Apply_to_each')?['comments'], 'https://'), -1), 'No hyperlink found', concat('https://', split(split(items('Apply_to_each')?['comments'], 'https://')[1], ' ')[0]))

[AlexEncodian]

@matfenix 

Encodian's Utility - Extract URL's from Text action will do this for you. It works for multiple links therefore returns an array. Simply use the first() function when referencing the output to get a single link.

FYI - Utility actions only consume 0.05 of an Encodian credit. Therefore a plan with 500 credits can do 10,000 extractions. Of Encodian's 150+ actions, Utility actions are identifiable by the prefix "Utility" in their name.

[matfenix]

thank you for your Suggestion:

Im getting error when saving a flow: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'.

[matfenix]

change to formula a bit to have "Foreach" instead Apply_to_each will test now

[matfenix]

I tested it and it works - almost there 🙂

is there a way also to make sure that if someone puts "Enter" after placing the link (and add some text)... formula will recognize that action and split as well? right now it does not recognize it  and getting output like this (im putting this link to sharepoint list column) https://insidetestingmind.something.com/martialarts\nEnjoy",

I need to make sure that after martialarts there is no "\nEnjoy",

[matfenix]

@Expiscornovus Thank you for all your help.

Could you advise how can I add do expresion to make sure that I remove some part from link? I need to remove few letters and "\" 5th one I think from the right end part of the link