Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to get certain text from a text block and insert into Excel table

Posted on by
I'm trying to parse an email to an Excel table and I'm having a heck of a time with this.
 
The email is one of those forms with name, address, phone, etc. Unfortunately this form when emailed isn't in a nice easy format. It's just a big ball of text.
 
So instead of something nice like:
 
Name:  name
Address:  address
Phone:  phone
 
Here is what I have to parse and what I need to pull:
 
Name John DoeAddress 1234 State Rd
CityName, IN 12345
Map It
[https://us-east-2.protection.sophos.com?d=google.com&u=aHR0cHM6Ly9tYXBzLmdvb2dsZS5jb20vbWFwcz9xPTQyMjMrUGluZXMrUmQrUGFkdWNhaCUyQytLWSs0MjAwMQ==&i=NjIxNjk0MTY0Njg5MTcwZjM1MDQ4NTlj&t=Qzg3QXVnWGVGSkhOMlZvVVUzbVdVYjY4M3c2aFVSemIrbTBialFlbzlYMD0=&h=5bf5d12746274218ac6405001d549d1d&s=AVNPUEhUT0NFTkNSWVBUSVYdezzyoxQHANtG2Vn0DLx0dNf3R4EDjq4IiQdsOGBY9A]Phone 4105559874Email JohnDoe@gmail.comCurrent
Internet Provider ComcastWhen does your contract with your current internet
provider end? July 2025
 
These all go into an Excel table which is the easy part.
 
I have the email connector working as well as HTML to text action.
 
I'm having a real hard time understanding the syntax and how this split function works even after reading about 100 blogs on it. Still isn't clicking for me at all.
 
Any ideas? 

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard