Power Platform Community Forum Thread Details

I receive an email notification if something failed. I need to be able to parse the text in the email body to individual columns in Sharepoint.

This is the email body format.

Error code: 2

Error Message:

2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File

Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835

I want to parse it into columns in SP like this

Column Name in SP	Data to Parse
Error Code	2
Error Message	2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835
Payer Name (Comes from within the Body shown in red)	2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835
Type of Error	2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835