Hi,
I am having some issues trying to figure this out:
When converting an email to HTLM, then removing the empty lines from the array I get something like this:
Note this is only a sample with the relevant information:
--------------------------------------------------------------------------------------------------------
"Nom",
"Doe",
"Prénom",
"John",
"Fonction",
--------------------------------------------------------------------------------------------------------
The value I am interested is "Doe" and "John", however when I try the "starts with" function I get this output:
So my question is: how can I get "Doe" instead of "Nom"? Can I select the string between "Nom" and "Prénom" to get that?
Thank you for your help !
Hi @SmittAuthy
I have given the answer based on your original query. Looks like you don't have consistent format of email body.
Thanks
Thank you @abm for your help!
I tried using the "outputs('Compose')" expression, however the emails received have the same layout, but sometimes have text before the information that I want to extract.
So the "outputs('Compose')" expression isn't working all the time.
-
My thinking was: maybe there is a way to get the "Nom" line number and extract text from the next line? Something like n+1?
Hi @SmittAuthy
Above you can see I have added the expression with index which is one and it should return Doe. The index starts from zero onwards.
So if you want Doe and John then you need to use the below expression
outputs('Compose')[1]
outputs('Compose')[3]
Thanks
stampcoin
51
Michael E. Gernaey
37
Super User 2025 Season 1
Chriddle
21
Super User 2025 Season 1