Unanswered

Fix my first Outlook to Excel Flow

(0) Share

Report

Posted on by Silvio_Roessler

Hello everyone,

I have put together my first flow, which is supposed to transfer the values Test 1 to 4 from a test mail into an Excel file.

I followed the following tutorial: https://www.youtube.com/watch?v=OrCs36S3w3w

The flow looks like this:

Expressions for Test 1-4:

first(skip(split(first(split(body('Html_to_text'),'Test 1')),': '),1))

first(skip(split(first(split(body('Html_to_text'),'Test 2')),': '),1))

first(skip(split(first(split(body('Html_to_text'),'Test 3')),': '),1))

first(skip(split(first(split(body('Html_to_text'),'Test 4')),': '),1))

My Test Mail looks like this:

Unfortunately, the data is always transferred incorrectly, see screenshot.

Can anyone tell me why? I'm at a beginner Level but want to get better and better the next months. So Thank you very much for your help!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Try this updated expression:

Expression: trim(split(slice(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'Test 1'),indexOf(outputs('Html_to_text')?['body'],'Test 2')),':')?[1])

Expression:  trim(split(slice(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'Test 2'),indexOf(outputs('Html_to_text')?['body'],'Test 3')),':')?[1])

Expression:  trim(split(slice(outputs('Html_to_text')?['body'],indexOf(outputs('Html_to_text')?['body'],'Test 3'),indexOf(outputs('Html_to_text')?['body'],'Test 4')),':')?[1])

Expression:  trim(last(split(outputs('Html_to_text')?['body'],':')))

Note: Logic for extracting test 1, test2, test3 values is by getting substring b/w Test 1 and Test 2 and then doing split for test1 values simmilar approach for other two,

for test 4, split by : and then taking last value 🙂

Hope it helps

see the result



Mail body formats used for testing

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Silvio_Roessler 12 on at

Like (0)

Report

Thanks a lot for your fast answer! That worked! Now I will try to understand the code itself a bit more.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Silvio_Roessler

Kindly mark it as solution if this helps

Let me know if you have any doubts

Was this reply helpful? Yes No
Silvio_Roessler 12 on at

Like (0)

Report

Thank you so far for your help! I marked the answer as a solution. I would be happy if I can ask you some questions again in the future.

Was this reply helpful? Yes No