Unanswered

Search and return value from text

(0) Share

Report

Posted on by Shaebert

107

I am trying to extract the value "test" from the following text by searching for "First name:" There is a line break after "test" that should be used to help extract the value "test". Not shown below in the example is I have randomized text and a line break that occurs before "First name". Can anyone help me out?

First name:

test

Last name:

I have the same question (0)

All responses (6)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Search and return value from text

Hey @Shaebert

I did it like this:

Took your data in a compose.
Then initialized a string variable with an empty line.
Then used another compose. In that wrote the following expression:
split(outputs('Compose'),variables('A'))[1]
Output:

I hope this helps 🙂

Was this reply helpful? Yes No
Shaebert 107 on at

Like (0)

Report

Re: Search and return value from text

I forgot to mention. The order the data is entered can sometimes rearrange. So the next variation of the data could have the last name and first name switched.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Search and return value from text

@Shaebert

Compose 2 Expression:
split(outputs('Compose'),variables('A'))
Compose 5 Expression:
if(equals(outputs('Compose_2')[0],'First name:'),outputs('Compose_2')[1],outputs('Compose_2')[4])

Output:

I hope this will help. 🙂
Going to sleep now 5am here.
I hope I will get a thumbs up for this. Hehe 😉

Was this reply helpful? Yes No
Zak 8 on at

Like (0)

Report

Re: Search and return value from text

HI @Shaebert hope this will help
https://www.enjoysharepoint.com/power-automate-split-string-into-an-array/#:~:text=Power%20automate%20split%20string%20into%20array%20line%20break,-Here%20we%20will&text=In%20the%20Power%20automate%20click,click%20on%20the%20Next%20step.&text=Select%20the%20Initialize%20variable%20action,two%20spaces%20after%20the%20split.

Then utilize this functions:
Actions: Condition
Function: first(), split(),

Was this reply helpful? Yes No
Shaebert 107 on at

Like (0)

Report

Re: Search and return value from text

Hi Sundeep, no luck. I get the following error:

InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language expression 'if(equals(outputs('Compose')[0],'First name:'),outputs('Compose')[1],outputs('Compose')[4]) ' cannot be evaluated because array index '4' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

See the attached flow.

error-flow.png

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Search and return value from text

@Shaebert

In the image that you have posted, I see you have a link and its totally different from the sample you have given above.

Btw for yesterday, I had added one more word at the end:
First name:
test

Last name:
data

Can you please send that link here, I will give you another solution.

Was this reply helpful? Yes No