cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BorislavB
New Member

Power Automate

Hello Team,

 

I receive daily email reports and not all of them are related to my daily duties. I'm stuck on finding a solution regarding the following topic. I want to build an Automated flow in which to filter those emails (filtering is the easiest part) and then to format them by leaving only the most important text and information in it. I am open to any suggestions and will appreciate your assistance regarding this topic.

 

Thank you in advance!

 

Best regards,

 

B.B

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @BorislavB ,

 

I have a template email.

vxiaochenmsft_0-1635400751573.png

I assume I want to get the string in module2. I created a flow.

 

vxiaochenmsft_1-1635400814780.png

trim(substring(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'Module2'),sub(indexOf(outputs('Html_to_text')?['body'],'Module3'),indexOf(outputs('Html_to_text')?['body'],'Module2'))))

 

vxiaochenmsft_2-1635400843530.png

 

Best Regards,

Wearsky

 

 

View solution in original post

4 REPLIES 4
v-xiaochen-msft
Community Support
Community Support

Hi @BorislavB ,

 

Could you tell me:

What's the most important text and information in your email body?

I think we can extract keywords from the text to filter important information.

 

Best Regards,

Wearsky

Hello @v-xiaochen-msft,

 

Thank you very much for the question.

 

I agree with the approach to filter the email by keyword. But the question here is how we can approach this action. I'm not able to provide the information in the email body, since this is confidential information, but I'll appreciate if you share with me some light regarding the mentioned keyword filtering. I'm currently trying to solve this by configuring the HTML to Text data operation and then composing the body with expressions. 

 

Stay safe and wish you all the best.

 

Best Regards,

 

B.B

v-xiaochen-msft
Community Support
Community Support

Hi @BorislavB ,

 

I have a template email.

vxiaochenmsft_0-1635400751573.png

I assume I want to get the string in module2. I created a flow.

 

vxiaochenmsft_1-1635400814780.png

trim(substring(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'Module2'),sub(indexOf(outputs('Html_to_text')?['body'],'Module3'),indexOf(outputs('Html_to_text')?['body'],'Module2'))))

 

vxiaochenmsft_2-1635400843530.png

 

Best Regards,

Wearsky

 

 

View solution in original post

BorislavB
New Member

Thank you so much @v-xiaochen-msft,

 

Stay safe!

 

Wish you all the best.

 

Kind Regards,

 

B. Borisov

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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