Apply a large language model by Producing LLM$-$based solutions in Microsoft Power Automate

Extract:

shoe$\_$agent$\_$name $($this is Jim$)$

request$\_$type $($this is "Order"$)$

shoe$\_$brand, shoe$\_$model, shoe$\_$quantity

customer$\_$name

customer$\_$street

customer$\_$city

customer$\_$state

customer$\_$zip

customer$\_$phone

In addition, you'll assign a shoe$\_$price for each shoe, calculate the shoe$\_$subtotal for each shoe, and then the grand$\_$total.

Use one or more prompts to accomplish this extraction.

Then, save each line item in an Excel worksheet.

FROM THE EMAIL TEXT BELOW

Hey Jim,

I$\text{'}$d like to order some new shoes. Please ship the following:

Nike Air Jordan I $-2$ pair

Converse All$-$Star $-10$ pair

New Balance $990-1$ pair

Nike Zoom Fly $5$ men's red $-2$ pair

Please provide sub$-$totals and grand total cost.

Thanks.

Lance Gentry

$123$ Main St$.$

Chelsea, MI $48109$

$248-229-2229$