Hi Power Automate Community,
I have a flow that is set to read incoming email body. it takes that body and splits it and extracts the data. its rather long roughly 37 different lines after being split. I have changed the flow to adjust for the first example that has come in, however after the second email came in there was slight difference in the layout. The reason was in a segment to be read there was less data.
for example.
[0] Address line 1
[1] address line 2
[2] address line 3
[3] city, state zipcode
[4] contact information
[5]
[6] Order Information
[7] TCN: ### ### ###
[8]
[9] CLIN details
[10] 1 #### #### ##### ##### ####
in this example. i set the data to be reading the address data and CLIN details (order details). but in the second email i received. instead of CLIN being line [10] it was line [8]. the reason was that the address was in the US vs international and the fields were 2 less.
my original thought would be to get a total line count, but then i thought maybe i just need to search for a specific text, and now i'm wondering if its just an international vs US shipping address format and i build a split?
Thoughts, comments help is apprecia