cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

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