cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rsinha
Frequent Visitor

How to fetch specific part of an email body and forward

Hi folks,

we receive such email in our outlook (there is no attachment here, all details are in email body in tabular format):

--------------------------------------------------------------------------------------------

Subject: Onix File Distribution: Failure - Run #629

 

There were one or more failures. Check below. Also check logfiles listed below

 

Run

Started

Finished

629

2020-09-28 09:18:14

2020-09-28 09:39:15

 

 

This is a list of file 'patterns' that were looked for and any files that were found which matched those patterns. These are the files which would be sent. 'Overridden by' means that we did not look for that pattern, but looked for (and sent) that file instead.'

File Pattern

Overridden by

Actual File Found

Test1

Not Overridden

Details

 

Abstract

 

Vendor

Site

Transfer ID

File Pattern

Frequency

Result

Vendor 1

Site1  

45

Details 1

W

Succeeded

Vendor 2

Site 2

149

Details 2

W

Failed

Vendor 3

Site 31

177

Details 3

W

Succeeded

 

---------------------------------------------------------------------------------------
If you see, in the last Abstract table, there is a Failed value (I've marked in RED), and our requirement is to forward an email with only the associated values (like vendor name, site, file pattern etc.) against the Failed Result.

How can we achieve this through Power Automate, any thoughts.

 

Much thanks in advance.

Rachit

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @rsinha ,

 

Could you please share the output of the email body preview so we could take a try to reproduce the flow and provide the workaround?

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-alzhan-msft
Community Support
Community Support

Hi @rsinha ,

 

Could you please share the output of the email body preview so we could take a try to reproduce the flow and provide the workaround?

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,941)