cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RamKan2021
Helper III
Helper III

How to read specific text in Email content in the email body using power automate

When Shared mailbox received email , Power automate should read specific text in Email Content.

 

Example : Below is the standard content in email body , But Bold Text will be changed for each incoming emails.

 

You have received request order , RS-123456 , by Vendor Team , FO-67888-FCI-000.

 

Thanks in Advance

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @RamKan2021 ,

 

Maybe you could try to extract other specific text by using some text in the body as delimiter according to the actual situation.

 

I have made a simple test for your reference.

trim(last(split(first(split(outputs('Html_to_text')?['body'],', by Vendor Team')),'You have received request order ,')))
trim(last(split(first(split(outputs('Html_to_text')?['body'],'Best Regards,')),'by Vendor Team ,')))
substring(outputs('Compose_2'),0,add(length(outputs('Compose_2')),-1))

vyujincuimsft_1-1663900517675.png

Result Screenshot:

vyujincuimsft_0-1663900451278.jpeg

Here is a link for your reference.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#...

 

 

Best Regards,

Charlie Choi

View solution in original post

1 REPLY 1
v-yujincui-msft
Community Support
Community Support

Hi @RamKan2021 ,

 

Maybe you could try to extract other specific text by using some text in the body as delimiter according to the actual situation.

 

I have made a simple test for your reference.

trim(last(split(first(split(outputs('Html_to_text')?['body'],', by Vendor Team')),'You have received request order ,')))
trim(last(split(first(split(outputs('Html_to_text')?['body'],'Best Regards,')),'by Vendor Team ,')))
substring(outputs('Compose_2'),0,add(length(outputs('Compose_2')),-1))

vyujincuimsft_1-1663900517675.png

Result Screenshot:

vyujincuimsft_0-1663900451278.jpeg

Here is a link for your reference.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#...

 

 

Best Regards,

Charlie Choi

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,547)