cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Parsing outlook subject

HI,

 

Saw several examples on the site, but none get me all the way to my solution and need

some help. 

 

I need to extract a 10 digit phone number in the subject , that immediatly follows the number (character)  1.  (see example below)

The callers name will vary in length, so I cannot count characters as my starting point.

 

  • I have a flow with a variable initialized as SUBJECT
  • Next I compose  split(triggerBody()?['Subject'],'1')
  • Finally, setting a variable as the output.  

 

New voicemail from Unavailable 19198012607*text blah blah variable length blah blah 

 

Any ideas on grabbing the 10 characters after the '1' ?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Parsing outlook subject

Found something  (the last post I read) that did just what I needed.  

 

https://powerusers.microsoft.com/t5/Building-Flows/extract-s-string-between-two-characters/td-p/8083...

 

Love the knowledge is houses in this community!  Thanks for making solutiuons a bit less stressful.

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Parsing outlook subject

Found something  (the last post I read) that did just what I needed.  

 

https://powerusers.microsoft.com/t5/Building-Flows/extract-s-string-between-two-characters/td-p/8083...

 

Love the knowledge is houses in this community!  Thanks for making solutiuons a bit less stressful.

View solution in original post

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,187)