Answered

Extract email subject from specific starting position

(0) Share

Report

Posted on by leoleo1

Hi,

I would like to extract email subject from specific starting position,

The email subject examples were as below:
BC1234-5678 #1234 document update
KT1234-5678 #3456 please file this document

I would like to extract the subject as marked in red in above examples (that is, starting from 6th position after # mark),
then which formula should I use?
Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @leoleo1,

Do you want to extract special strings from the subject?

If you the strings starts at the 6th position after # mark, I think you could always use the following formula:

substring(Last(split(outputs('Compose'),'#')),5)

Note that the Compose is where I save the email subject.

Was this reply helpful? Yes No
leoleo1 7 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply,
i tried to use "compose" function and then pasted the below formula:
substring(Last(split(outputs('triggerOutputs()?['body/subject']'),'#')),5)
However the system showed error.
May I know if its correct to use "compose" function? Or which function should I select in the flow.
(Sorry I am really new to this system...)

THank you!

Was this reply helpful? Yes No
leoleo1 7 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply,
i tried to use "compose" function and then pasted the below formula:
substring(Last(split(outputs('triggerOutputs()?['body/subject']'),'#')),5)
However the system showed error.

May I know if its correct to use "compose" function? Or which function should I select in the flow.
(Sorry I am really new to this system...)

THank you!

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @leoleo1,

Compose is a control instead of a function.

In my scenario, I put the subject from the email into a Compose control, so I could refer to compose directly.

Was this reply helpful? Yes No