Solved: mid-substring ?

Stewartjohn100 · ‎10-29-2019

Hi to all,

As a non-programmer, I I need some help in extracting specific data from the following fields, Name, Email, Persona Type etc.

What I've found is to use substring, but the way I am using it finds only a fixed portion of the inputted name, which may not always suit, and so I need to tweak that so it goes as far as the shown in the 'html to text' data below.

This is what I found to extract the Name:

substring(Body('Html_to_text'),add(IndexOf(Body('Html_to_text'),'Name : '), 7),12)

</style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
Please find the access request details below 
 
 
Name : Lara Wire 
Email : <a href="mailto:lara.wire@test.com">lara.wire@test.com</a> 
Persona Type : Global Sales 
Country : Germany 
Company Name : Global Sales Corporation 
Title : Support Automation Architect 
Phone Number : +491823177123 
Request Access for : Sandbox, Production 
Justification for access : Need access for my job
</div>

Many thanks in advance.

John

abm · ‎10-29-2019

Hi @Stewartjohn100

You could do this in different ways. Please see below.

Following are the expressions I used:

first(split(variables('subject'),'Email'))

last(split(outputs('Compose'),'Name : '))

replace(outputs('Compose_2'),' ', '')

Test Result:

Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up

Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

abm · ‎10-29-2019

Hi @Stewartjohn100

You could do this in different ways. Please see below.

Following are the expressions I used:

first(split(variables('subject'),'Email'))

last(split(outputs('Compose'),'Name : '))

replace(outputs('Compose_2'),' ', '')

Test Result:

Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up

Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Stewartjohn100 · ‎10-30-2019

Many thanks @abm

I did have trouble spotting that the 'Compose 2' became 'Compose_2' in the expression, but now that I've found that, I'm on my way.

Thanks so much!!

Stewartjohn100 · ‎11-07-2019

Hi again @abm

wonder if you can help me once more.. the emails that are now arriving have changed (coming from another source), so I have in my 'Initialize Variable'

Name : Gerry Foxy </td>\r\n</tr>\r\n<tr>\r\n<td>
Email : gerry.foxy@abc.com</td>\r\n</tr>\r\n<tr>\r\n<td>

As a result I updated my Compose to

replace(outputs('Compose_2'),'</td>\r\n</tr>\r\n<tr>\r\n<td>', '') - but it does not replace anything.

The output of the Compose shows as

Gerry Foxy </td>
</tr>
<tr>
<td>

so I updated the Compose to be

replace(outputs('Compose_2'),'</td></tr><tr><td>', '') and this does not work.

My latest attempt is to remove a single </td> - which does work, but I'd have to create 3 additional Compose replacements to get me to the name only. Any better method to achieve the end result of just the name 'Gerry Foxy'

Any advice appreciated.

Regards

Outfoxed 😑

mid-substring ?

Helpful resources

Join us for Microsoft Power Platform Conference

A new place to submit your Ideas for Power Automate

Register for a Free Workshop

Ask your licensing questions at the Power Automate AMA!