web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract a certain word...

Power Automate

Unanswered

Extract a certain word from Html to text

(0) Share

Report

Report

Posted on by AK89

49

Hello everyone,

I need your help please.

I am building a glow triggered by 'When a new email arrives' and my 'Html_to_text' looks like this

Accident Report AB123456, number L12345 TAB1234 NEG

I need to extract the word NEG and add it to the excel.

The email comes from different sources, so the extracted word may be NEG or Major or Minor.

Thank you in advance.

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @AK89 ，

Please reference this test.

last(split(outputs('Html_to_text')?['body'],' '))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
AK89 49 on at

Like (0)

Report
That is a subject of the email, and unfortunately it has no certain structure, for example it can have be
... TAB1234 -NEG or
... TAB1234 *** NEG ext. That's why I can not use trim function in this flow.

Was this reply helpful? Yes No
AK89 49 on at

Like (0)

Report

It works thank you so much

Was this reply helpful? Yes No

Join the conversation