Hi all,
I tried to send an email in a standardized way (they have all the same delimiter). My flow works fine. But when it's not a standardized delimiter ':', it fails. I have to skip some lines, because there is no delimiter, but the code is not working. I will make 2 flows one with ':' and another with '\n'.
I only need the variables with ':', all the rest is not important in this flow. This is what I tried:
- When a new email arrives V3
- Html to text (contains the body of the email)
- Compose email to body text (contains the body of html to text)
- Compose with the function:split(outputs('Compose_Email_Body_Text'), '')
- I initialized all my variables (name start with Var and they are all a string with no value)
- Compose ExtractData:last(split(outputs('Compose_Email_Body_Text'), '\n\n'))
- Then I extract all my variables withtrim(substring(split(outputs('ExtractData'), ': ')[1],0,indexOf(split(outputs('ExtractData'), ': ')[1], 'Numéro'))). I changed the [] for each code also the word that should be find for each Var. Here is the part where it sucks cause I have to skip some lines to get only those with the delimiter.
Setting up the variables and adding the output in the right column will work only if I am able to split it correctly.
Do you have any suggestions?
