Parse an Email to find Part Numbers, then get their pricing from an Excel Sheet, and return the prices

[Anonymous]

Hello,

I have a product configurator that a customer uses. Once the customer is done with the configuration, they click a button which runs a Macro that sends a formatted email to me. I have an Excel sheet with prices that I need to use to Generate the prices. I am filtering by the subject line to only run when it sees the specific subject line "RTC Quote Request". 

The body of the email looks like this (generated from my macro so it will always stay the same):

Customer: XYZ Company

Name: John Smith

Part Numbers:

XYZ010RO-0000-9X7T-0000-9X8L

XYZ250RO-0000-XT-9X7T-00-0000-D1T6

So my first problem is that I need to get just the part number. (Inexperienced and having trouble, sorry). Then I need to parse the part number. The price of each part is made up from its components (either 5 or 7 components delineated by a "-"). I have an Excel sheet with a list of part numbers. So, XYZ010RO = $1000 dollars, 0000 = $0, 9X7T = $100, and so on. 

I am pretty well versed in VBA, but have never used Power Automate before. In my head, I think the solution would look like this, but please correct me if I am wrong.

1) Parse the email for the part numbers (could be 1 or could be 100) and add them to an array

2) Loop through the array and parse individual part numbers into segments to get pricing

3) Add that pricing to the part number

4) Return that array in a table format

Any help with my approach or help with the solution would be greatly appreciated.