web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : yeAysc5SiXXb9l7TsVuiF/
Power Platform Community / Forums / Power Automate - Building Flows / Extract text from body...
Power Automate - Building Flows
Unanswered

Extract text from body of an email and update excel table

Like (0) ShareShare
ReportReport
Posted on 8 Jan 2021 05:02:03 by paddy76 33

Hi all,

 

I am setting up a flow and having an issue that my table is not being updated.

 

1. Email arrives in my Office365 inbox

2.HTML to text. Content I have "body"

3.Add a row into table (should actually just update the row)

 

And it doesn't do anything except for adding a blank row:(

 

1.Works fine

2. Works fine, gives me: 

OPD:1234
IPD:1234
OR:1234

 

My expressions are 

first(skip(split(first(split(body('Html_to_text'),'OPD')),'OPD'),1))
first(skip(split(first(split(body('Html_to_text'),'IPD')),'IPD'),1))
first(skip(split(first(split(body('Html_to_text'),'OR')),'OR'),1))
 
3. A blank row is inserted 😞
 
Can someone please point me in the right direction 🙂 Thank you so much in advance for your help. Ideally I just want the table in my Excel Online table to be updated, as opposed to creating a new line.
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans