Automating Order Processing with Power Automate

Our client’s customer posts their orders on a website and provides a link to an XML file containing the same order information. They needed a way to:

• Capture the order easily
• Compare the pricing on the order to their current pricing
• Notify the customer if their pricing was different

The EDI service provider keeps stringing us along to enable automatic file fetching. So, for the first phase, the user would email the XML file to a designated mailbox.

We set up a Microsoft Power Automate flow to:

• Read the XML file
• Return an Excel spreadsheet in an easy-to-paste format for their ordering system
• Email them the pricing differences

Not perfect yet, but getting there…