Hi @JohnShaw
This is what you could do.
First use the "When a new email arrives (V3)" trigger, you can filter the email by subject or specific sender to trigger the flow only with the email you want.
Then, initialize a string variable and just hit enter once on the value input.
Then, convert the body of the email to text using the "Html to text" action.
Next, using a "compose" action, (in my case named "Dealer" and "Car and Vin") enter the expressions below.
For Dealer
split(body('Html_to_text'),variables('enter'))[0]
For Car and Vin
split(body('Html_to_text'),variables('enter'))[4]
What these expressions do is separate the text into lines, using the "enter" variable that we declared earlier and then you select the lines at the end with the "[]".
Now finally you have to use the action "Add a row into a table", enter the Dealer value, but you need to separate the string "Car and VIN" again, this is what you need to do.
In Dealer input just select the Output from Dealer compose.
But for Car input, you have to enter these expressions.
split(outputs('Car_and_VIN_'),',')[0]
split(outputs('Car_and_VIN_'),',')[1]
split(outputs('Car_and_VIN_'),',')[2]
And for VIN
split(outputs('Car_and_VIN_'),',')[3]
It is the same logic that we used before, but now separating the value by commas.
I tried it and it worked, so it should work for you.
Hope this helps
Regards.
Community Support Team - Anthony Amador
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
