Answered

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!

All responses (4)

Answers (1)

Silvio_Roessler 12 on at

Like (0)

Report

Re: Fix my first Outlook to Excel Flow

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.
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

Re: Fix my first Outlook to Excel Flow

Hi @Silvio_Roessler

Kindly mark it as solution if this helps

Let me know if you have any doubts
Silvio_Roessler 12 on at

Like (0)

Report

Re: Fix my first Outlook to Excel Flow

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

Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

Re: Fix my first Outlook to Excel Flow

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! 🙌