Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Extract text from body of an email and update excel table

(0) ShareShare
ReportReport
Posted on by 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.

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

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1