Unanswered

Extracting data from an email body

(0) Share

Report

Posted on by Iridium

Hello,

I have a need in Flows to be able to grab some data from an email. I have watched a video on YouTube, but that was from a web address. I added in the steps etc to do what I needed, and testing it runs fine and the new email that triggers works perfectly.

I'm getting The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: <. Path '', line 0, position 0.'.

The flow is that... an email comes > converts html to text (I heard this was best) > pulls data > adds to file shrpnt

So basically, the data I am trying to pull looks like this in the email when it comes (blocked out for reasons):

But it returns with:

continuing...

and the data eventually comes here:

How can I find the data within the email to pull?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Iridium

Which email connector are you using? Could you also post a sample screenshot of your flow?

Thanks

Was this reply helpful? Yes No
Iridium 11 on at

Like (1)

Report
Copy link

Link copied!

Not sure what you mean by email connector, sorry, I am new to this.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Iridium

Thanks for your reply. There are different email connectors in Power Automate. Looks like you are using the Microsoft email connector.

Are you mapping the body like below?

Was this reply helpful? Yes No
Iridium 11 on at

Like (0)

Report
Copy link

Link copied!

Yes, exactly that

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Iridium

Could you please post a screen shot of your run history step convert to plain text?

Thanks

Was this reply helpful? Yes No
Iridium 11 on at

Like (1)

Report
Copy link

Link copied!

I only added that step, but I have changed it playing a little more whilst waiting...

and trying to use a similar style to here: https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new-rows-in-excel/m-p/105318#M10295

with: first(skip(split(first(split(body('Html_to_text'),'Name')),':'),1))

But the file literally brings back the code instead:

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Iridium

Thanks for the screenshot. I can see HTML to text removed the html tags. Could you post a sample text and explain what are the values you trying to extract?

Thanks

Was this reply helpful? Yes No