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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (30,823)