I am new to this, and I am looking to pull data from a system generated email using Power Automate. The email format is always the same, but the amount of 'Errors' can vary. As per below:-
Date 6/10/23 Time 13.25 Input File /usr/tract/tmp/slorderin_ABH001_660303893_ET3327624.in
File Type TRACT - TRACT_EDI
EDI Format :
Our Customer ABH001 61HS04 Demo Customer ABH001 Jones, Miss Joe
Order No. 660303893
ERROR 90797 McV Jaffa Cake Snack Pack 20x4pack 1.00
ERROR **** Above product is discontinued - removed from order! ***
Our Customer ABH001 61HS04 Demo Customer ABH001 Jones, Miss Joe
Order No. 660303893
ERROR 8420 Diet Seven Up 7UP Cans 24x330ml 1.00
ERROR **** Above product is discontinued - removed from order! ***
Our Customer ABH001 61HS04 Demo Customer ABH001 Jones, Miss Joe
Order No. 660303893
ERROR 9351 Tango Diet Orange Cans 24x330ml 1.00
ERROR **** Above product is discontinued - removed from order! ***
Copy of full input file follows.....
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
We receive roughly 50 of these emails from our main system daily. I would like to pull the data from each error and save into an excel spreadsheet, that just adds a new line with every occurrence of these emails.
The customer and order number is the same for all errors in an email, which I can pull.
If anyone could help it would be greatly appreciated.
Cheers
Andrew
