I will first state what I have working and then ask how I can replicate this in a similar flow. The only difference is instead of extracting the last item in a Subject, I would like to extract a value that will be in the middle of a Subject String.
When I receive an email the subject is: Your Workgroup has been assigned Incident: (Incident Number)
Items are as follows:
Set Variable: outputs('Compose')?
This works to always grab the Incident Number that will always be after the ":" in the subject
Help I need:
I have another flow which I would like to do the exact same steps on but this time only grab a portion of that Subject and then Output it.
Example Subject: Catalog Task SCTASK0030103 has been assigned to group
How can I configure my variables so it only extracts the number betweeen "Task" and "has". I need the output to always just only grab that value that will be between those 2 words. I have highlighted what I would like it to extract and transfer to a Output.
if it helps this then goes out to an Excel sheet and add's a row containing Date and Time and then Ticket Number which would be where I need the output to go out to and paste that value in there.
Solved! Go to Solution.
@abm I'm just about to test it but would that output still need to be called upon using outputs('Compose')?
I'd like to use that output on an excel row so just making sure the output will still display if I use outputs('Compose')? to reference it.
That's exactly I suggested in my previous post.
If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!