Import Mail Data to Excel with Power Automate

(1) Share

Report

Posted on by Minejumper

Hello to the Community,

I'm new into power automate and tried to import Mails to a table in an excel sheet

(just like this one: https://www.youtube.com/watch?v=OrCs36S3w3w)

I did it just like in the video, and it reacts, when i receive an email.

But i got troubles (for months) with the expressions to export the datas i need

The expressions are:

"Cookie Type" field:
first(skip(split(first(split(body('Html_to_text'),'Quantity')),': '),1))
"Quantity" field:
first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))
"Delivery Method" field:
first(skip(split(body('Html_to_text'),'Delivery Method: '),1))

Every time i get the message
"The input parameters of the action "Add_row_to_table" contain an invalid reference to "html_to_text". Make a correction to include a valid reference to "html_to_text" for the input parameters of the "Add_row_to_table" action."

i read many threads in other forums and tried different things, but nothing helped.

Would be great if someone could help me to solve this and learn, what the problem is❤️

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Minejumper Correct your Split() expression. it should be like this-

split(outputs('Html_to_text')?['body'],'Quantity')

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Verified answer

Minejumper 12 on at

Like (1)

Report
Copy link

Link copied!

Thank you, but this wasn't helpful for my problem.
But i got the (very dumb) solution....
I use Power Automate in german, so i have to write
first(skip(split(first(split(body('html_zu_text'),'Quantity')),':'),1))

I'm sorry, but thank you a lot!

Was this reply helpful? Yes No
paul0021 12 on at

Like (1)

Report
Copy link

Link copied!

I would like to import the beginning of text in an email to Excel. The message contains: Good morning. My name is Paweł. How are you. I would like to import the first two sentences.

Was this reply helpful? Yes No