Greetings!!!
Many thanks to all those that post up questions and answers, just by searching this board I have been able to find a ton of solutions and inspirations!!
I found a great thread that has helped me create a flow to extract some text values from an email.
My Flow first converts the email to plain text using "HTML to text"
For example my incoming email contains;
Ticket ID# 8371
The function I'm using in Flow is
substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Ticket ID#'), 11),7)
The return is
8371
Later that chunk of text gets put in to a column in and Excel sheet hosted on Sharepoint.
OK, so all is well so far and I'm using the same function for other bites of data and I just modify my label along with the character counts.
My Challenge;
Its real easy for terms like Ticket ID, or Location cause I know what the max value will be.
I'm jammed on how to deal with other bites of data that could be only 10 characters in length, or it could also reach 500.
For example
Ticket ID# cause in some of my fields it could just be a simple 4-6 letter or someone could type out something much longer
I'm super n00b at using these expressions, but hoping someone could give me an example to work with.
I have full control of the incoming email, so my first instinct is that it would be great to somehow identify an opening and a closing "gate/bracket/iD"--- not sure what to call it, but basically a means to book end my data bites.
something like just capture the text you see in between;
Ticket ID#<start> 8371 <end>
hope this all makes sense!!
