From the upstream Order Management System, we recieve orders details over emails. Each email is for one order line item and the details of the order are in the excel attachment of the email. I am trying to use power automate to open the emails (.msg files) from the folder location on my desktop, read the excel file attachment and then copy the fields to create a new line entry in the CSV file. The purpose of this automation is to execute the orders as a batch by feeding this CSV file to a batch processing program.
The program output which I am getting from PowerAutomate is not achieving the desired outcome.
=====================
Retrieve the list of email files in the specified folder, loop through each email file, retrieve emails, save attachments, launch Excel and open the first attachment, copy cells, paste cells as transpose, save the Excel document as a CSV file, close the Excel instance
====================
Sample Excel Entry:
| Parameter Name |
Parameter Value |
| Network Slice ID |
NS-0000012345 |
| Order ID |
O-00001234 |
| Early Termination Fee |
Not present |
| Pricing plan name |
Plan 1 |
| Product Term Units |
monthly |
| Unique Product ID |
AB12 |
Sample CSV Entry:
Parameter Name,Network Slice ID,Order ID,Early Termination Fee,Pricing plan name,Product Term Units,Unique Product ID
Parameter Value,NS-0000012345,O-00001234,Not present,Plan 1,monthly,AB12
Parameter Value,NS-0000012346,O-00001235,Not present,Plan 2,monthly,AB12
Share
Report
All responses (
Answers (
525
